2 Replies Latest reply on Jun 21, 2004 1:17 AM by raj_kumar

unexpected problem with one to one relationship

raj_kumar Jun 16, 2004 7:22 AM

hello ....
i'm using one to one unidirectional relationship between two entity
beans but i'm not able to ... here primary key of the one table is the
foreign key and primary key of second table .

the stack trace is (Trace is enables )

2004-06-16 16:19:48,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RSCTP] Executing SQL: SELECT COUNT(*) FROM rsctp WHERE RSCTPID=?
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#rsCTPID] Set parameter: index=1, jdbcType=INTEGER, value=401100000
2004-06-16 16:19:48,435 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RSCTP] Executing SQL: INSERT INTO rsctp (RSCTPID, SlotPort, SwitchName, RS, OperationalStatus, SinkOperationalStatus, SourceOperationalStatus, STMLevel, RSCTPMode, XConnectObjectPointer, ConnectionStatus, OpticalPortID, rsttp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#rsCTPID] Set parameter: index=1, jdbcType=INTEGER, value=401100000
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#slotPort] Set parameter: index=2, jdbcType=INTEGER, value=401
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#switchName] Set parameter: index=3, jdbcType=VARCHAR, value=Lecsar
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#rs] Set parameter: index=4, jdbcType=INTEGER, value=1
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#operationalStatus] Set parameter: index=5, jdbcType=INTEGER, value=0
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#sinkOperationalStatus] Set parameter: index=6, jdbcType=INTEGER, value=0
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#sourceOperationalStatus] Set parameter: index=7, jdbcType=INTEGER, value=0
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#stmLevel] Set parameter: index=8, jdbcType=INTEGER, value=2
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#rsCTPMode] Set parameter: index=9, jdbcType=INTEGER, value=2
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#xConnectObjectPointer] Set parameter: index=10, jdbcType=INTEGER, value=1
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#connectionStatus] Set parameter: index=11, jdbcType=INTEGER, value=1
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#opticalPortID] Set parameter: index=12, jdbcType=INTEGER, value=401000000
2004-06-16 16:19:48,435 TRACE [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.RSCTP#rsCTPID] Set parameter: index=13, jdbcType=INTEGER, value=NULL
2004-06-16 16:19:48,450 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RSCTP] Could not create entity
java.sql.SQLException: Column not found, message from server: "Unknown column 'rsttp' in 'field list'"
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956)
 at com.mysql.jdbc.Connection.execSQL(Unknown Source)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
 at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(Unknown Source)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.executeInsert(JDBCAbstractCreateCommand.java:326)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:287)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:138)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
 at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
 at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
 at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:581)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
 at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
 at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
 at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
 at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
 at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
 at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
 at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
 at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
 at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
 at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
 at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
 at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
 at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
 at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
 at org.jboss.ejb.Container.invoke(Container.java:720)
 at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
 at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
 at $Proxy292.create(Unknown Source)
 at com.le.nms.persistence.configupdate.OpticalPortBean.setRSCTP(Unknown Source)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke(EntityContainer.java:1096)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.invoke(JDBCRelationInterceptor.java:72)
 at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:282)
 at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
 at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:114)
 at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:163)
 at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89)
 at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:54)
 at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
 at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
 at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
 at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
 at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
 at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
 at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:489)
 at org.jboss.ejb.Container.invoke(Container.java:700)
 at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:375)
 at org.jboss.ejb.plugins.local.EntityProxy.invoke(EntityProxy.java:38)
 at $Proxy322.setRSCTP(Unknown Source)
 at com.le.nms.domain.configupdate.ConfigMesgBean.storeIntoRSCTPTable(Unknown Source)
 at com.le.nms.domain.configupdate.ConfigMesgBean.storeIntoDB(Unknown Source)
 at com.le.nms.domain.configupdate.ConfigMesgBean.handleGetResponse(Unknown Source)
 at com.le.nms.domain.configupdate.ConfigMesgBean.handleResponse(Unknown Source)
 at com.le.nms.domain.configupdate.ConfigMesgBean.onMessage(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor88.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:460)
 at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
 at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:62)
 at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
 at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:240)
 at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
 at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:90)
 at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
 at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
 at org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:374)
 at org.jboss.ejb.Container.invoke(Container.java:700)
 at org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:824)
 at org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1114)
 at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:256)
 at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:633)
 at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:433)
 at org.jboss.mq.SpySession.run(SpySession.java:298)
 at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
 at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:732)
 at java.lang.Thread.run(Thread.java:534)

