db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Gray" <Dave_G...@versata.com>
Subject RE: Problem with configuration for DB2
Date Fri, 03 Dec 2004 12:53:55 GMT
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: Michael.Kashambuzi@bmwna.com [mailto:Michael.Kashambuzi@bmwna.com]

Sent: Thursday, December 02, 2004 4:50 PM
To: torque-user@db.apache.org
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:Dave_Gray@versata.com]
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: Michael.Kashambuzi@bmwna.com [mailto:Michael.Kashambuzi@bmwna.com]

Sent: Thursday, December 02, 2004 4:24 PM
To: torque-user@db.apache.org
Subject: RE: Problem with configuration for DB2

Dave:

Are you using the JDBC 2.0 driver?

Michael

-----Original Message-----
From: Dave Gray [mailto:Dave_Gray@versata.com]
Sent: Thursday, December 02, 2004 3:06 PM
To: torque-user@db.apache.org
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message