Oops, the change is only in 2.5. You can change 2.2 or 2.4 yourself, I
originally qrote it for 2.2
david jencks
On 2001.07.28 18:48:12 -0400 David Jencks wrote:
> 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
>
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
