Hi,
I get the following error when trying to insert a record into the database:
net.sf.hibernate.exception.GenericJDBCException: Could not save object
at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:794)
at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:749)
at sg.gov.ciris.dao.MtMergeHdrDao.createMergeRequestRecord(MtMergeHdrDao.java:752)
at sg.gov.ciris.idm.MtMgrBean.createMergeRequestRecord(MtMgrBean.java:2796)
at sg.gov.ciris.idm.MtMgr_lpphm8_ELOImpl.createMergeRequestRecord(MtMgr_lpphm8_ELOImpl.java:3105)
at sg.gov.ciris.idm.delegate.MtDelegate.createMergeRequestRecord(MtDelegate.java:1296)
at idm.mergeFinRequest.MergeFinRequestController.processMergeRequest(MergeFinRequestController.jpf:300)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:1498)
at com.bea.wlw.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:1433)
at com.bea.wlw.netui.pageflow.FlowController.internalExecute(FlowController.java:764)
at com.bea.wlw.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:211)
at com.bea.wlw.netui.pageflow.FlowController.execute(FlowController.java:594)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:650)
at com.bea.wlw.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:527)
at com.bea.wlw.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:152)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6722)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
Caused by: java.sql.SQLException: ORA-02289: sequence does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:894)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:984)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2885)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2926)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:124)
at net.sf.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:64)
at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:776)
Given below is the MtMergeHdr.hbm.xml file:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>
<class
name="sg.gov.ciris.entity.MtMergeHdr"
table="MT_MERGE_HDR"
>
<id
name="mergeId"
type="java.lang.Long"
column="MERGE_ID"
>
<generator class="native" />
</id>
<version name="version" column="VERSION" type="java.lang.Long"/>
<property
name="obsoleteUuid"
type="java.lang.Long"
column="OBSOLETE_UUID"
not-null="true"
>
</property>
<property
name="activeUuid"
type="java.lang.Long"
column="ACTIVE_UUID"
not-null="true"
>
</property>
<property
name="obsoleteFin"
type="java.lang.String"
column="OBSOLETE_FIN"
not-null="true"
>
</property>
<property
name="activeFin"
type="java.lang.String"
column="ACTIVE_FIN"
not-null="true"
>
</property>
<property
name="requestBy"
type="java.lang.String"
column="REQUEST_BY"
not-null="true"
>
</property>
<property
name="requestDept"
type="java.lang.String"
column="REQUEST_DEPT"
not-null="true"
>
</property>
<property
name="mergeResult"
type="java.lang.String"
column="MERGE_RESULT"
not-null="true"
>
</property>
<property
name="createDt"
type="java.util.Date"
column="CREATE_DT"
insert="false"
update="false"
not-null="true"
>
</property>
<property
name="createBy"
type="java.lang.String"
column="CREATE_BY"
not-null="true"
>
</property>
</class>
</hibernate-mapping>
Any idea what could be the cause of this exception?
Thanks in advance.
Login
FAQ
Search
