Hi all,
I tried to use Merant driver (type 4) from they package "all in one" to connect to DB2 v7.1 from Jboss.
There are some exceptions:
16:17:24,593 ERROR [jdbc/INFRA] Unable to create ManagedConnection: javax.resource.ResourceException: Unable to create DB connection for url: jdbc:d
b2://rs6000:50000, user: jpyx, exception: java.sql.SQLException: [MERANT][DB2 JD
BC Driver][DB2] Connection Error: Property Name [locationName] not specified
at org.jboss.resource.adapter.jdbc.local.JDBCManagedConnectionFactory.cr
eateManagedConnection(JDBCManagedConnectionFactory.java:392)
.........
Here is db2_service.xml file:
ConnectionURL=jdbc:db2://rs6000:50000
DriverClass=com.merant.datadirect.jdbc.db2.DB2Driver
databaseName=JPYX
LocationName=null
UserName=xx
Password=xx
We tried different types of attribute setting like: LocationName=null, locationName=null, databaseName=JPYX;locationName=null (two parametetrs in one string) or like that null
Is it possible that something in the ResourceAdapter realization or in the driver class doesn't give a possibility set up this "optional"(used for OS/390) attribute and to connect to the DB. With db2java.zip it's OK.
Give a clue, how it possible ?
Thanks