How to use JDBC to get access to a database in a java program?
Posted on 2004-08-11
The Java program is to be used as an executable and placed in a bat file to be a schedued process. I do not know what type driver I should use. I'm thinking Type 3. Is that the correct way? The Type 3 driver where it is a native protocol where all java driver converts JDBC calls into a native DBMS protocol. Since this conversion takes place on the server side , no installation is required on the client machine. As a result will it be ok for me to acces this way. Can I get an example of connecting to a database using this approach.
I get confused whether a Ssession object is to be used or not. Also when I connect the server side, does that mean I can still use server-side java code in a program that is to be run as a batch job? I will make the connection into a class, then I will access the
database tables in another java program.
The code will be written in WebSphere. But does that mean I can still do a batch job that will be scheduled with a scheduler or an AT command?