tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sudip shrestha" <sdip...@hotmail.com>
Subject AS/400 DB2
Date Mon, 11 Oct 2004 16:46:24 GMT
Hi !

I am trying to connect to an AS/400 DB2 via IBM DataDirect JDBC 
Driver....Wondering if anybody has any experience with this.
You have to specify a location and collectionId attribute.  My url 
connection string looks like this:
"jdbc:datadirect:db2://serverName:50000;Location=nameOfDatabase;CollectionId=DEFAULT;"

I am providing a 'existing' database name [termed as library in AS/400 
language] as nameOfDatabase in the string..but the exception thrown is:
-------------------------------------------------------------------------------------------------------------------------------------
java.sql.SQLException: [DataDirect][DB2 JDBC Driver]An invalid databaseName 
was specified.
        at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown 
Source)
        at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.ddtek.jdbc.db2.DB2ImplConnection.open(Unknown Source)
        at com.ddtek.jdbc.base.BaseConnection.connect(Unknown Source)
        at com.ddtek.jdbc.base.BaseConnection.setupImplConnection(Unknown 
Source)
        at com.ddtek.jdbc.base.BaseConnection.open(Unknown Source)
        at com.ddtek.jdbc.base.BaseDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at ddJdbcTest.main(ddJdbcTest.java:29)
-------------------------------------------------------------------------------------------------------------------------------------
So, it seems to make a connection but fails to find that database which does 
exists!  Is there something else to this?  If anybody else has any 
experience, please let me know!

Thanx,
Sudip Shrestha



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


Mime
View raw message