Hi, I'm using a fk-constraint to link two ejbEntity. the JBossCMP will automatically add a foreign key to the tables. the problem is that field is already exist in the table and I want the JBossCMP use this field, not to create a new one. is that possible?
11:39:48,112 DEBUG [Service] Create: pk=43 - 42 11:39:48,112 DEBUG [Service] Executing SQL: SELECT COUNT(*) FROM SERVICEBEANTABLE WHERE MEV_PRIMARY_KEY=? AND ORDER_MEV_PRIMARY_KEY=? 11:39:48,172 DEBUG [Service] Executing SQL: INSERT INTO SERVICEBEANTABLE (MEV_PRIMARY_KEY, ORDER_MEV_PRIMARY_KEY, ADDITIONAL_ATTRIBUTES, FAILED, FAILED_EXCEPTION, LAST_MODIFIED, MEV_TYPE, POSITION_IN_ORDER_VALUE_ARRAY, SERVICE_ACTIVATOR_HOME_JNDI_NAME, STATE, SUBSCRIBER_ID, ORDER_MEV_PRIMARY_KEY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 11:39:48,222 ERROR [Service] Could not create entity SQL Exception: Column name 'ORDER_MEV_PRIMARY_KEY' appears more than once times in the column list of an insert statement. at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteC all.java:245) at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:220) at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:122) at RmiJdbc.RJConnectionServer_Stub.prepareStatement(Unknown Source) at RmiJdbc.RJConnection.prepareStatement(RJConnection.java:109) at org.jboss.resource.adapter.jdbc.local.LocalConnection.prepareStatement(Local Connection.java:191) at org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.insertEntity(JDBCCrea teEntityCommand.java:186) Thanks for your helps. Best regards LY Daniel ------------------------------------------------------- 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