0

I am trying to use jboss eap 6.4 with ibm sdk 1.8. I am trying to create a datasource which is a DB2 connection. However, when i try to do a test connection, it fails with the message -

Internal Server Error
{
    "outcome" => "failed",
    "failure-description" => "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid",
    "rolled-back" => true
}

The same works absolutely fine with ibm sdk 1.7. I have read online that jboss 6.4 does support 1.8 java version. Wondering what the issue is.. attaching my standalone.xml code which has the datasource configuration mentioned -

<datasource jta="false" jndi-name="java:jboss/datasources/APPDS" pool-name="APPDS" enabled="true" use-ccm="false">
                    <connection-url>jdbc:db2://<ip>:<port>/APPDEV:currentSchema=DB2INS;sslConnection=true;</connection-url>
                    <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
                    <driver>db2jcc4.jar</driver>
                    <security>
                        <user-name>appdev</user-name>
                        <password>password</password>
                    </security>
                    <validation>
                        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2ValidConnectionChecker"/>
                        <check-valid-connection-sql>select current timestamp from sysibm.sysdummy1</check-valid-connection-sql>
                        <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2StaleConnectionChecker"/>
                        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2ExceptionSorter"/>
                    </validation>
                    <statement>
                        <share-prepared-statements>false</share-prepared-statements>
                    </statement>
                </datasource>
deepc554
  • 21
  • 2

0 Answers0