there is a CMR feild name "rsttp" .... i'm not able to understand that why
it takes as an CMP feild as u see in the trace...."INSERT INTO rsctp".

and the second thing is while setting the parameters of rsctp table
there are 12 feilds, but it sets in the 1st and 13th parameters ..... and rsCTPID is an
primary key but in trace i can see that it sets the value of rsCTPID
two times (at the 13th parameter) and at the second time it sets as null.

these are my deployment descriptors:-


EJB-JAR:----------

 CMP FIELDS:------------

<abstract-schema-name>rsctp</abstract-schema-name>
 <cmp-field>
 <field-name>rsCTPID</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>slotPort</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>switchName</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>rs</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>operationalStatus</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>sinkOperationalStatus</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>sourceOperationalStatus</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>stmLevel</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>rsCTPMode</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>xConnectObjectPointer</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>connectionStatus</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>opticalPortID</field-name>
 </cmp-field>
 <primkey-field>rsCTPID</primkey-field>
 </entity>
 <entity>
 <ejb-name>ElectricalPort</ejb-name>
 <local-home>com.le.nms.persistence.configupdate.ElectricalPortLocalHome</local-home>
 <local>com.le.nms.persistence.configupdate.ElectricalPortLocal</local>
 <ejb-class>com.le.nms.persistence.configupdate.ElectricalPortBean</ejb-class>
 <persistence-type>Container</persistence-type>
 <prim-key-class>java.lang.Integer</prim-key-class>
 <reentrant>False</reentrant>
 <cmp-version>2.x</cmp-version>
 <abstract-schema-name>electricalPort</abstract-schema-name>
 <cmp-field>
 <field-name>electricalPortID</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>slotPort</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>switchName</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>stmLevel</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>electricalMode</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>miPortMode</field-name>
 </cmp-field>
 <cmp-field>
 <field-name>connectionStatus</field-name>
 </cmp-field>
 <primkey-field>electricalPortID</primkey-field>

RELATIONSHIPS (EJB_JAR)--------------

<ejb-relation>
 <ejb-relation-name>RSCTP and RSTTP</ejb-relation-name>
 <ejb-relationship-role>
 <ejb-relationship-role-name>Each RSCTP has one RSTTP</ejb-relationship-role-name>
 <multiplicity>One</multiplicity>
 <relationship-role-source>
 <ejb-name>RSCTP</ejb-name>
 </relationship-role-source>
 <cmr-field>
 <cmr-field-name>rsttp</cmr-field-name>
 </cmr-field>
 </ejb-relationship-role>
 <ejb-relationship-role>
 <ejb-relationship-role-name>RSTTP to RSCTP</ejb-relationship-role-name>
 <multiplicity>One</multiplicity>
 <cascade-delete/>
 <relationship-role-source>
 <ejb-name>RSTTP</ejb-name>
 </relationship-role-source>
 </ejb-relationship-role>
 </ejb-relation>


JBOSS-CMP JDBC .---------

ENTITY TAG:------------

