Hmm, I'm interested to see that firebird/interbase is not the only rdbms
with archaic syntax.

In 2.4 (since june 16) you can specify not null constraints on your columns
like this (per column)

<nullable>false</nullable>

Jaws will then create your tables with the not null columns so you can use
primary keys.

Code in CMPFieldMetaData and JDBCInitCommand.

david jencks

On 2001.07.28 14:40:57 -0400 David M. Karr wrote:
> 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
> 
> 

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to