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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
