[jboss-user] [Datasource Configuration] - Local Tx Datasource is DOWN

[Mayur B]

Mayur B [http://community.jboss.org/people/bingojava] created the discussion

"Local Tx Datasource is DOWN"

To view the discussion, visit: http://community.jboss.org/message/568177#568177

--------------------------------------------------------------
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 ||
 |  %1,4%  http://202.46.194.45:1460/admin-console/images/spacer.gif  (http://202.46.194.45:1460/admin-console/images/spacer.gif) |
 | DefaultDS (http://202.46.194.45:1460/admin-console/secure/summary.seam?path=-9&conversationId=51) | Local Tx Datasource (http://202.46.194.45:1460/admin-console/secure/summary.seam?path=-3%2FResources%2FDatasources%2FLocal+Tx+Datasource&conversationId=51) | UP |  |
| jdbc/mysql (http://202.46.194.45:1460/admin-console/secure/summary.seam?path=-8&conversationId=51) | Local Tx Datasource (http://202.46.194.45:1460/admin-console/secure/summary.seam?path=-3%2FResources%2FDatasources%2FLocal+Tx+Datasource&conversationId=51) | 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://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>
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/568177#568177]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101025/37284405/attachment-0001.html