-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 1 post ] 
  Previous topic | Next topic 
Author Message
singular_droid
 Post subject: composite-id and sored-proc
PostPosted: Tue Jun 28, 2005 8:49 am 
Newbie

Joined: Thu Apr 14, 2005 8:21 am
Posts: 5
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.0.2

HI all. I have a legacy oracle stored proc which returns a ref cursor. Rows in ref cursor are identified with 2 fields CODGOOD and CODVAR.
when i write the following mapping:

Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="ru.zenith.dealer.service.hibernate">
   <class name="VarrefgoodUpdateBean">
      <composite-id>
         <key-property name="codgood" column="CODGOOD" type="java.lang.Long"/>
         <key-property name="codvar" column="CODVAR" type="java.lang.Long"/>
      </composite-id>
      
      <property name="i_value" column="I_VALUE" type="java.lang.Integer" />
      <property name="opdml" column="OPDML" type="java.lang.Integer" />
      <property name="log" column="LOG" type="java.lang.Long" />
      <loader query-ref="varrefgood_update" />
   </class>

   <sql-query callable="true" name="get_varrefgood_update">
      <return alias="varrefgood_update" class="VarrefgoodUpdateBean">
         <return-property name="codgood" column="CODGOOD" />
         <return-property name="codvar" column="CODVAR" />
         <return-property name="i_value" column="I_VALUE" />
         <return-property name="log" column="LOG" />
         <return-property name="opdml" column="OPDML" />
      </return>
      {? = call
      trate.pks_remote_diler.get_varrefgood_update_soap(:in_log,:first_load)
      }
   </sql-query>
</hibernate-mapping>


and try to execute this code:
Code:
      VarrefgoodUpdateBean[] vub = new VarrefgoodUpdateBean[1];
      session = sessionFactory.openSession();
      Transaction tx = session.beginTransaction();
      Query query = session.getNamedQuery("get_varrefgood_update");
      query.setLong("in_log", p_log);
      query.setLong("first_load", p_firstload);
      logger.info("get_varrefgood_update() after binding input values: in_log="
                  + p_log + "; first_load=" + p_firstload);
      List l = query.list();
      logger.debug("after executing");
      vub = (VarrefgoodUpdateBean[]) l.toArray(vub);
      tx.commit();

i have an exception
Code:
2005-06-28 16:46:16,562 DEBUG [org.hibernate.SQL] {? = call trate.pks_remote_diler.get_varrefgood_update_soap(?,?) }
2005-06-28 16:46:16,562 INFO  [STDOUT] Hibernate: {? = call trate.pks_remote_diler.get_varrefgood_update_soap(?,?) }
2005-06-28 16:46:16,562 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
2005-06-28 16:46:16,562 DEBUG [org.hibernate.type.LongType] binding '1' to parameter: 3
2005-06-28 16:46:16,562 DEBUG [org.hibernate.type.LongType] binding '-1' to parameter: 2
2005-06-28 16:46:16,578 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2005-06-28 16:46:16,578 DEBUG [org.hibernate.loader.Loader] processing result set
2005-06-28 16:46:16,578 DEBUG [org.hibernate.loader.Loader] result set row: 0
2005-06-28 16:46:16,578 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
2005-06-28 16:46:16,578 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2005-06-28 16:46:16,578 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
2005-06-28 16:46:16,578 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [{? = call trate.pks_remote_diler.get_varrefgood_update_soap(?,?) }]
java.sql.SQLException: Не.о.уст.мое .м. сто...а
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:6221)
   at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1557)
   at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1540)
   at org.hibernate.type.LongType.get(LongType.java:26)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:77)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:68)
   at org.hibernate.type.AbstractType.hydrate(AbstractType.java:80)
   at org.hibernate.type.ComponentType.hydrate(ComponentType.java:422)
   at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:182)
   at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:722)
   at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:284)
   at org.hibernate.loader.Loader.doQuery(Loader.java:391)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
   at org.hibernate.loader.Loader.doList(Loader.java:1557)
   at org.hibernate.loader.Loader.list(Loader.java:1540)
   at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:103)
   at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1341)
   at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:151)
   at ru.zenith.dealer.service.ejb.DealerServiceBean.getVarrefgoodUpdate(DealerServiceBean.java:378)
   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:585)
   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:106)
   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:585)
   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.webservice.server.InvokerProviderEJB.invokeServiceEndpoint(InvokerProviderEJB.java:128)
   at org.jboss.webservice.server.InvokerProvider.invokeMethod(InvokerProvider.java:347)
   at org.apache.axis.providers.java.RPCProvider.invokeTarget(RPCProvider.java:177)
   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:122)
   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:360)
   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:73)
   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:162)
   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:125)
   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:557)
   at org.jboss.webservice.server.ServerEngine.invokeInternal(ServerEngine.java:202)
   at org.jboss.webservice.server.ServerEngine.invoke(ServerEngine.java:91)
   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:971)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:372)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
   at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
   at java.lang.Thread.run(Thread.java:595)
