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=lnkkid=110944bid=241720dat=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)
[Hibernate] hibernate , cglib 2.2.(2) , asm 2.x
Hello everyone,in my application I need to use asm 2.x . The latest version of hibernate I can find so far (at ibiblio repository, 3.1.2) depends on cglib 2.1.3, which in turn depends on asm 1.5.3. There's been an API refactoring from the two major releases of asm, which means the new version is not backward compatile. I'm also aware of the latest published version of cglib , but in the cglib cvs repository it possible to checkout a version which actually depends on asm2.x .My question then is the following: does the current version of hibernate will continue working if I 'manually' upgrade cglib (and all its dependencies) ? I'm asking this before doing because the checkout from sourceforge seems to not work right now, so maybe I can have some helpful feedback before getting into the whole process. Thanks a lot,Valerio Schiavoni-- http://valerioschiavoni.blogspot.comhttp://jroller.com/page/vschiavoni
Re: [Hibernate] hibernate , cglib 2.2.(2) , asm 2.x
1) I don't it will work because of api changes, but feel free to try/submit patches 2) In Hibernate 3.2 we can run (optionally) with javaassist, removing the need for the mentioned libraries 3) We don't use sf.net for cvs anymore, we use JBoss SVN (see http://hibernate.org/30.html#A3) /max Hello everyone, in my application I need to use asm 2.x . The latest version of hibernate I can find so far (at ibiblio repository, 3.1.2) depends on cglib 2.1.3, which in turn depends on asm 1.5.3. There's been an API refactoring from the two major releases of asm, which means the new version is not backward compatile. I'm also aware of the latest published version of cglib , but in the cglib cvs repository it possible to checkout a version which actually depends on asm2.x . My question then is the following: does the current version of hibernate will continue working if I 'manually' upgrade cglib (and all its dependencies) ? I'm asking this before doing because the checkout from sourceforge seems to not work right now, so maybe I can have some helpful feedback before getting into the whole process. Thanks a lot, Valerio Schiavoni -- http://valerioschiavoni.blogspot.com http://jroller.com/page/vschiavoni -- -- 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=lnkkid=110944bid=241720dat=121642 ___ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] hibernate , cglib 2.2.(2) , asm 2.x
Hello Max,before trying the proposed solution, i tried a different way: producing the simplest possible configuration file (i'm writing a spring application)..and i couldn't reproduce the error I got before. Unfortunatly, i get a MappingException: unknown entity..
the fact is, my entity is there:property name=annotatedClasseslist valueit.chi.commercialisti.model.Empty/value/list
/property(there are no other entities to be persisted);and the class looks like very simple:import javax.persistence.Entity;@Entitypublic class Empty {
public Empty() { }}So, i'm wondering wheter this problem comes from the manipulation performed over that class before it is persisted. In particular, i introduce (using
asm2.x) a field and related getter/setter methods.I was thinking about dynamically introducingthe annotation, but if I get this error with the current state of development, i guess there's something wrong in the technique.
i'm copy/pasting the stacktrace for sake of completeness. i could attach a testcase to reproduce the problem.feel free to forward me to the hibernate users forum.some info on my env:dependency
groupIdorg.hibernate/groupId artifactIdhibernate-annotations/artifactId version3.1beta8/version/dependencydependency
groupIdorg.hibernate/groupId artifactIdhibernate/artifactId version3.1.2/version/dependencyjava version 1.5.0_06
thanks,valerioOn 4/18/06, Max Rydahl Andersen [EMAIL PROTECTED] wrote:
1) I don't it will work because of api changes, but feel free totry/submit patches
2) In Hibernate 3.2 we can run (optionally) with javaassist, removing theneed for the mentioned libraries3) We don't use sf.net for cvs anymore, we use JBoss SVN (see
http://hibernate.org/30.html#A3)/max Hello everyone, in my application I need to use asm 2.x . The latest version of hibernate I can find so far (at ibiblio repository, 3.1.2
) depends on cglib 2.1.3, which in turn depends on asm 1.5.3. There's been an API refactoring from the two major releases of asm, which means the new version is not backward compatile.
I'malso awareof the latest published version of cglib , but in the cglib cvs repository it possible to checkouta version which actually depends on asm2.x . My question then is the following: does the current version of hibernate
will continue working if I 'manually' upgrade cglib (and all its dependencies) ? I'm asking this before doing because the checkout from sourceforge seems to not work right now, so maybe I can have some helpful
feedback before getting into the whole process. Thanks a lot, Valerio Schiavoni -- http://valerioschiavoni.blogspot.com
http://jroller.com/page/vschiavoniMax Rydahl Andersencallto://max.rydahl.andersenHibernate
[EMAIL PROTECTED]http://hibernate.orgJBoss Inc[EMAIL PROTECTED]--
http://valerioschiavoni.blogspot.com
Re: [Hibernate] hibernate , cglib 2.2.(2) , asm 2.x
the simplest possible configuration of hibernate is not via spring.
Just write a main class that creates a configuration, add the
mapping/class and
build the session factory. No magic - just works (assuming the libraries
are correct)
I don't know if changing the libs could affect here, but it shouldn't - it
should rather
fail pretty fast.
Questions/work on concrete issues with newer cglib/asm version in respect
to hibernate goes here.
basic configuration issues goes to the relevant user forum: Hibernate or
Spring.
/max
Hello Max,
before trying the proposed solution, i tried a different way: producing
the
simplest possible configuration file (i'm writing a spring
application)..and
i couldn't reproduce the error I got before.
Unfortunatly, i get a MappingException: unknown entity..
the fact is, my entity is there:
property name=annotatedClasses
list
valueit.chi.commercialisti.model.Empty/value
/list
/property
(there are no other entities to be persisted);
and the class looks like very simple:
import javax.persistence.Entity;
@Entity
public class Empty {
public Empty() {
}
}
So, i'm wondering wheter this problem comes from the manipulation
performed
over that class before it is persisted. In particular, i introduce (using
asm2.x) a field and related getter/setter methods.
I was thinking about dynamically introducing
the annotation, but if I get this error with the current state of
development, i guess there's something wrong in the technique.
i'm copy/pasting the stacktrace for sake of completeness. i could attach
a
testcase to reproduce the problem.
feel free to forward me to the hibernate users forum.
some info on my env:
dependency
groupIdorg.hibernate/groupId
artifactIdhibernate-annotations/artifactId
version3.1beta8/version
/dependency
dependency
groupIdorg.hibernate/groupId
artifactIdhibernate/artifactId
version3.1.2/version
/dependency
java version 1.5.0_06
thanks,
valerio
On 4/18/06, Max Rydahl Andersen [EMAIL PROTECTED] wrote:
1) I don't it will work because of api changes, but feel free to
try/submit patches
2) In Hibernate 3.2 we can run (optionally) with javaassist, removing
the
need for the mentioned libraries
3) We don't use sf.net for cvs anymore, we use JBoss SVN (see
http://hibernate.org/30.html#A3)
/max
Hello everyone,
in my application I need to use asm 2.x . The latest version of
hibernate I
can find so far (at ibiblio repository, 3.1.2) depends on cglib 2.1.3,
which
in turn depends on asm 1.5.3. There's been an API refactoring from the
two
major releases of asm, which means the new version is not backward
compatile.
I'm also aware of the latest published version of cglib , but in
the
cglib cvs repository it possible to checkout a version which actually
depends on asm2.x .
My question then is the following: does the current version of
hibernate
will continue working if I 'manually' upgrade cglib (and all its
dependencies) ? I'm asking this before doing because the checkout from
sourceforge seems to not work right now, so maybe I can have some
helpful
feedback before getting into the whole process.
Thanks a lot,
Valerio Schiavoni
--
http://valerioschiavoni.blogspot.com
http://jroller.com/page/vschiavoni
--
--
Max Rydahl Andersen
callto://max.rydahl.andersen
Hibernate
[EMAIL PROTECTED]
http://hibernate.org
JBoss Inc
[EMAIL PROTECTED]
--
http://valerioschiavoni.blogspot.com
--
--
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=lnkkid=110944bid=241720dat=121642
___
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
[Hibernate] left outer join
Hallo, can help me somebody. I wan't to to execute following MySQL-statement in hibernate: SELECT b.*, s* FROM bbp_test.BLSBAS b left outer join bbp_test.BLSSTR s on b.SBLS=s.SBLS where b.sbls like '%N710900%' The two tables are not in relation to each other. They both have only one column that is the same and this is SBLS. How can I execute this statement in Hibernate. Greeting, Stasa --- 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=lnkkid0944bid$1720dat1642 ___ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] left outer join
please go to forum.hibernate.org for user questions. /max Hallo, can help me somebody. I wan't to to execute following MySQL-statement in hibernate: SELECT b.*, s* FROM bbp_test.BLSBAS b left outer join bbp_test.BLSSTR s on b.SBLS=s.SBLS where b.sbls like '%N710900%' The two tables are not in relation to each other. They both have only one column that is the same and this is SBLS. How can I execute this statement in Hibernate. Greeting, Stasa --- 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=lnkkid0944bid$1720dat1642 ___ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel -- -- 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=lnkkid=110944bid=241720dat=121642 ___ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
[Hibernate] hibernate-oracle10-testsuite Build Completed With Testsuite Errors
View results here -> http://cruisecontrol.jboss.com/cc/buildresults/hibernate-oracle10-testsuite?log=log20060419001931 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/19/2006 00:19:31Time to build:15 minutes 22 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] hibernate-mysql-testsuite Build Completed With Testsuite Errors
View results here -> http://cruisecontrol.jboss.com/cc/buildresults/hibernate-mysql-testsuite?log=log20060419011347 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/19/2006 01:13:47Time to build:19 minutes 8 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)
