Dear all,
I am a new user of Hibernate. I have the following hbm.xml file and calling save method with the following code and the error is listed below respectively. I have created the sequence in the database and the table exists so can't figure aout the problem. Can anyone help about guessing the problem?
Best Regards,
Ersan.
Code:
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jan 27, 2010 10:30:22 AM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
<class
name="xxx.hibernate.VariantMerchantCategoryLog"
table="VARIANT_MERCHANT_CATE_LOG" schema="MICROPAYMENT_REPORT">
<id name="logId" type="integer">
<column name="LOG_ID" precision="15" scale="0" />
<generator class="sequence">
<param name="sequence">
<![CDATA[MICROPAYMENT_REPORT.VARIANT_MERCHANT_CATE_LOG_SEQ]]>
</param>
</generator>
</id>
<property name="username" type="string">
<column name="USERNAME" length="50" />
</property>
<property name="tablename" type="string">
<column name="TABLENAME" length="30" />
</property>
<property name="columnname" type="string">
<column name="COLUMNNAME" length="30" />
</property>
<property name="action" type="string">
<column name="ACTION" length="20" />
</property>
<property name="oldValue" type="string">
<column name="OLD_VALUE" length="100" />
</property>
<property name="newValue" type="string">
<column name="NEW_VALUE" length="100" />
</property>
<property name="timeStamp" type="date">
<column name="TIMESTAMP" length="10" />
</property>
</class>
</hibernate-mapping>
Calling:
Code:
variantMerchantCategoryLogDAO.save(variantMerchantCategoryLog);
Error:
Code:
Hibernate: select
MICROPAYMENT_REPORT.VARIANT_MERCHANT_CATE_LOG_SEQ
.nextval from dual
org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:615)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:379)
at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:645)
at com.turkcelltech.mobilepayment.hibernate.dao.base.BaseDao.save(BaseDao.java:64)
at com.turkcelltech.mobilepayment.hibernate.dao.VariantMerchantCategoryLogDAO.save(VariantMerchantCategoryLogDAO.java:7)
at com.turkcelltech.mobilepayment.view.base.BaseFormController.beforeModelUpdate(BaseFormController.java:222)
at com.turkcelltech.mobilepayment.view.base.BaseFormController.persist(BaseFormController.java:176)
at com.turkcelltech.mobilepayment.view.base.BaseFormController.handleRequest(BaseFormController.java:74)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:874)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:808)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:523)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:463)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3368)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2117)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2023)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1359)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
Caused by: org.hibernate.exception.SQLGrammarException: could not get next sequence value
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:648)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:374)
... 28 more
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist