1 Reply Latest reply on Feb 25, 2002 2:32 PM by Marc Ollier

    "No ressource manager found" when using MySQL

    Marc Ollier Newbie

      Hello

      I'm trying to access data from a mySQL-Database, but i have some configuration problems.
      At startup/deployment, i notice :
      * there is not the line that says that the mySQL driver has been loaded between [INFO,JdbcProvider] Starting/Started
      * when deploying my entity bean, i have [INFO,JdbcProvider] Starting
      * when making a request on the DB, the data is not found:
      [ERROR,Default] javax.ejb.ObjectNotFoundException: Object with primary key xxx not found in storage
      [ERROR,Default] at org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityCommand
      .findByPrimaryKey(JDBCFindEntityCommand.java:89)
      * when i create new beans, then look for them, they are found, but don't get in the database. (here i assume it's caching).


      I use 2.4.4, and here are my config datas. I have tryed a lot of combinations, and looked in the doc, but it still doesn't work.
      I have also put the jar containing the last mySQL driver version in ib/ext, but it has no effect (the same happends, if the jar is there or not)

      ---------ejb-jar.xml :

      <enterprise-bean>

      <resource-ref>
      <res-ref-name>jdbc/defaultDS</res-ref-name>
      <res-type>javax.sql.XADataSource</res-type>
      <res-auth>Container</res-auth>
      </resource-ref>
      ...

      ---------jboss.jcml :


      org.hsqldb.jdbcDriver, org.gjt.mm.mysql.Driver



      // default values



      defaultDS
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      defaultDS
      jdbc:mysql://localhost:3306/names
      ...


      ---------jboss.xml :
      <resource-managers>
      <resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
      <res-name>jdbc/defaultDS</res-name>
      <res-jndi-name>java:/defaultDS</res-jndi-name>
      </resource-manager>
      </resource-managers>
      <enterprise-beans>

      ...
      <ressource-ref>
      <res-ref-name>jdbc/defaultDS</res-ref-name>
      <jndi-name>java:/defaultDS</jndi-name>
      </ressource-ref>

      </enterprise-beans>

      ---------standardjaws.xml :
      java:/DefaultDS
      <type-mapping>mySQL</type-mapping>




      can anyone help ?
      thanks a lot
      marc