On 27 Jul 2001 22:09:29 -0700, David M. Karr wrote:
> >>>>> "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.
>
> Ok, I have some more information. I checked the "server.log" file, and I saw
> the following:
>
> [JAWS] java.sql.SQLException: General error: All parts of a PRIMARY KEY must be NOT
>NULL; If you need NULL in a key, use UNIQUE instead
> [JAWS] at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> [JAWS] ...
> [JAWS] Could not create table CDBean: General error: All parts of a PRIMARY KEY must
>be NOT NULL; If you need NULL in a key, use UNIQUE instead
Hmmm, it's MySQL giving you that error. Something is not right with
your Driver
or with JAWS (probably your setup). Any idea what causes it to believe
that the
primary key is null all of a sudden? Are the typmappings etc... in
jaws.xml correct?
> However, I'm not sure when this occurred. I'm having trouble understanding how
> the log file works. It seems to be created with a large number of nulls at the
> beginning of the file, even when I delete it and restart JBoss. I haven't
> noticed any option to timestamp log file entries.
This is more of a log4j thingy. I don't know enough about that.
--
Nicolai P Guba http://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751 DDI: +44 (0)20 7368 9708
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
