>>>>> "David" == David M Karr <[EMAIL PROTECTED]> writes:
David> In JBoss 2.2.2, using MySQL, I had a sample application, and it had created
a
David> table. I manually dropped the table, now I'm trying to figure out how to
get
David> JBoss to figure out it needs to recreate the table. I've tried various
things,
David> like deleting the deployed jar from the "deploy" directory, and the unjarred
David> directory in the "tmp" directory. I've redeployed the jar, and JBoss seems
to
David> do it without complaining, but it still refuses to create the table.
I was able to fix this, but I need to learn more about what I had to change.
At one point, probably AFTER I had created the initial table, I had set the
"pk-constraint" field in "standardjaws.xml" to "true". When I finally turned
on SQL debugging (so I can see the statements), I noticed when it tried to
create the table, it was creating a constraint with it. That reminded me of
that field. I just tried setting it back to "false" and restarting, and it
worked fine. I guess I have some reading to do.
--
===================================================================
David M. Karr ; Best Consulting
[EMAIL PROTECTED] ; Java/Unix/XML/C++/X ; BrainBench CJ12P (#12004)
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
