How to connect to database using java service

[reamon]

Would suggest using the JDBC adapter that is bundled with Integration Server to perform database operations. There is no need to drop to Java code to do these sorts of operations.

[Yemi_Bedu]

Hello,

Would this give a performance overhead in a call to the database server? Not specifically using the whole code setup above, but just a single string update call. I mean compared to having things setup under IS with minimum pools set to zero? Ganesh, why would you use such a complex setup? You are hardcoding all that you need separately, why not make it a single statement. You don’t have to use the insert adapter, you can use dynamic sql. I use that for 97% of my database work. The other 3% is for things that I made a while ago that I have not made time to go make over. Good day.

Yemi Bedu

[ganeshgadi]

Thanks.
We can do that using adapter service.
But I want to do that in a java service.
I just want a simple code to connect to Oracle using externally java service.

Thanks,
Ganesh

[puneetverma]

Ganesh,
The reson it is not finding those classes might be because you have not set the classpath properly for IS to pick up the java classes.Are other java services running on your IS with import statement?Also some changes need to be made to your code.I think you need to give userid and password in commas.Also con has a setAutoCommit method and not AutoCommit i guess.Again in prepared statement first setString enclose “3” in commas and in last setInt you need to set some integer value as you are using setInt and not setString.

Enclose the code in try-catch block also for exceptions to be caught.

But as pointed out by everyone here use JDBC Adapter in your services.Maintaining this java code for connection will be a headache going forward.If you just want to do it for practice then use the above mentioned steps.

HTH…

Thanks,
Puneet Verma

[ganeshgadi]

Thanks to all,

Compilled without any errors.
But i’m getting runtime error:

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver.class not found.

For this, should i set any class path?
Are there any settings in webMethods to copy classes12.jar file?
What would be the solution?

Thanks,
Ganesh

[puneetverma]

Ganesh,
Put the classes12.jar in your <wm_root>/IntegrationServer/lib/jars folder and restart your Integration Server.Check in the Administrator Screen–> About link(at top right hand corner) and see if it is showing the jar file there.

HTH…

Thanks,
Puneet Verma

[reamon]

Ganesh, is this just an academic attempt to see if this can be done? Or are you trying to do this for a real solution that will be used in a production environment? If the latter, I would strongly suggest that you don’t do it this way.

[ganeshgadi]

Thanks Puneet.
I got it.

Thanks,
Ganesh

[ychang]

Following up on what Rob is saying, writing Java for things that can be done much easier w/Flow services is just asking for trouble – especially for whoever’s going to be maintaining the system. I’ve done way more than my share of cleaning up the mess left by other consultant (people who do projects for consultant company w/o wM people on-staff), and it’s normally these Java services that 1) causes hellishly untraceable problems, and 2) makes the system difficult to understand for a “real” webMethods guy.

The reason most people have for writing Java services is just this – unfamiliarity with webMethods.