Local Tx Datasource is DOWN

bingojava Oct 25, 2010 8:24 AM

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

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

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

<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>

<type-mapping>mySQL</type-mapping>

</metadata>

</local-tx-datasource>

</datasources>

1. Re: Local Tx Datasource is DOWN

bingojava Oct 25, 2010 8:19 AM (in response to bingojava)

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