Hi ,
I just restarted second instance on jboss server , wihtout different port settings (1299 for JNDI)
In the Datasource section of Admin console it showing my local Tx Datasource is DOWN .
There was no exception thrown in server startup log.
How to turn it on ...I tried to FLush it ..it says it is "successful" after sometime ...but status is same --->
My mysql-ds.xml atached..
plz tell me how to turn it UP ?....
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/mysql</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:mysql://202.46.194.45:3306/teshwa_bingo_jboss?zeroDateTimeBehavior=convertToNull</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>psc420</password>
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
