This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes JDBC 2.0 And DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC 2.0 And DB2" Watch "JDBC 2.0 And DB2" New topic

JDBC 2.0 And DB2

Surya Bahadur
Ranch Hand

Joined: Sep 28, 2000
Posts: 88
Hi Guys
I am trying to test my program by using the JDBC 2.0 executeBatch method of the prepared statement on DB2(NT).I am using JDK 1.2.2 On WindowsNT.The problem is when i run the program it gives me the error message saying
java.sql.SQLException: [IBM][JDBC Driver] CLI0625E You specified JDBC 1.22 behavior; cannot use JDBC 2.0 functions.
So i went into the directory where DB2 is installed and under that ran the batch program useJdbc2.bat(After reading it from the IBM's site),but it didn't help the matters much.So can some one please tell me like where should i specify that use JDBC 2.0
instead of JDBC 1.22.Waiting for your answers.....
Julio Lopez

Joined: Nov 14, 2000
Posts: 28
Before you run useJdbc2.bat make sure all the DB/2 services are shut down. Also make sure that this is done on both the server and client machine.
Julio Lopez
M-Group Systems
Surya Bahadur
Ranch Hand

Joined: Sep 28, 2000
Posts: 88
Hi Julio
Thanks a lot,i really appreciate it,when i ran the usejdbc2 on both the client and the server,it worked fine.
jQuery in Action, 2nd edition
subject: JDBC 2.0 And DB2
Similar Threads
how to use Scrollable ResultSet on WebSphere 4.0
anyone experienced upgrading from 1.22 to 2.0?
Commit Rollback not working
SQL's Execution from Springs taking long time.