Menu
▾
▴
hibernate-devel
|
From: Parimala <par...@ib...> - 2006-04-18 03:08:35
|
Hi,
I am not able to execute the stored procedure from the
hibernate.=20
I am getting the following Error
=20
2006-04-17 16:13:11,906 DEBUG QueryPlanCache - located native-sql query =
plan
in cache ({?=3Dcall getpatlinehib('SD00000225')})
2006-04-17 16:13:11,906 DEBUG SessionImpl - SQL query: {?=3Dcall
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 ( {?=3Dcall
getpatlinehib('SD00000225')} ) where rownum <=3D ?
Hibernate: select * from ( {?=3Dcall getpatlinehib('SD00000225')} ) =
where
rownum <=3D ?
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 [{?=3Dcall getpatlinehib('SD00000225')}]
java.sql.SQLException: ORA-00903: invalid table name
=20
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=
:21
5)
at
oracle.jdbc.driver.T4CCallableStatement.executeForDescribe(T4CCallableSta=
tem
ent.java:798)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.j=
ava
:1039)
at
oracle.jdbc.driver.T4CCallableStatement.executeMaybeDescribe(T4CCallableS=
tat
ement.java:838)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.j=
ava
:1132)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepared=
Sta
tement.java:3285)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatemen=
t.j
ava:3390)
at
oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatemen=
t.j
ava:4223)
at
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallab=
leS
tatement.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=
.ja
va: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=
.ja
va:294)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTem=
pla
te.java:366)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTem=
pla
te.java:334)
at
com.medicom.service.dao.hibernate.AbstractDAO.getNamedQuery(AbstractDAO.j=
ava
:279)
at
com.medicom.service.dao.hibernate.AbstractDAO.findByCriteria(AbstractDAO.=
jav
a:73)
at
com.medicom.service.dao.hibernate.AbstractDAO.delegateTransaction(Abstrac=
tDA
O.java:317)
at
com.medicom.framework.service.controller.POJOController.process(POJOContr=
oll
er.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
=20
=20
=20
What could be the possible reason and the solution. Lookinf forward 4 =
help.
=20
Thank u,
Parimala
|
|
From: Max R. A. <max...@jb...> - 2006-04-18 06:20:24
|
use the user forum.
/max
> 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:21
> 5)
>
> at
> oracle.jdbc.driver.T4CCallableStatement.executeForDescribe(T4CCallableStatem
> ent.java:798)
>
> at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java
> :1039)
>
> at
> oracle.jdbc.driver.T4CCallableStatement.executeMaybeDescribe(T4CCallableStat
> ement.java:838)
>
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
> :1132)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta
> tement.java:3285)
>
> at
> oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.j
> ava:3390)
>
> at
> oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.j
> ava:4223)
>
> at
> com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableS
> tatement.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.ja
> va: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.ja
> va:294)
>
> at
> org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTempla
> te.java:366)
>
> at
> org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTempla
> te.java:334)
>
> at
> com.medicom.service.dao.hibernate.AbstractDAO.getNamedQuery(AbstractDAO.java
> :279)
>
> at
> com.medicom.service.dao.hibernate.AbstractDAO.findByCriteria(AbstractDAO.jav
> a:73)
>
> at
> com.medicom.service.dao.hibernate.AbstractDAO.delegateTransaction(AbstractDA
> O.java:317)
>
> at
> com.medicom.framework.service.controller.POJOController.process(POJOControll
> er.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
>
--
--
Max Rydahl Andersen
callto://max.rydahl.andersen
Hibernate
ma...@hi...
http://hibernate.org
JBoss Inc
max...@jb...
|
Thanks for helping keep SourceForge clean.
X