2005-06-28 16:46:16,578 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 17006, SQLState: null
2005-06-28 16:46:16,578 ERROR [org.hibernate.util.JDBCExceptionReporter] Не.о.уст.мое .м. сто...а
2005-06-28 16:46:16,578 ERROR [org.jboss.webservice.server.ServiceEndpointInterceptor] Error from service endpoint, processing fault handler chain
org.hibernate.exception.SQLGrammarException: could not execute query
   at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.loader.Loader.doList(Loader.java:1560)
   at org.hibernate.loader.Loader.list(Loader.java:1540)
   at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:103)
   at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1341)
   at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:151)
   at ru.zenith.dealer.service.ejb.DealerServiceBean.getVarrefgoodUpdate(DealerServiceBean.java:378)
   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:585)
   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:106)
   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:585)
   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.webservice.server.InvokerProviderEJB.invokeServiceEndpoint(InvokerProviderEJB.java:128)
   at org.jboss.webservice.server.InvokerProvider.invokeMethod(InvokerProvider.java:347)
   at org.apache.axis.providers.java.RPCProvider.invokeTarget(RPCProvider.java:177)
   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:122)
   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:360)
   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:73)
   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:162)
   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:125)
   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:557)
   at org.jboss.webservice.server.ServerEngine.invokeInternal(ServerEngine.java:202)
   at org.jboss.webservice.server.ServerEngine.invoke(ServerEngine.java:91)
   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:971)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:372)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
   at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
   at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Не.о.уст.мое .м. сто...а
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:6221)
   at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1557)
   at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1540)
   at org.hibernate.type.LongType.get(LongType.java:26)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:77)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:68)
   at org.hibernate.type.AbstractType.hydrate(AbstractType.java:80)
   at org.hibernate.type.ComponentType.hydrate(ComponentType.java:422)
   at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:182)
   at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:722)
   at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:284)
   at org.hibernate.loader.Loader.doQuery(Loader.java:391)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
   at org.hibernate.loader.Loader.doList(Loader.java:1557)
   ... 78 more
2005-06-28 16:46:16,593 DEBUG [org.hibernate.transaction.CacheSynchronization] transaction after completion callback, status: 4
2005-06-28 16:46:16,593 DEBUG [org.hibernate.jdbc.JDBCContext] after transaction completion
2005-06-28 16:46:16,593 DEBUG [org.hibernate.impl.SessionImpl] after transaction completion
2005-06-28 16:46:16,593 DEBUG [org.hibernate.transaction.CacheSynchronization] automatically closing session
2005-06-28 16:46:16,593 DEBUG [org.hibernate.impl.SessionImpl] automatically closing session
2005-06-28 16:46:16,593 DEBUG [org.hibernate.impl.SessionImpl] closing session
2005-06-28 16:46:16,593 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing JDBC connection (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)
2005-06-28 16:46:16,593 DEBUG [org.hibernate.jdbc.JDBCContext] after transaction completion
2005-06-28 16:46:16,593 DEBUG [org.hibernate.impl.SessionImpl] after transaction completion
2005-06-28 16:46:16,593 ERROR [org.jboss.ejb.plugins.LogInterceptor] RuntimeException in method: public abstract ru.zenith.dealer.service.hibernate.VarrefgoodUpdateBean[] ru.zenith.dealer.service.interfaces.DealerServiceBeanEndpoint.getVarrefgoodUpdate(long,long) throws java.rmi.RemoteException:
org.hibernate.exception.SQLGrammarException: could not execute query
   at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.loader.Loader.doList(Loader.java:1560)
   at org.hibernate.loader.Loader.list(Loader.java:1540)
   at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:103)
   at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1341)
   at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:151)
   at ru.zenith.dealer.service.ejb.DealerServiceBean.getVarrefgoodUpdate(DealerServiceBean.java:378)
   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:585)
   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:106)
   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:585)
   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.webservice.server.InvokerProviderEJB.invokeServiceEndpoint(InvokerProviderEJB.java:128)
   at org.jboss.webservice.server.InvokerProvider.invokeMethod(InvokerProvider.java:347)
   at org.apache.axis.providers.java.RPCProvider.invokeTarget(RPCProvider.java:177)
   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:122)
   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:360)
   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:73)
   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:162)
   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:125)
   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:557)
   at org.jboss.webservice.server.ServerEngine.invokeInternal(ServerEngine.java:202)
   at org.jboss.webservice.server.ServerEngine.invoke(ServerEngine.java:91)
   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:971)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:372)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
   at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
   at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Не.о.уст.мое .м. сто...а
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:6221)
   at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1557)
   at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1540)
   at org.hibernate.type.LongType.get(LongType.java:26)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:77)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:68)
   at org.hibernate.type.AbstractType.hydrate(AbstractType.java:80)
   at org.hibernate.type.ComponentType.hydrate(ComponentType.java:422)
   at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:182)
   at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:722)
   at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:284)
   at org.hibernate.loader.Loader.doQuery(Loader.java:391)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
   at org.hibernate.loader.Loader.doList(Loader.java:1557)
   ... 78 more
