[jboss-user] [Beginner's Corner] - The DataSource is UNKNOWN run state

[Frank Vestris]

Frank Vestris [http://community.jboss.org/people/frankv] replied to the discussion

"The DataSource is UNKNOWN run state"

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

--------------------------------------------------------------
Hello,

the only message related to my Datasource in server.log is the following:

2010-04-27 14:37:59,747 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MySqlDS' to JNDI name 'java:MySqlDS' 

it's an INFO message

Here is the mysql-ds.xml contents:

<?xml version="1.0" encoding="UTF-8"?>
<!-- See  http://www.jboss.org/community/wiki/Multiple1PC http://www.jboss.org/community/wiki/Multiple1PC for information about local-tx-datasource -->
<!-- $Id: mysql-ds.xml 88948 2009-05-15 14:09:08Z jesper.pedersen $ -->
<!--  Datasource config for MySQL using 3.0.9 available from:
 http://www.mysql.com/downloads/api-jdbc-stable.html http://www.mysql.com/downloads/api-jdbc-stable.html
-->
<datasources>
  <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/myDatabase</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>frankv</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!-- should only be used on drivers after 3.22.1 with "ping" support
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
    -->
    <!-- sql to call when connection is created
    <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
    <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

I can access myDatabase from the MySQLAdministrator tool or SQuirreL tool
At jboss admin console the datasource status is DOWN and Run State UNKNOWN

Maybe the mysql connector is not at the right place (server/default/lib)

Frank

--------------------------------------------------------------

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

Start a new discussion in Beginner's Corner at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100427/8a1c6dbc/attachment.html