Bugs item #851757, was opened at 2003-12-01 00:35
Message generated for change (Comment added) 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: Closed
>Resolution: Wont Fix
Priority: 5
Submitted By: negge (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: Alexey Loubyansky (loubyansky)
Date: 2004-08-08 17:29
Message:
Logged In: YES
user_id=543482
post-table-create covers this issue. There is no need to
introduce more config options.
----------------------------------------------------------------------
Comment By: Jeffrey Bride (jbride)
Date: 2003-12-03 17: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-03 09: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-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: negge (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 OSTG. Have you noticed the changes on
Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
one more big change to announce. We are now OSTG- Open Source Technology
Group. Come see the changes on the new OSTG site. www.ostg.com
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development