Hibernate version:2.1.7 deployed as har service in Jboss4.0
Mapping documents:<hibernate-mapping> <class name="com.util.vo.State" table="States"> <id name="id" type="int" column="id" unsaved-value="0"> <generator class="increment"/> </id> <property name="name"/> <property name="shortName"/> </class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
Full stack trace of any exception that occurs: 16:25:26,453 INFO [STDOUT] In ProductDAO -- getAllStates() 16:25:26,531 INFO [STDOUT] Hibernate: select state0_.id as id, state0_.name as name, state0_.shortName as shortName from States state0_ 16:25:26,765 INFO [STDOUT] before saving obj .class com.bowebellhowell.util.vo.State 16:25:26,812 WARN [JDBCExceptionReporter] SQL Error: 335544569, SQLState: HY000 16:25:26,812 ERROR [JDBCExceptionReporter] GDS Exception. 335544569. Dynamic SQL Error SQL error code = -204 Table unknown States At line 1, column 16. 16:25:26,828 INFO [STDOUT] net.sf.hibernate.exception.GenericJDBCException: Could not save object at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:81) at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30) at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4110) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:792) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:747) at com.bowebellhowell.delegates.HibernateReadOnlyDelegate.save(HibernateReadOnlyDelegate.java:88) at com.bowebellhowell.productmanager.dao.ProductDAO.addState(ProductDAO.java:69) at com.bowebellhowell.productmanager.ProductManagerImpl.addState(ProductManagerImpl.java:57) 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 org.jboss.invocation.Invocation.performCall(Invocation.java:345) at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:113) at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51) at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624) at org.jboss.ejb.Container.invoke(Container.java:854) 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 org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:775) at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382) 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 sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) at sun.rmi.transport.Transport$1.run(Transport.java:148) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:144) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701) at java.lang.Thread.run(Thread.java:534) Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error SQL error code = -204 Table unknown States At line 1, column 16. at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:88) at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:34) at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:682) at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:232) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:355) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:205) at net.sf.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:65) at net.sf.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:42) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:774) ... 44 more 16:25:26,828 INFO [STDOUT] me closing the session
Name and version of the database you are using:Firebird 1.5
The generated SQL (show_sql=true):No SQL generated .. the error is thrown before hibernate session saves the object
Debug level Hibernate log excerpt:
I can read from the table. The problem is when I try to write .. I am getting this error messages as Table unknown. Am I missing any jar files .. it seems something is fishy in creating generator ...
I did spend couple of days on this .. any help/hint appreciated.
Thanks.
--Anand
|