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
i mixed up a cut&paste at the beginning :
when deploying a bean, i see :
[WARN,EntityContainer] No resource manager found for jdbc/defaultDS