Russel, For DB2 JDBC 2.0 , there is a command under sqllib\java12\usejdbc2.bat or sh
this will change the driver from 1.x to 2.0 JDBC, now take the newly updated driver file db2java.zip and added to your OJB lib directory , I think this should help on that. I have used DB2 7.2 (FixPack 3.0) to test some OJB builds and they are working as a JDBC2.0 my 2 cents marcos oliva -----Original Message----- From: Russell Smyth [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:18 AM To: OJB Users List (E-mail) Subject: DB2 usage and concerns I have some questions for those of you using OJB with IBM DB2 7.x. It will be a requirement of my project to be able to work (well) with DB2, however, I have already run into some problems. It appears that OJB does not support DB2 as a JDBC 2.0 database, but only as a 1.X db. Is this true? I would assume it is due to some incomplete support in DB2 (ie ResultSet.last() and ResultSet.absolute() are inconsitent with the OJB assumptions) For those using DB2 in applictations, without JDBC 2, you cannot do org.apache.ojb.broker.query.Query.setStartAtIndex/setEndAtIndex. Does anyone have a (clean) workaround? Is anyone using an alternative DB2 JDBC 2 Driver that would allow using OJB in JDBC 2 mode? Thanks in advance Russell -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
