Hi Alex,
Here you go:
<entity>
<ejb-name>MDSVector</ejb-name>
<datasource>java:/MDS</datasource>
<datasource-mapping>Sybase</datasource-mapping>
<create-table>false</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<table-name>MDS_VECTOR</table-name>
<cmp-field>
<field-name>additionalInfo</field-name>
<column-name>MV_ADDITIONAL_INFO</column-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(255)</sql-type>
</cmp-field>
<cmp-field>
<field-name>iD</field-name>
<column-name>MV_ID</column-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(255)</sql-type>
</cmp-field>
<cmp-field>
<field-name>mVKey</field-name>
<column-name>MV_KEY</column-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC(8)</sql-type>
<auto-increment/>
</cmp-field>
<cmp-field>
<field-name>mDSID</field-name>
<column-name>MV_MDS_ID</column-name>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMERIC(8)</sql-type>
</cmp-field>
<cmp-field>
<field-name>seqNo</field-name>
<column-name>MV_SEQ_NO</column-name>
<jdbc-type>SMALLINT</jdbc-type>
<sql-type>SMALLINT(5)</sql-type>
</cmp-field>
<cmp-field>
<field-name>spread</field-name>
<column-name>MV_SPREAD</column-name>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE PRECISION(15)</sql-type>
</cmp-field>
<cmp-field>
<field-name>value</field-name>
<column-name>MV_VALUE</column-name>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE PRECISION(15)</sql-type>
</cmp-field>
<cmp-field>
<field-name>valueType</field-name>
<column-name>MV_VALUE_TYPE</column-name>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR(12)</sql-type>
</cmp-field>
<entity-command name="sybase-adding"
class="org.jboss.ejb.plugins.cmp.jdbc.sybase.JDBCSybaseCreateCommand">
</entity-command>
</entity>
<relationships>
<ejb-relation>
<ejb-relation-name>mDSKeyMatrix-mDSMatrixs</ejb-relation-name>
<ejb-relationship-role>
<ejb-relationship-role-name>mDSKeyMatrix-has-mDSMatrixs</ejb-relationship-ro
le-name>
<key-fields>
<key-field>
<field-name>mDSId</field-name>
<column-name>MM_MDS_ID</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>mDSMatrix-has-mDSKeyMatrix</ejb-relationship-rol
e-name>
<key-fields/>
</ejb-relationship-role>
</ejb-relation>
<ejb-relation>
<ejb-relation-name>mDSKeyVector-mDSVectors</ejb-relation-name>
<ejb-relationship-role>
<ejb-relationship-role-name>mDSVector-has-mDSKeyVector</ejb-relationship-rol
e-name>
<fk-constraint>true</fk-constraint>
<key-fields/>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>mDSKeyVector-has-mDSVectors</ejb-relationship-ro
le-name>
<key-fields>
<key-field>
<field-name>mDSId</field-name>
<column-name>MV_MDS_ID</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
</ejb-relation>
</relationships>
Note I am running on Standard CMP 2.x EntityBean container
Thanks!
Simone
----- Original Message -----
From: "Alex Loubyansky" <[EMAIL PROTECTED]>
To: "Simone Milani" <[EMAIL PROTECTED]>
Sent: Monday, March 24, 2003 6:22 PM
Subject: Re[6]: [JBoss-user] CMR with FK in the database
> Could you, please, post jbosscmp-jdbc.xml excerpt for MDS_VECTOR
> entity and relationship mapping?
>
> thanks,
> 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
>
-------------------------------------------------------
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
