Bugs item #851757, was opened at 2003-12-01 00:35
Message generated for change (Settings changed) made by loubyansky
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=851757&group_id=22866
Category: JBossCMP
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: unlord (unlord)
>Assigned to: Alexey Loubyansky (loubyansky)
Summary: no sequence created on table creation
Initial Comment:
When auto-increment is enabled on any column using CMP,
a sequence should be created when creating the table.
For example, if entity-command postgresql-fetch-seq is
used, then a postgresql sequence with the appropriate
name should be created when the database table that
contains the column that uses the sequence is created.
This bug is reproducable under JBoss 3.2.2 using
PostgreSQL 7.3.4.
----------------------------------------------------------------------
Comment By: Jeffrey Bride (jbride)
Date: 2003-12-03 06:43
Message:
Logged In: YES
user_id=92698
I'm experiencing the same issue with JBoss 3.2.2 and Oracle
9i . However, I can create the sequence manually in the
database and specify the sequence name in jbosscmp-jdbc.xml
. JBoss does subsequently utilize the sequence correctly.
----------------------------------------------------------------------
Comment By: unlord (unlord)
Date: 2003-12-01 01:14
Message:
Logged In: YES
user_id=35461
In addition, in the case of PostgreSQL, the primary key
should have a DEFAULT nextval('"<sequence>"') set on it.
This is so that code that executes will work immediately.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=851757&group_id=22866
-------------------------------------------------------
This SF.net email is sponsored by OSDN's Audience Survey.
Help shape OSDN's sites and tell us what you think. Take this
five minute survey and you could win a $250 Gift Certificate.
http://www.wrgsurveys.com/2003/osdntech03.php?site=8
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development