Patches item #556711, was opened at 2002-05-16 10:55
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376687&aid=556711&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Olger Warnier (terranvs)
Assigned to: Nobody/Anonymous (nobody)
Summary: Support SQL generated primary keys
Initial Comment:
This patch extends the functionality of the cmp (2.0)
engine for jboss 3.0
There is a tag added to the jbosscmp-jdbc.xml called
pk-sql that gives the possibility to enter a specific
SQL query to fill the primary key.
We made this patch in order to support the use of
Oracle sequences in such a way that it is not required
to add code to your ejbCreate calls; that makes your
ejbs product (e.g. oracle) specific
We used the borland appserver before we moved to jboss
and they had a solution for this issue that is similar
to this patch.
example cmp-field tag in the jbosscmp-jdbc.xml
<cmp-field>
<field-name>communicationID</field-name>
<column-name>COMMUNICATIONID</column-name>
<pk-sql>SELECT SEQ_2279_1.nextval FROM
DUAL</pk-sql>
<jdbc-type>DECIMAL</jdbc-type>
<sql-type>NUMBER(10)</sql-type>
We thought about using a property tag in order to keep
the DTD as is. But the option of an additional tag
gives the possibility of DTD checking and we thought
that that was preffered.
Please see the patch file for the changes.
go to the jboss-all directory of the source tree and:
patch -p4 < pk-sql.patch
Please send your comments to:
[EMAIL PROTECTED]
[EMAIL PROTECTED]
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376687&aid=556711&group_id=22866
_______________________________________________________________
Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: [EMAIL PROTECTED]
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
