Local Tx Datasource is DOWN

[bingojava]

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 --->

Name	Type	Status	Actions
DefaultDS	Local Tx Datasource	UP
jdbc/mysql	Local Tx Datasource	DOWN

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://serverIP:3306/sdatabase?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>

[bingojava]

Typo in first sentence ..it should be ".. just restarted second instance on jboss server , WITH different port settings "