weblogic 8.1 , Oracle sequence problem.

[Sagar Kale]

Hi,

I am using Oracle sequqnce to generate primary key for CMP EJB 2.0 on weblogic 8.1.

My ejbCreate method is

public Integer ejbCreate(Hobbyto to) throws CreateException {
		setHobbyName(to.getHobbyName());
		return null;
	}

hobbyId is primary key which I am not setting in ejbCreate method because it will be generated using Oracle Sequence.

I have added following in weblogic-cmp-rdbms-jar.xml

<automatic-key-generation>
    <generator-type>ORACLE</generator-type>
    <generator-name>hobby_sq</generator-name>
    <key-cache-size>1</key-cache-size>
  </automatic-key-generation>

But when I try to create ejb, I get following exception.

javax.ejb.TransactionRolledbackLocalException: EJB Exception: ; nested exception
 is: weblogic.utils.NestedRuntimeException: Error writing from beforeCompletion
- with nested exception:
[java.sql.SQLException: ORA-00957: duplicate column name]

How to resovle this error. Also, can we log sql statements sent by weblogic to database?

[Sagar Kale]

it was silly mistake in deployment descriptor.