<entity>
 <ejb-name>RSCTP</ejb-name>
 <table-name>rsctp</table-name>
 <cmp-field>
 <field-name>rsCTPID</field-name>
 <column-name>RSCTPID</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>slotPort</field-name>
 <column-name>SlotPort</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>switchName</field-name>
 <column-name>SwitchName</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>rs</field-name>
 <column-name>RS</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>operationalStatus</field-name>
 <column-name>OperationalStatus</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>sinkOperationalStatus</field-name>
 <column-name>SinkOperationalStatus</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>sourceOperationalStatus</field-name>
 <column-name>SourceOperationalStatus</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>stmLevel</field-name>
 <column-name>STMLevel</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>rsCTPMode</field-name>
 <column-name>RSCTPMode</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>xConnectObjectPointer</field-name>
 <column-name>XConnectObjectPointer</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>connectionStatus</field-name>
 <column-name>ConnectionStatus</column-name>
 </cmp-field>
 <cmp-field>
 <field-name>opticalPortID</field-name>
 <column-name>OpticalPortID</column-name>
 </cmp-field>
</entity>


RELATIONSHIP tag--------
<ejb-relation>
 <ejb-relation-name>RSCTP and RSTTP</ejb-relation-name>
 <foreign-key-mapping/>
 <ejb-relationship-role>
 <ejb-relationship-role-name>Each RSCTP has one RSTTP
</ejb-relationship-role-name>
 <key-fields>
 <key-field>
 <field-name>rsCTPID</field-name>
 <column-name>RSCTPID</column-name>
 </key-field>
 </key-fields>
 </ejb-relationship-role>
 <ejb-relationship-role>
 <ejb-relationship-role-name>RSTTP to RSCTP</ejb-relationship-role-name>
 </ejb-relationship-role>
 </ejb-relation>

i dont understand why this problem is comming ....

can u tell me where i'm going wrong ?.... how can we set the one to one relationship .....why such an error is comming .

-- if i set it into one to many relationship then everything works fine
but in one to one it is not working .............

Thanks
Raj...........

1. Re: unexpected problem with one to one relationship

aloubyansky Jun 17, 2004 5:01 AM (in response to raj_kumar)

The DDs seem to be correct. What JBoss version?
Actions

2. Re: unexpected problem with one to one relationship

raj_kumar Jun 21, 2004 1:17 AM (in response to raj_kumar)

hi alex .....

i really apologize for replying u late ....but i got the solution
but i really dont know the actual cause behing it ...while doing hit and trials i just thought the key exist in the both the table (EJB)...and i did little change in the deployment descriptor ...in the jbosscmp-jdbc.xml i changes the follwing in relationship:----

EARLIER IT WAS--------------

<ejb-relation>
 <ejb-relation-name>RSCTP and RSTTP</ejb-relation-name>
 <foreign-key-mapping/>
 <ejb-relationship-role>
 <ejb-relationship-role-name>Each RSCTP has one RSTTP
</ejb-relationship-role-name>
 <key-fields>
 <key-field>
 <field-name>rsCTPID</field-name>
 <column-name>RSCTPID</column-name>
 </key-field>
 </key-fields>
 </ejb-relationship-role>
 <ejb-relationship-role>
 <ejb-relationship-role-name>RSTTP to RSCTP</ejb-relationship-role-name>
 </ejb-relationship-role>
 </ejb-relation>

now i change it to :-

<ejb-relation>
 <ejb-relation-name>RSCTP and RSTTP</ejb-relation-name>
 <foreign-key-mapping/>
 <ejb-relationship-role>
 <ejb-relationship-role-name>Each RSCTP has one RSTTP
</ejb-relationship-role-name>
 </ejb-relationship-role>
 <ejb-relationship-role>
 <ejb-relationship-role-name>RSTTP to RSCTP</ejb-relationship-role-name>
<key-fields>
 <key-field>
 <field-name>rsCTPID</field-name>
 <column-name>RSCTPID</column-name>
 </key-field>
 </key-fields>

 </ejb-relationship-role>
 </ejb-relation>

but here RSCTP is an parent EJB and RSTTP is an child ....i thought that the key exist in both the table soo i did this change ....can u pls tell me what is real cause behing this ?.
i'm using jboss version 3.2.3

thanks
Raj........

Go to original post