Hi Alex,
Thanks, but that does not work for me :( I am using RC4 and get this
error if I do expose the FK field as CMP field:
2003-03-24 16:31:14,416 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.sybase.JDBCSybaseC
reateCommand.MDSVector] Executing SQL: INSERT INTO MDS_VECTOR
(MV_ADDITIONAL_INF
O, MV_ID, !!!!!!!MV_MDS_ID , MV_SEQ_NO, MV_SPREAD, MV_VALUE,
MV_VALUE_TYPE, !!!!!!!!!MV_MDS_ID) V
ALUES (?, ?, ?, ?, ?, ?, ?, ?)
2003-03-24 16:31:14,416 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi
eldBridge.MDSVector.additionalInfo] Set parameter: index=1,
jdbcType=VARCHAR, va
lue=NULL
2003-03-24 16:31:14,416 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi
eldBridge.MDSVector.iD] Set parameter: index=2, jdbcType=VARCHAR, value=NULL
2003-03-24 16:31:14,416 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi
eldBridge.MDSVector.mDSID] Set parameter: index=3, jdbcType=NUMERIC,
value=NULL
2003-03-24 16:31:14,416 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi
eldBridge.MDSVector.seqNo] Set parameter: index=4, jdbcType=SMALLINT,
value=NULL
2003-03-24 16:31:14,416 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi
eldBridge.MDSVector.spread] Set parameter: index=5, jdbcType=DOUBLE,
value=0.0
2003-03-24 16:31:14,416 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi
eldBridge.MDSVector.value] Set parameter: index=6, jdbcType=DOUBLE,
value=2.0
2003-03-24 16:31:14,416 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi
eldBridge.MDSVector.valueType] Set parameter: index=7, jdbcType=CHAR,
value=C
2003-03-24 16:31:14,416 TRACE
[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi
eldBridge.MDSVector.mDSId] Set parameter: index=8, jdbcType=NUMERIC,
value=NULL
2003-03-24 16:31:14,416 ERROR
[org.jboss.ejb.plugins.cmp.jdbc.sybase.JDBCSybaseC
reateCommand.MDSVector] Could not create entity
com.sybase.jdbc2.jdbc.SybSQLException: Column name MV_MDS_ID appears more
than o
nce in the result column list.
Because the CMP fileds and CMR fields do overlap - See JDBCEntityBridge line
151
Thanks!!!
Simone
----- Original Message -----
From: "Alex Loubyansky" <[EMAIL PROTECTED]>
To: "Simone Milani" <[EMAIL PROTECTED]>
Sent: Monday, March 24, 2003 3:52 PM
Subject: Re[4]: [JBoss-user] CMR with FK in the database
> Hello Simone,
>
> actually, it looks like exposing FK field[s] as non-null CMP field[s].
> Just map FK fields to CMP fields in jbosscmp-jdbc.xml.
>
> NOTE: there is currently a bug (stack overflow on loading) in FK fields
map to CMP columns.
> I can't commit changes to CVS the whole day. I hope Dain will help
> help me and today it'll be fixed in CVS.
>
> alex
>
> Monday, March 24, 2003, 3:45:54 PM, Simone Milani wrote:
>
> SM> Hi Alex,
>
> SM> Thanks! Do I have to expose the FK field in my ChildBean? Could
you
> SM> provide an example?
>
> SM> Thanks!!!!
>
> SM> Simone
> SM> ----- Original Message -----
> SM> From: "Alex Loubyansky" <[EMAIL PROTECTED]>
> SM> To: "Jonathan.O'[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> SM> Sent: Monday, March 24, 2003 12:06 PM
> SM> Subject: Re[2]: [JBoss-user] CMR with FK in the database
>
>
> >> JBoss-3.2 now supports NON-NULL foreig keys if foreign key fields are
> >> mapped to NON NULL CMP fields.
> >>
> >> alex
> >>
> >> Monday, March 24, 2003, 1:50:17 PM, Jonathan O'Connor wrote:
> >>
> >> JOCxd> Simone,
> >> JOCxd> Look for previous messages about INSERT after ejbPostCreate.
> >> JOCxd> If you use oracle you can also mark the NON NULL constraint as
> SM> DEFERRABLE
> >> JOCxd> INITIALLY DEFERRED. However, lots of DBAs don't like this.
> >> JOCxd> Ciao,
> >> JOCxd> Jonathan O'Connor
> >>
> >>
> >>
> >>
> >>
> >> JOCxd> "Simone Milani" <[EMAIL PROTECTED]>
> >> JOCxd> Sent by: [EMAIL PROTECTED]
> >> JOCxd> 24.03.2003 10:43
> >> JOCxd> Please respond to jboss-user
> >>
> >>
> >> JOCxd> To: <[EMAIL PROTECTED]>
> >> JOCxd> cc:
> >> JOCxd> Subject: [JBoss-user] CMR with FK in the database
> >>
> >>
> >> JOCxd> Hi,
> >>
> >> JOCxd> I have a one to many relation with a FK constaint and the FK
in
> SM> the
> >> JOCxd> children declared as non nullable. The SQL that is generated by
> SM> JBoss
> >> JOCxd> seems to violate this constraint.
> >>
> >> JOCxd> Please help!!!
> >>
> >>
> >> JOCxd> Thanks
> >>
> >> JOCxd> Simone
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user