0 Replies Latest reply on Mar 7, 2002 9:39 AM by Blandger

    Merant driver configuration problem with 3.0b

    Blandger Newbie

      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