JBoss Persistence Issues

[jeditom]

Hi again,

I've got this problem involving CMP EJBs, MySQL and JBoss 3.0.3. I've deployed the EJBs and they work fine, I can create entries in the DB using the EJB create method, which works, but when JBoss is closed down (cleanly) not only does it remove all the data from the database but also the tables in the database that it was using! Any ideas as to why this is?

Many thanks in advance!

Tom

P.S. I know the create was working because in a seperate window I was running the mysql terminal application and doing a "SELECT * FROM table_name;".

[h2o_polo]

in jbosscmp-jdbc.xml specify the following:

<jbosscmp-jdbc>

<create-table>true</create-table>
<remove-table>false<remove-table>

:
:
</jbosscmp-jdbc>

[jeditom]

Aha! You're a genius! Thank you very much!

I owe you a beer.

Tom