[Hibernate] stored procedure

Parimala Mon, 17 Apr 2006 20:09:07 -0700

Hi,

I am not able to execute the stored procedure from the hibernate.

I am getting the following Error

2006-04-17 16:13:11,906 DEBUG QueryPlanCache - located native-sql query plan in cache ({?=call getpatlinehib('SD00000225')})

2006-04-17 16:13:11,906 DEBUG SessionImpl - SQL query: {?=call getpatlinehib('SD00000225')}

2006-04-17 16:13:11,906 DEBUG AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)

2006-04-17 16:13:11,906 DEBUG ConnectionManager - opening JDBC connection

2006-04-17 16:13:11,906 DEBUG SQL - select * from ( {?=call getpatlinehib('SD00000225')} ) where rownum <= ?

Hibernate: select * from ( {?=call getpatlinehib('SD00000225')} ) where rownum <= ?

2006-04-17 16:13:11,906 DEBUG AbstractBatcher - preparing statement

2006-04-17 16:13:12,140 DEBUG AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)

2006-04-17 16:13:12,140 DEBUG AbstractBatcher - closing statement

2006-04-17 16:13:12,156 DEBUG JDBCExceptionReporter - could not execute query [{?=call getpatlinehib('SD00000225')}]

java.sql.SQLException: ORA-00903: invalid table name

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)

at oracle.jdbc.driver.T4CCallableStatement.executeForDescribe(T4CCallableStatement.java:798)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)

at oracle.jdbc.driver.T4CCallableStatement.executeMaybeDescribe(T4CCallableStatement.java:838)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)

at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4223)

at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2965)

at org.hibernate.dialect.Oracle9Dialect.getResultSet(Oracle9Dialect.java:278)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:146)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1666)

at org.hibernate.loader.Loader.doQuery(Loader.java:662)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)

at org.hibernate.loader.Loader.doList(Loader.java:2145)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)

at org.hibernate.loader.Loader.list(Loader.java:2024)

at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111)

at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1674)

at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:147)

at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)

at com.medicom.service.dao.hibernate.AbstractDAO$2.doInHibernate(AbstractDAO.java:294)

at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)

at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)

at com.medicom.service.dao.hibernate.AbstractDAO.getNamedQuery(AbstractDAO.java:279)

at com.medicom.service.dao.hibernate.AbstractDAO.findByCriteria(AbstractDAO.java:73)

at com.medicom.service.dao.hibernate.AbstractDAO.delegateTransaction(AbstractDAO.java:317)

at com.medicom.framework.service.controller.POJOController.process(POJOController.java:30)

at com.medicom.framework.service.ServiceRouter.route(ServiceRouter.java:32)

at com.medicom.framework.service.ServiceRequest.process(ServiceRequest.java:58)

at com.medicom.test.TestIP.main(TestIP.java:40)

2006-04-17 16:13:12,156 WARN JDBCExceptionReporter - SQL Error: 903, SQLState: 42000

2006-04-17 16:13:12,156 ERROR JDBCExceptionReporter - ORA-00903: invalid table name

What could be the possible reason and the solution. Lookinf forward 4 help.

Thank u,

Parimala

[Hibernate] stored procedure

Reply via email to