Michael The version of DB2 I installed UDB8 (v8.2) only has a SQLLIB\java\ directory, no SQLLIB\java12\. This directory has no file called "inuse" but already contains db2java.zip. I copied this to \torque-gen-3.1\lib. It was not recognized until I renamed it db2java.jar. Once I did that I got the message "DB driver sucessfuly instantiated" but also got the "No suitable driver" exception. These appear to be contradictory. Dave
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 4:50 PM To: [EMAIL PROTECTED] Subject: RE: Problem with configuration for DB2 Dave- I think you need to be using the JDBC 2.0 driver which has a DB2 implementation of DataSource. Check in your SQLLIB\java12\ directory for a file called inuse. If this file does not say JDBC 2.0, you will need to run the usejdbc2.bat script to move the db2java.zip for JDBC 2.0 to your SQLLIB\java directory. Also be sure to copy this JAR into the location which is referenced your build-torque.xml ant script. Michael -----Original Message----- From: Dave Gray [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 3:28 PM To: Apache Torque Users List Subject: RE: Problem with configuration for DB2 I am using the type 2 driver: COM.ibm.db2.jdbc.app.DB2Driver and the url: jdbc:db2:SAMPLE -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 4:24 PM To: [EMAIL PROTECTED] Subject: RE: Problem with configuration for DB2 Dave: Are you using the JDBC 2.0 driver? Michael -----Original Message----- From: Dave Gray [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 3:06 PM To: [EMAIL PROTECTED] Subject: Problem with configuration for DB2 I have been using Torque with MSSQL. We need to support multiple database types so I am testing our apps with other databases. When I try to run against DB2 8.2 I get the following output: ---------------------------------------------------------------- C:\torque-gen-3.1>ant -f=build-torque.xml jdbc Buildfile: build-torque.xml jdbc: [echo] +-----------------------------------------------+ [echo] | | [echo] | Generating XML from JDBC connection ! | [echo] | | [echo] +-----------------------------------------------+ [torque-jdbc-transform] Torque - JDBCToXMLSchema starting [torque-jdbc-transform] Your DB settings are: [torque-jdbc-transform] driver : COM.ibm.db2.jdbc.app.DB2Driver [torque-jdbc-transform] URL : jdbc:db2:SAMPLE [torque-jdbc-transform] user : dgray [torque-jdbc-transform] schema : dgray [torque-jdbc-transform] DB driver sucessfuly instantiated BUILD FAILED C:\torque-gen-3.1\build-torque.xml:340: java.sql.SQLException: No suitable driver ----------------------------------------- My build.properties file look like: ----------------------------------------- torque.project = DB2Test torque.database = db2 torque.database.schema = dgray torque.schema.dir = db2schema torque.database.buildUrl = jdbc:db2:SAMPLE torque.database.url = jdbc:db2:SAMPLE torque.database.driver = COM.ibm.db2.jdbc.app.DB2Driver torque.database.user = dgray torque.database.password = xxxxxxxxxxxxxx torque.database.host = xxxxxxxxxxxxxxxx -------------------------------------- Any suggestions on what the problem is? Thanks, Dave --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
