Please Help: mySQL and JBoss 3.2.1 problem

[viz]

Hi,

I seem to have hit a brick wall with this. This is what I have:

forest-ds.xml: in the /deploy directory

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


<local-tx-datasource>
<jndi-name>ForestDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/forest</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>admin</user-name>
password
</local-tx-datasource>


jbosscmp-jdbc.xml in the META-INF directory:

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

<!DOCTYPE jbosscmp-jdbc PUBLIC
"-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN"
"http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd">

<jbosscmp-jdbc>


java:/ForestDS
<datasource-mapping>mySQL</datasource-mapping>
<create-table>true</create-table>
<remove-table>false</remove-table>


<

[juhalindfors]

Your entity does not correctly declare its primary key in the ejb-jar.xml (is entity bean configuration problem most likely)

[viz]

Thanks for the help.

I have got it sorted - it was a number of problems (including the one you mentioned).

Many thanks,
--
Marc