[Hibernate] hibernate-mysql-testsuite Build Completed With Testsuite Errors
View results here -> http://cruisecontrol.jboss.com/cc/buildresults/hibernate-mysql-testsuite?log=log20060417220002 TESTS FAILEDAnt Error Message: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:120: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:76: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-common-targets.xml:11: Build Successful - Tests completed with errors or failures.Date of build: 04/17/2006 22:00:02Time to build: 18 minutes 59 seconds Unit Tests: (826) Total Errors and Failures: (17)testUpdateWithWhereExistsSubqueryorg.hibernate.test.hql.BulkManipulationTesttestQueryorg.hibernate.test.legacy.FooBarTesttestOneToOneGeneratororg.hibernate.test.legacy.FooBarTesttestReachabilityorg.hibernate.test.legacy.FooBarTesttestVersionedCollectionsorg.hibernate.test.legacy.FooBarTesttestReturnPropertyComponentRenameorg.hibernate.test.legacy.SQLLoaderTesttestReadOnlyOnProxiesFailureExpectedorg.hibernate.test.readonly.ReadOnlyTesttestAutoDetectAliasingorg.hibernate.test.sql.GeneralTesttestScalarStoredProcedureorg.hibernate.test.sql.MySQLTesttestParameterHandlingorg.hibernate.test.sql.MySQLTesttestEntityStoredProcedureorg.hibernate.test.sql.MySQLTesttestEmptyInListFailureExpectedorg.hibernate.test.hql.HQLTesttestMaxindexHqlFunctionInElementAccessorFailureExpectedorg.hibernate.test.hql.HQLTesttestMultipleElementAccessorOperatorsFailureExpectedorg.hibernate.test.hql.HQLTesttestKeyManyToOneJoinFailureExpectedorg.hibernate.test.hql.HQLTesttestDuplicateExplicitJoinFailureExpectedorg.hibernate.test.hql.HQLTesttestCollectionFetchVsLoadorg.hibernate.test.stats.StatsTest Modifications since last build: (first 50 of 0)
[Hibernate] hibernate-oracle10-testsuite Build Completed With Testsuite Errors
View results here -> http://cruisecontrol.jboss.com/cc/buildresults/hibernate-oracle10-testsuite?log=log20060417221938 TESTS FAILEDAnt Error Message: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:99: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:76: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-common-targets.xml:11: Build Successful - Tests completed with errors or failures.Date of build: 04/17/2006 22:19:38Time to build: 15 minutes 54 seconds Unit Tests: (830) Total Errors and Failures: (10)testSequenceIdentityGeneratororg.hibernate.test.generatedkeys.seqidentity.SequenceIdentityTesttestReturnPropertyComponentRenameorg.hibernate.test.legacy.SQLLoaderTesttestReadOnlyOnProxiesFailureExpectedorg.hibernate.test.readonly.ReadOnlyTesttestResultTransformerScalarQueriesorg.hibernate.test.hql.ASTParserLoadingTesttestEmptyInListFailureExpectedorg.hibernate.test.hql.HQLTesttestMaxindexHqlFunctionInElementAccessorFailureExpectedorg.hibernate.test.hql.HQLTesttestMultipleElementAccessorOperatorsFailureExpectedorg.hibernate.test.hql.HQLTesttestKeyManyToOneJoinFailureExpectedorg.hibernate.test.hql.HQLTesttestDuplicateExplicitJoinFailureExpectedorg.hibernate.test.hql.HQLTesttestCollectionFetchVsLoadorg.hibernate.test.stats.StatsTest Modifications since last build: (first 50 of 0)
[Hibernate] stored procedure
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('SD0225')})
2006-04-17 16:13:11,906 DEBUG SessionImpl - SQL
query: {?=call getpatlinehib('SD0225')}
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('SD0225')} ) where rownum <= ?
Hibernate: select * from ( {?=call getpatlinehib('SD0225')}
) 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('SD0225')}]
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] hibernate-sybase-testsuite Build Timed Out
View results here -> http://cruisecontrol.jboss.com/cc/buildresults/hibernate-sybase-testsuite?log=log20060417223622 BUILD TIMED OUTAnt Error Message: build timeoutDate of build: 04/17/2006 22:36:22Time to build: Unit Tests: (0) Total Errors and Failures: (0) Modifications since last build: (first 50 of 0)
[Hibernate] hibernate-timesten-testsuite Build Completed With Testsuite Errors
View results here -> http://cruisecontrol.jboss.com/cc/buildresults/hibernate-timesten-testsuite?log=log20060418013622 TESTS FAILEDAnt Error Message: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:92: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:76: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-common-targets.xml:11: Build Successful - Tests completed with errors or failures.Date of build: 04/18/2006 01:36:22Time to build: 21 minutes 39 seconds Unit Tests: (828) Total Errors and Failures: (209)testCompositeIdsorg.hibernate.test.cid.CompositeIdTesttestNonLazyFetchorg.hibernate.test.cid.CompositeIdTesttestMultipleCollectionFetchorg.hibernate.test.cid.CompositeIdTesttestUpdateFalseorg.hibernate.test.component.ComponentTesttestComponentorg.hibernate.test.component.ComponentTesttestComponentFormulaQueryorg.hibernate.test.component.ComponentTesttestNamedQueryorg.hibernate.test.component.ComponentTesttestSerializationFailsOnAfterStatementAggressiveReleaseWithOpenResourcesorg.hibernate.test.connections.AggressiveReleaseTesttestQueryScrollingorg.hibernate.test.connections.AggressiveReleaseTesttestConnectedSerializationorg.hibernate.test.connections.AggressiveReleaseTesttestManualDisconnectWithOpenResourcesorg.hibernate.test.connections.AggressiveReleaseTesttestConnectedSerializationorg.hibernate.test.connections.BasicConnectionProviderTesttestManualDisconnectWithOpenResourcesorg.hibernate.test.connections.BasicConnectionProviderTesttestSerializationFailsOnAfterStatementAggressiveReleaseWithOpenResourcesorg.hibernate.test.connections.CurrentSessionConnectionTesttestQueryScrollingorg.hibernate.test.connections.CurrentSessionConnectionTesttestConnectedSerializationorg.hibernate.test.connections.CurrentSessionConnectionTesttestManualDisconnectWithOpenResourcesorg.hibernate.test.connections.CurrentSessionConnectionTesttestConnectedSerializationorg.hibernate.test.connections.SuppliedConnectionTesttestManualDisconnectWithOpenResourcesorg.hibernate.test.connections.SuppliedConnectionTesttestScrollCriteriaorg.hibernate.test.criteria.CriteriaQueryTesttestRestrictionOnSubclassCollectionorg.hibernate.test.criteria.CriteriaQueryTesttestClassPropertyorg.hibernate.test.criteria.CriteriaQueryTesttestCompositeUserTypeorg.hibernate.test.cut.CompositeUserTypeTesttestDom4jorg.hibernate.test.dom4j.Dom4jTesttestMapIndexEmisionorg.hibernate.test.dom4j.Dom4jTesttestStaleNonVersionedInstanceFoundOnLockorg.hibernate.test.ejb3.lock.RepeatableReadTesttestOrphanDeleteorg.hibernate.test.extralazy.ExtraLazyTesttestIndexFormulaMaporg.hibernate.test.extralazy.ExtraLazyTesttestCollectionJoinsInSubselectorg.hibernate.test.hql.ASTParserLoadingTesttestCollectionFetchWithDistinctionAndLimitorg.hibernate.test.hql.ASTParserLoadingTesttestNestedCollectionFetchorg.hibernate.test.hql.ASTParserLoadingTesttestSelectClauseSubselectorg.hibernate.test.hql.ASTParserLoadingTesttestImplicitPolymorphismorg.hibernate.test.hql.ASTParserLoadingTesttestCoalesceorg.hibernate.test.hql.ASTParserLoadingTesttestStrorg.hibernate.test.hql.ASTParserLoadingTesttestCastorg.hibernate.test.hql.ASTParserLoadingTesttestExtractorg.hibernate.test.hql.ASTParserLoadingTesttestOneToManyFilterorg.hibernate.test.hql.ASTParserLoadingTesttestSelectExpressionsorg.hibernate.test.hql.ASTParserLoadingTesttestWhereorg.hibernate.test.hql.ASTParserLoadingTesttestEntityFetchingorg.hibernate.test.hql.ASTParserLoadingTesttestCollectionFetchingorg.hibernate.test.hql.ASTParserLoadingTesttestStandardFunctionsorg.hibernate.test.hql.ASTParserLoadingTesttestDynamicInstantiationQueriesorg.hibernate.test.hql.ASTParserLoadingTesttestResultTransformerScalarQueriesorg.hibernate.test.hql.ASTParserLoadingTesttestResultTransformerEntityQueriesorg.hibernate.test.hql.ASTParserLoadingTesttestEJBQLFunctionsorg.hibernate.test.hql.ASTParserLoadingTesttestSubselectBetweenorg.hibernate.test.hql.ASTParserLoadingTesttestTempTableGenerationIsolationorg.hibernate.test.hql.BulkManipulationTesttestSimpleInsertorg.hibernate.test.hql.BulkManipulationTesttestSimpleNativeSQLInsertorg.hibernate.test.hql.BulkManipulationTesttestInsertWithManyToOneorg.hibernate.test.hql.BulkManipulationTesttestInsertWithMismatchedTypesorg.hibernate.test.hql.BulkManipulationTesttestInsertIntoSuperclassPropertiesFailsorg.hibernate.test.hql.BulkManipulationTesttestInsertAcrossMappedJoinFailsorg.hibernate.test.hql.BulkManipulationTesttestInsertWithGeneratedIdorg.hibernate.test.hql.BulkManipulationTesttestInsertWithGeneratedVersionAndIdorg.hibernate.test.hql.BulkManipulationTesttestInsertWithGeneratedTimestampVersionorg.hibernate.test.hql.BulkManipulationTesttestUpdateOnDiscriminatorSubclassorg.hibernate.test.hql.BulkManipulationTesttestUpdateOnAnimalorg.hibernate.test.hql.BulkManipulationTesttestUpdateOnMammalorg.hibernate.test.hql.BulkManipulationTesttestUpdate
Re: [Hibernate] stored procedure
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('SD0225')})
2006-04-17 16:13:11,906 DEBUG SessionImpl - SQL query: {?=call
getpatlinehib('SD0225')}
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('SD0225')} ) where rownum <= ?
Hibernate: select * from ( {?=call getpatlinehib('SD0225')} ) 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('SD0225')}]
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
[EMAIL PROTECTED]
http://hibernate.org
JBoss Inc
[EMAIL PROTECTED]
---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
__
[Hibernate] hibernate-hsqldb-testsuite Build Completed With Testsuite Errors
View results here -> http://cruisecontrol.jboss.com/cc/buildresults/hibernate-hsqldb-testsuite?log=log20060418021136 TESTS FAILEDAnt Error Message: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:85: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:76: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-common-targets.xml:11: Build Successful - Tests completed with errors or failures.Date of build: 04/18/2006 02:11:36Time to build: 8 minutes 32 seconds Unit Tests: (828) Total Errors and Failures: (8)testReturnPropertyComponentRenameorg.hibernate.test.legacy.SQLLoaderTesttestReadOnlyOnProxiesFailureExpectedorg.hibernate.test.readonly.ReadOnlyTesttestEmptyInListFailureExpectedorg.hibernate.test.hql.HQLTesttestMaxindexHqlFunctionInElementAccessorFailureExpectedorg.hibernate.test.hql.HQLTesttestMultipleElementAccessorOperatorsFailureExpectedorg.hibernate.test.hql.HQLTesttestKeyManyToOneJoinFailureExpectedorg.hibernate.test.hql.HQLTesttestDuplicateExplicitJoinFailureExpectedorg.hibernate.test.hql.HQLTesttestCollectionFetchVsLoadorg.hibernate.test.stats.StatsTest Modifications since last build: (first 50 of 0)
