I think i've seen this when i have a CMR foreign key that is also listed as a CMP field. Or maybe when i have copy/paste errors in my xdoclet tags. I haven't done this in quite a while, so I don't remember for sure what the exact problem was. Hopefully this helps you a bit.
gary. On Tue, 2003-05-06 at 11:43, Nicholas wrote: > We are having this really odd problem with CMP2 that > developed recently. The entity bean used to work ok, > but this problem is sending us for a loop. > > JBoss 3.0.4 > Oracle 9.2 > > 2003-05-06 11:28:58,968 DEBUG > [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Client] > Executing SQL: INSERT INTO CLIENT (CLIENT_ID, > MASTER_COMBO_ID, CLIENT_CODE, ORGANIZATION_ID, FEIN, > TIPPED_ > CLIENT, COMPANY_NAME, ADDRESS1, ADDRESS2, CITY, STATE, > ZIP, ZIP4, TEL, FAX, PAYROLLCONTACT_NAME, > PAYROLLCONTACT_TEL, PAYROLL_SETUP_DATE, > PAYROLL_START_DATE, FEATURE_TERMINATION_DATE, > ACC_NAME, ACSR_NA > ME, CQ_OR_PQ, FICA_LIABILITY_SPLIT_CQ, > FICA_LIABILITY_SPLIT_PQ, COMBO_CLIENT, > CLIENT_START_DATE, FLT_EMAIL, USER_ID, > SERVICE_CENTER_ID, SETUP_COMPLETE, > SETUP_COMPLETE_DATE, FLT_START_DATE, SERVICE_CEN > TER_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?) > 2003-05-06 11:28:58,984 ERROR > [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Client] > Could not create entity > java.sql.SQLException: ORA-00957: duplicate column > name > > The column SERVICE_CENTER_ID inexplicably appears > twice. I have checked the descriptors and there is no > duplication there. (They are attached,) > > Any insight into this would really be appreciated. > > Thanks. > > //Nicholas > > ===== > Nicholas Whitehead > Home: (973) 377 9335 > Cell: (201) 615 2716 > [EMAIL PROTECTED] > Get Your News From The Crowbar: http://crowbar.dnsalias.com:443/crowbar/ ------------------------------------------------------- Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara The only event dedicated to issues related to Linux enterprise solutions www.enterpriselinuxforum.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
