[albertogiantin]

Hi.
i’m reading the Web Development with MyEclipse and JBoss tutorial and i’m trying to create and deploy the WebStock project, described in this tutorial but i have some problem.
I’m using myEclipse 4.1.1, jBoss 4.0.4 and mySQL 5.0.

The error returned from the server is:

org.jboss.deployment.DeploymentException: Error: can't find data source: java:/jdbc/webstockDS; - nested throwable: (javax.naming.NameNotFoundException: jdbc not bound)
    at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.init(JDBCEntityBridge.java:153)
    at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:435)
    at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:368)
....

and there is also this message:

--- Packages waiting for a deployer ---
org.jboss.deployment.DeploymentInfo@7bd88d5f { url=file:/C:/Programmi/jboss-4.0.4.GA/server/default/deploy/mysql-dbds.xml }
  deployer: null
  status: null
  state: INIT_WAITING_DEPLOYER
  watch: file:/C:/Programmi/jboss-4.0.4.GA/server/default/deploy/mysql-dbds.xml
  altDD: null
  lastDeployed: 1148649859702
  lastModified: 1148649859702
  mbeans:

It seems to be a problem with my mysql-dbds.xml configuration file or jbosscmp-jdbc.xml but i can’t solve it.
Anyone can help me?

[albertogiantin]

here is a code snippet of my jbosscmp-jdb.xml file in src/META-INF:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd">

<jbosscmp-jdbc>
   <defaults>
     <datasource>java:/jdbc/webstockDS</datasource>
     <datasource-mapping>mySQL</datasource-mapping>
   </defaults>

   <enterprise-beans>
......

and the full text of mysql-dbds.xml:

<?xml version="1.0" encoding="UTF-8"?>

<!-- $Id: mysql-ds.xml,v 1.3.2.3 2006/02/07 14:23:00 acoliver Exp $ -->
<!--  Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->

<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/webstockDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/webstock</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>******</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>

[Author]

Posts