1 Reply Latest reply on Oct 25, 2010 8:19 AM by Mayur B

    Local Tx Datasource is DOWN

    Mayur B Newbie

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

       

       

       

       

      NameTypeStatusActions
      DefaultDSLocal Tx DatasourceUP
      jdbc/mysqlLocal Tx DatasourceDOWN

       

       

       

      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>