0 Replies Latest reply on Dec 19, 2006 2:16 PM by maheshvanamula

    DB2 Database connection error

    maheshvanamula

      I am currently facing the 'DB2 Database connectivitty' issue with the 'DB2' database. Trying to connect to the 'DB2 UDB iSeries V5R3', but it gives the error as

      org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.ibm.as400.access.AS400JDBCDriver, url: jdbc:as400://3.11.96.3/GETSJDE); -

      am using a JSP page to test the connectivity. The first request to the database connection will not work. However, When i refresh the JSP and then the connection works fine.

      Please visit to the URL : http://:<port_number>/DB2ConnectionTest.jsp

      Let me know if you have any resolution.

      Here is the datasource details of the database.

      <no-tx-datasource>
      <jndi-name>DB2Pool</jndi-name>
      <connection-url>jdbc:as400://3.11.96.3/GETSJDE</connection-url>
      <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
      <user-name>guest</user-name>

      </no-tx-datasource>

      Please provide the resolution.