This is the problem with vendor-specific create commands. Just fixed it. PS: Simone, be sure to use JDBCSybaseCreateCommand that extends JDBCAbstractVendorCreateCommand.
alex Monday, March 24, 2003, 6:35:05 PM, Simone Milani wrote: SM> Hi Alex, SM> Thanks, but that does not work for me :( I am using RC4 and get this SM> error if I do expose the FK field as CMP field: SM> 2003-03-24 16:31:14,416 DEBUG SM> [org.jboss.ejb.plugins.cmp.jdbc.sybase.JDBCSybaseC SM> reateCommand.MDSVector] Executing SQL: INSERT INTO MDS_VECTOR SM> (MV_ADDITIONAL_INF SM> O, MV_ID, !!!!!!!MV_MDS_ID , MV_SEQ_NO, MV_SPREAD, MV_VALUE, SM> MV_VALUE_TYPE, !!!!!!!!!MV_MDS_ID) V SM> ALUES (?, ?, ?, ?, ?, ?, ?, ?) SM> 2003-03-24 16:31:14,416 TRACE SM> [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi SM> eldBridge.MDSVector.additionalInfo] Set parameter: index=1, SM> jdbcType=VARCHAR, va SM> lue=NULL SM> 2003-03-24 16:31:14,416 TRACE SM> [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi SM> eldBridge.MDSVector.iD] Set parameter: index=2, jdbcType=VARCHAR, value=NULL SM> 2003-03-24 16:31:14,416 TRACE SM> [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi SM> eldBridge.MDSVector.mDSID] Set parameter: index=3, jdbcType=NUMERIC, SM> value=NULL SM> 2003-03-24 16:31:14,416 TRACE SM> [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi SM> eldBridge.MDSVector.seqNo] Set parameter: index=4, jdbcType=SMALLINT, SM> value=NULL SM> 2003-03-24 16:31:14,416 TRACE SM> [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi SM> eldBridge.MDSVector.spread] Set parameter: index=5, jdbcType=DOUBLE, SM> value=0.0 SM> 2003-03-24 16:31:14,416 TRACE SM> [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi SM> eldBridge.MDSVector.value] Set parameter: index=6, jdbcType=DOUBLE, SM> value=2.0 SM> 2003-03-24 16:31:14,416 TRACE SM> [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi SM> eldBridge.MDSVector.valueType] Set parameter: index=7, jdbcType=CHAR, SM> value=C SM> 2003-03-24 16:31:14,416 TRACE SM> [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFi SM> eldBridge.MDSVector.mDSId] Set parameter: index=8, jdbcType=NUMERIC, SM> value=NULL SM> 2003-03-24 16:31:14,416 ERROR SM> [org.jboss.ejb.plugins.cmp.jdbc.sybase.JDBCSybaseC SM> reateCommand.MDSVector] Could not create entity SM> com.sybase.jdbc2.jdbc.SybSQLException: Column name MV_MDS_ID appears more SM> than o SM> nce in the result column list. SM> Because the CMP fileds and CMR fields do overlap - See JDBCEntityBridge line SM> 151 SM> Thanks!!! SM> Simone SM> ----- Original Message ----- SM> From: "Alex Loubyansky" <[EMAIL PROTECTED]> SM> To: "Simone Milani" <[EMAIL PROTECTED]> SM> Sent: Monday, March 24, 2003 3:52 PM SM> 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 SM> 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 SM> 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 SM> 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
