JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid

[scot sackett]

'm new to JBOSS. I have setup up a JDBC Data source and tested the connection. Test connection was successful. Now I'm having an issue testing the XA Data source.

Any help would be appreciated.

getting the following error message....

server as7.1

JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid



below is the setup in my standalone-full.xml



<xa-datasource jndi-name="java:jboss/datasources/webDS_XA" pool-name="webDS_XA" enabled="true" use-ccm="false"> <xa-datasource-property name="ServerName">localhost</xa-datasource-property> <xa-datasource-property name="DatabaseName">shen01</xa-datasource-property> <xa-datasource-property name="Username">test</xa-datasource-property> <xa-datasource-property name="Password">xxx</xa-datasource-property> <xa-datasource-property name="ConnectionPoolEnabled">true</xa-datasource-property> <xa-datasource-property name="SourceConnectionTestInterval">600</xa-datasource-property> <driver>as400driverXA</driver> <new-connection-sql>jdbc:as400://shen01;naming=system;errors=full;libraries=, imgtstobj;</new-connection-sql> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <xa-pool> <min-pool-size>1</min-pool-size> <max-pool-size>10</max-pool-size> <is-same-rm-override>false</is-same-rm-override> <interleaving>false</interleaving> <pad-xid>false</pad-xid> <wrap-xa-resource>false</wrap-xa-resource> </xa-pool> <security> <user-name>user</user-name> <password>user</password> </security> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> <background-validation-millis>0</background-validation-millis> </validation> <statement> <prepared-statement-cache-size>0</prepared-statement-cache-size> <share-prepared-statements>false</share-prepared-statements> </statement> </xa-datasource> <drivers> <driver name="h2" module="com.h2database.h2"> <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> </driver> <driver name="as400driver" module="com.as400database.as400driver"> <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class> </driver> <driver name="as400driverXA" module="com.as400database.as400driver"> <xa-datasource-class>com.ibm.as400.access.AS400JDBCXADriver</xa-datasource-class> </driver> </drivers>

[Jaikiran Pai]

Also being discussed here https://developer.jboss.org/thread/250006