xxx>>>>> "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 had to send this twice, because apparently the list manager rejects notes
which have the same sender and the same first line. I think I can understand
why it does this (spam defense, perhaps?), but it makes it an annoyance when
someone tries to respond to the same note with different information.
Hopefully adding "xxx" to the first line will avoid this check. I would assume
spam generators could easily do the same thing automatically.)
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
