Bugs item #851757, was opened at 2003-11-30 14:35
Message generated for change (Comment added) made by jbride
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 07:44
Message:
Logged In: YES
user_id=92698
Thanks for the reply Alexey! We're not using XDoclet quite
yet I'll definately take into consideration your
recommendation when we begin using XDoclet.
thanks, jeff
----------------------------------------------------------------------
Comment By: Alexey Loubyansky (loubyansky)
Date: 2003-12-02 23:46
Message:
Logged In: YES
user_id=543482
Can you use post-table-create for sequence creation? Like this:
@jboss.persistence post-table-create="CREATE SEQUENCE
%%t_seq START WITH 1 INCREMENT BY 1"
----------------------------------------------------------------------
Comment By: Jeffrey Bride (jbride)
Date: 2003-12-02 20: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-11-30 15: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