Hi,
Hibernate: 1.1.8
Oracle: 9.0.1i
I first tested my code against SQL Server then I also need tom make it work
under Oracle. When using oracle, and DBCP as connection provider (if set to
C3PO or driver manager it works fine), I received the following exception:
[INFO] Environment - -Hibernate 1.1.6 (?? Release doc says 1.1.8 ??)
[INFO] Environment - -loaded properties from resource hibernate.properties
[INFO] Environment - -using java.io streams to persist binary types
[INFO] Environment - -JVM proxy support: true
[INFO] Dialect - -Using dialect: cirrus.hibernate.sql.OracleDialect
[INFO] ConnectionProviderFactory - -Initializing connection provider:
cirrus.hibernate.connection.DBCPConnectionProvider
[INFO] DBCPConnectionProvider - -DBCP using driver:
oracle.jdbc.driver.OracleDriver at URL:
jdbc:oracle:thin:@localhost:1521:ORACLE
[INFO] DBCPConnectionProvider - -Connection properties: {user=****,
password=****}
[INFO] DBCPConnectionProvider - -JDBC isolation level: READ_COMMITTED
[INFO] SessionFactoryImpl - -JDBC result set fetch size: 25
[INFO] SessionFactoryImpl - -Use outer join fetching: false
[WARN] JDBCExceptionReporter - -SQL Error: 1453, SQLState: 72000
[ERROR] JDBCExceptionReporter - -ORA-01453: SET TRANSACTION must be the
first instruction of the transaction
java.sql.SQLException: ORA-01453: SET TRANSACTION must be the first
instruction of the transaction
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047
)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2709)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:854)
at
oracle.jdbc.driver.OracleConnection.setTransactionIsolation(OracleConnection
.java:1634)
at
org.apache.commons.dbcp.DelegatingConnection.setTransactionIsolation(Delegat
ingConnection.java:240)
at
org.apache.commons.dbcp.DelegatingConnection.setTransactionIsolation(Delegat
ingConnection.java:240)
at
cirrus.hibernate.connection.DBCPConnectionProvider.getConnection(DBCPConnect
ionProvider.java:41)
at
cirrus.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:149)
at
cirrus.hibernate.impl.DatastoreImpl.buildSessionFactory(DatastoreImpl.java:3
23)
at
cirrus.hibernate.impl.DatastoreImpl.buildSessionFactory(DatastoreImpl.java:3
14)
at
com.source.frk.dao.persistence.hibernate.HibernateDAO.getSessionFactoryInsta
nce(HibernateDAO.java:44)
at
com.source.frk.dao.persistence.hibernate.HibernateDAO.openSession(HibernateD
AO.java:113)
at
com.source.task.elimination.dao.persistence.hibernate.FinancialInstitutionHi
bernateDAO.insertFinancialInstitutionData(FinancialInstitutionHibernateDAO.j
ava:47)
at
com.source.task.elimination.test.FinancialInstitutionTest.testCrud(Financial
InstitutionTest.java:166)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:166)
at junit.framework.TestCase.runBare(TestCase.java:140)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:131)
at junit.framework.TestSuite.runTest(TestSuite.java:173)
at junit.framework.TestSuite.run(TestSuite.java:168)
at junit.textui.TestRunner.doRun(TestRunner.java:74)
at junit.textui.TestRunner.run(TestRunner.java:200)
at
com.source.task.elimination.test.FinancialInstitutionTest.main(FinancialInst
itutionTest.java:28)
[WARN] SessionFactoryImpl - -Could not obtain connection metadata
<java.sql.SQLException: ORA-01453: SET TRANSACTION must be the first
instruction of the transaction
>
[INFO] SessionFactoryImpl - -Use scrollable result sets: true
[INFO] SessionFactoryImpl - -Transaction strategy:
cirrus.hibernate.transaction.JDBCTransactionFactory
[INFO] SessionFactoryImpl - -echoing all SQL to stdout
[WARN] SessionFactoryObjectFactory - -no JDNI name configured
[INFO] SessionFactoryImpl - -Query language substitutions: {false=0, no='N',
yes='Y', true=1}
[INFO] SessionFactoryImpl - -Query language imports: cirrus.hibernate.test
[WARN] JDBCExceptionReporter - -SQL Error: 1453, SQLState: 72000
[ERROR] JDBCExceptionReporter - -ORA-01453: SET TRANSACTION must be the
first instruction of the transaction
[WARN] JDBCExceptionReporter - -SQL Error: 1453, SQLState: 72000
[ERROR] JDBCExceptionReporter - -ORA-01453: SET TRANSACTION must be the
first instruction of the transaction
F.[WARN] JDBCExceptionReporter - -SQL Error: 1453, SQLState: 72000
[ERROR] JDBCExceptionReporter - -ORA-01453: SET TRANSACTION must be the
first instruction of the transaction
[WARN] JDBCExceptionReporter - -SQL Error: 1453, SQLState: 72000
[ERROR] JDBCExceptionReporter - -ORA-01453: SET TRANSACTION must be the
first instruction of the transaction
Any idea ... thanks in advance!
L.
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