2005-06-28 16:46:16,625 ERROR [org.jboss.webservice.server.ServerEngine] Server error: AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Client
faultSubcode:
faultString: javax.management.MBeanException
faultActor:
faultNode:
faultDetail:
   {http://xml.apache.org/axis/}stackTrace: javax.management.MBeanException
   at org.jboss.mx.interceptor.ReflectedDispatcher.handleInvocationExceptions(ReflectedDispatcher.java:166)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:149)
   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.webservice.server.InvokerProviderEJB.invokeServiceEndpoint(InvokerProviderEJB.java:128)
   at org.jboss.webservice.server.InvokerProvider.invokeMethod(InvokerProvider.java:347)
   at org.apache.axis.providers.java.RPCProvider.invokeTarget(RPCProvider.java:177)
   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:122)
   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:360)
   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:73)
   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:162)
   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:125)
   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:557)
   at org.jboss.webservice.server.ServerEngine.invokeInternal(ServerEngine.java:202)
   at org.jboss.webservice.server.ServerEngine.invoke(ServerEngine.java:91)
   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:971)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:372)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
   at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
   at java.lang.Thread.run(Thread.java:595)
Caused by: java.rmi.ServerException: RuntimeException; nested exception is:
   org.hibernate.exception.SQLGrammarException: could not execute query
   at org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:361)
   at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
   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:585)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
   ... 50 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
   at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.loader.Loader.doList(Loader.java:1560)
   at org.hibernate.loader.Loader.list(Loader.java:1540)
   at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:103)
   at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1341)
   at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:151)
   at ru.zenith.dealer.service.ejb.DealerServiceBean.getVarrefgoodUpdate(DealerServiceBean.java:378)
   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:585)
   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:106)
   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)
   ... 58 more
Caused by: java.sql.SQLException: Не.о.уст.мое .м. сто...а
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:6221)
   at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1557)
   at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1540)
   at org.hibernate.type.LongType.get(LongType.java:26)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:77)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:68)
   at org.hibernate.type.AbstractType.hydrate(AbstractType.java:80)
   at org.hibernate.type.ComponentType.hydrate(ComponentType.java:422)
   at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:182)
   at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:722)
   at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:284)
   at org.hibernate.loader.Loader.doQuery(Loader.java:391)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
   at org.hibernate.loader.Loader.doList(Loader.java:1557)
   ... 78 more




I have implemented Serializable and hashCode() and equals() in class VarrefgoodUpdateBean
Code:
/**
*
*/
package ru.zenith.dealer.service.hibernate;

import java.io.Serializable;


/**
* @author droid
*
*/
public class VarrefgoodUpdateBean implements Serializable{
   
   private java.lang.Long codvar;
   private java.lang.Integer i_value;
   private java.lang.Long codgood;
   private java.lang.Integer opdml;
   private java.lang.Long log;

   
   public VarrefgoodUpdateBean(){
   }
   
   /**
    * @param codvar
    * @param i_value
    * @param codgood
    * @param opdml
    * @param log
    */
   public VarrefgoodUpdateBean(Long codvar, Integer i_value, Long codgood, Integer opdml, Long log) {

      
      this.codvar = codvar;
      this.i_value = i_value;
      this.codgood = codgood;
      this.opdml = opdml;
      this.log = log;
   }
   
   public java.lang.Long getCodgood() {
      return codgood;
   }
   public void setCodgood(java.lang.Long codgood) {
      this.codgood = codgood;
   }
   public java.lang.Long getCodvar() {
      return codvar;
   }
   public void setCodvar(java.lang.Long codvar) {
      this.codvar = codvar;
   }
   public java.lang.Integer getI_value() {
      return i_value;
   }
   public void setI_value(java.lang.Integer i_value) {
      this.i_value = i_value;
   }
   public java.lang.Long getLog() {
      return log;
   }
   public void setLog(java.lang.Long log) {
      this.log = log;
   }
   public java.lang.Integer getOpdml() {
      return opdml;
   }
   public void setOpdml(java.lang.Integer opdml) {
      this.opdml = opdml;
   }

   public int hashCode() {
      return opdml.hashCode()+ i_value.hashCode() + codvar.hashCode() + codgood.hashCode()+log.hashCode();
   }
   
   public boolean equals(Object other) {
      if (this == other)
         return true;
      if (!(other instanceof VarrefgoodUpdateBean))
         return false;
      final VarrefgoodUpdateBean vup = (VarrefgoodUpdateBean) other;
      if (!vup.getLog().equals(getLog()))
         return false;
      if (!vup.getCodgood().equals(getCodgood()))
         return false;
      if (!vup.getCodvar().equals(getCodvar()))
         return false;
      if (!vup.getI_value().equals(getI_value()))
         return false;
      if (!vup.getOpdml().equals(getOpdml()))
         return false;
      return true;
   }


}
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 1 post ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.