File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes Table getting Dropped Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Table getting Dropped" Watch "Table getting Dropped" New topic

Table getting Dropped

John Pj

Joined: Sep 28, 2004
Posts: 3
Im using Jboss 4.0 and MySql for my project.When ever i shut down the application server,a particular table gets Dropped and when restarting the server it gets Created.Does anybody know Y this is happening?

Regards,<br />John David
David Harkness
Ranch Hand

Joined: Aug 07, 2003
Posts: 1646
Some J2EE containers, JBoss included, have options to do just this to your CMP tables on a table-by-table basis. While it seems odd that only one of your tables wuold be set up this way, it does seem likely to be the cause. Scan your JBoss-specific deployment descriptors for a setting like "create-table" or something similar.

I've never used JBoss, so I don't know the name, but XDoclet has settings for just this behavior (create, alter and remove tables).
I agree. Here's the link:
subject: Table getting Dropped
It's not a secret anymore!