Thanks for your sharing. I've tryied your example, but I found jboss couldn't create a table for a CMP bean with a compound primary key. I checked the cmp.log and found the sql command jboss generated was not correct. Here is the command.
2004-04-29 12:28:11,023 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.LineItemBean] Executing SQL: CREATE TABLE W_LINEITEM (ORDER_ID VARCHAR2(255), PRODUCT_ID VARCHAR2(255), QUANTITY NUMBER(10), CONSTRAINT PK_W_LINEITEM PRIMARY KEY ()) 2004-04-29 12:28:11,126 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.LineItemBean] Could not create table W_LINEITEM I found the value should be shown in PRIMARY KEY() was missing. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3833044#3833044 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3833044 ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
