Serious problem: Table dropped when shutting down JBOSS3

[winghoe]

I'm using JBoss3 and MS SQL Server 7. Every time I shut down the server by using Ctrl+C, JBoss 3 drops my table from the database!

I have a CMP EntityBean, on 1.1 spec running.

Is this suppose to happen? Help, this is dangerous to have tables dropped upon shut down. Is there something that I can configure to prevent it to be dropped?

Wing Hoe

[dsnyckers]

In your jbosscmp-jdbc.xml, you can configure if jboss has to remove your table or not.

<jbosscmp-jdbc>


java:/MSSQLDS
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
<create-table>true</create-table>
<remove-table>false</remove-table>


<enterprise-beans>
...
</jbosscmp-jdbc>

if you set the remove-table property to false, it should not delete your tables anymore on exit.

regards,
Dave

[winghoe]

Hi Dave,
Yes I have set the <remove-table> tag to false. I've checked both standardjaws.xml and jbosscmp-jdbc.xml and also my CMP Entity Bean's jaws.xml. All of them has "false" value.

This problem occurred even in JBoss2.4.4 and it's happening in JBoss3. I have both versions and both drop the table. *argh*

I used both Ctrl+C and the shutdown.bat to perform the shut down. Same result.

Is JBoss reading the <remove-table> tag properly?

Wing Hoe

[dsnyckers]

Have you tried to specify the <remove-table>false</remove-table> on the level instead of the <default-entity> level (like in the standard-jaws.xml)?

for example :


MSSQLDS
<type-mapping>MS SQLSERVER2000</type-mapping>

<enterprise-beans>

<ejb-name>ClassBean</ejb-name>
<table-name>CLASS</table-name>
<remove-table>false</remove-table>
...


Dave

[winghoe]

I'll add it in and give it a try. Somehow, I think the <default-entity> tag isn't being read properly huh?

Let you know the result tomorrow.

Wing Hoe

[winghoe]

Dave,
I think your solution to put the <remove-table>false<remove-table> at the tag level corrects the problem.

I tried restarting the server with the changed jaws.xml in my EntityBean's package and shutting it down again. Didn't drop the table.

I'll do another few more tests later.

Thanks.

Wing Hoe

[winghoe]

Dave,
Thanks for the information on setting the <remove-table> in the level.

It works. The table is retained when I shutdown the server.

Wing Hoe