|
PLEASE HELP. It seems that GenerationType.Identity is not working the SQL that gets generated for JPA Hibernate is added the @Id to the INSERT statement.
Hibernate version:
Hibernate 3.2.4.ga
Hibernate EntityManager 3.3.1.GA
Mapping documents: on JAVA
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name = "OID", insertable = false, updatable=false)
Full stack trace of any exception that occurs:
WARN org.hibernate.util.JDBCExceptionReporter (JDBCExceptionReporter.java:77)[] SQL Error: -1, SQLState: 42Z23
ERROR org.hibernate.util.JDBCExceptionReporter (JDBCExceptionReporter.java:78)[] Attempt to modify an identity column 'OID'.
Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [com.expd.app.erms.domain.legacy.Carrier]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:49)
at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131)
at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87)
at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:38)
at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:618)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:592)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:596)
at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:213)
... 38 more
Caused by: java.sql.SQLException: Attempt to modify an identity column 'OID'.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:30)
... 53 more
Caused by: org.apache.derby.client.am.SqlException: Attempt to modify an identity column 'OID'.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
... 57 more
Name and version of the database you are using:
INFO org.hibernate.cfg.SettingsFactory (SettingsFactory.java:89)[] RDBMS: Apache Derby, version: 10.2.2.0 - (485682)
INFO org.hibernate.cfg.SettingsFactory (SettingsFactory.java:90)[] JDBC driver: Apache Derby Network Client JDBC Driver, version: 10.2.2.0 - (485682)
INFO org.hibernate.dialect.Dialect (Dialect.java:152)[] Using dialect: org.hibernate.dialect.DerbyDialect
The generated SQL (show_sql=true):
Hibernate:
insert
into
CERTS.CARRIER
(CREATE_STAMP, DEL_STAMP, MOD_STAMP, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, ADDRESS5, OID_BRANCH, CITY, COMPANY_NAME, CONTACT, COUNTRY, EMAIL, FAX, IS_ACTIVE, PHONE, STATE, ZIP, OID)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
|
Login
FAQ
Search