Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC 2.0 And DB2

 
Surya Bahadur
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.....
Surya
 
Julio Lopez
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 88
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Julio
Thanks a lot,i really appreciate it,when i ran the usejdbc2 on both the client and the server,it worked fine.
Surya
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic