The AS400 has it's own JDBC driver, which talks to a different set of background jobs on the AS400. They are (in theory) more efficient that the DRDA jobs which the normal DB2 driver uses when talking to the AS400.
Abou Lina (or Lina Abou - sorry not, sure which way round your names go) : what is the error reported ? Full stacktrace would be useful. Is the toolbox driver definitely on the class path ? (jt400.jar) Cheers, Charles. -----Original Message----- From: Geigl Maximilian, R235 [mailto:[EMAIL PROTECTED] Sent: 06 April 2006 14:16 To: OJB Users List Subject: AW: OJB : DB2 NATIVE JDBC DRIVER Hi, don't know if i understand you correctly (what is the native driver?), but maybe ... We used the type 2 jdbc driver with DB/2 v7 - DB/2 client must be installed - we had to set some environment variables for the tomcat DB2DIR=%Db2dir%/sqllib; export DB2DIR DB2INSTANCE=%%Db2instance%%; export DB2INSTANCE LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$DB2DIR/lib; export LD_LIBRARY_PATH - CATALOG the NODE and the DATABASE with the client - our connection decriptor: protocol="jdbc" subprotocol="db2" dbalias="%%Dbinstances%%" where %%Dbinstances%% is the alias configured with the CATALOG command Maybe you set the envitonment in a tomcat startup script so this works and maybe you have to set the same environment for the java startup skript for your java application. Now we use the type driver for DB/2 v8 and everything is much easier: - driver: com.ibm.db2.jcc.DB2Driver - our connection decriptor: protocol="jdbc" subprotocol="db2" dbalias="//<server>:<port>/<dataBaseName>" - get the two jar Files: db2jcc.jar and db2jcc_license_cu.jar (e.g. from a server or client installation) copy it in your classpath or set the classpath accordingly - no environment settings needed Sorry if this is beyond your problem, but maybe it helped Regards Max MfG Max Geigl Tel. : 1752 eMail: [EMAIL PROTECTED] > -----Ursprüngliche Nachricht----- > Von: ABOU LINA [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 6. April 2006 13:20 > An: OJB Users List > Betreff: OJB : DB2 NATIVE JDBC DRIVER > > > Hi; > > i use the native jdbc driver for DB2/AS400. > > i configure the ojb connection parameters like this : > dbms=Db2 > jdbc-level=2.0 > driver=com.ibm.db2.jdbc.app.DB2Driver > protocol=jdbc > sub-protocol=db2 > db-alias=localhost/DB2ADMIN > user=test > password=*** > > so with this configuration the web application make > connection succusfuly > but with java application ojb > could not borrow connection. !!! > > Thx in advance. > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ___________________________________________________________ HPD Software Ltd. - Helping Business Finance Business Email terms and conditions: www.hpdsoftware.com/disclaimer --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
