Hi Thomas,
did you tried
eager-release=false
batchMode=false
regards,
Armin
----- Original Message -----
From: "Thomas Phan" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 12, 2003 8:08 PM
Subject: OJB 0.9.9 and Oracle 817 always rollback
> Hi,
>
> I couldn't get OJB to work with Oracle, while connecting to Oracle
thur a
> raw JDBC should work. Did anyone encounter this problem? Am I
configured OJB
> to generate Oracle queries correctly? I've an UTF-8 instance, and set
> NLS_LANG=.UTF8, and most of my database's tables are empty (contain no
row)
>
> My application works fine with both MSSQL and MySQL by changing the
driver,
> and the xmls, but not Oracle!
>
> Thanks
>
> Here's what I got:
>
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO:
Create
> new connection
> pool:[EMAIL PROTECTED]
> jcd-alias=default
> default-connection=true
> dbms=Oracle
> jdbc-level=1.0
> driver=oracle.jdbc.driver.OracleDriver
> protocol=jdbc
> sub-protocol=oracle
> db-alias=thin:@localhost:1521:sid
> user=esf
> password=*****
> eager-release=true
> ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1,
maxActive=21,
> maxWait=5000, removeAbandoned=false, numTestsPerEvictionRun=10,
> testWhileIdle=false, minEvictableIdleTimeMillis=600000,
testOnReturn=false,
> logAbandoned=false, removeAbandonedTimeout=300,
> timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
> batchMode=true
>
>
[EMAIL PROTECTED]
84f[
> sequenceManagerClass=class
> org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
> Properties={grabSize=20}
> ]
> ]
> [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO:
Rollback was
> called, do rollback on current connection
> [EMAIL PROTECTED]
> [org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: Io
> exception: Bad file descriptor
> java.sql.SQLException: Io exception: Bad file descriptor
> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
> at
> oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:445)
> at
> oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:460)
> at
>
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatemen
t.ja
> va:185)
> at
>
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatemen
t.ja
> va:168)
> at
>
oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnec
tion
> .java:614)
> at
>
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.ja
va:4
> 92)
> at
>
org.apache.ojb.broker.util.batch.BatchConnection.prepareStatement(Unknow
n
> Source)
> at
>
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatemen
t(Un
> known Source)
> at
>
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt
(Unk
> nown Source)
> at
>
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(
Unkn
> own Source)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
> Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
> Source)
> at
> org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Unknown
> Source)
> at
>
org.apache.ojb.broker.singlevm.ReportRsIteratorFactoryImpl.createRsItera
tor(
> Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu
ery(
> Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryItera
torF
> romQuery(Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryItera
torB
> yQuery(Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getReportQuer
yIte
> ratorByQuery(Unknown Source)
> at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown
Source)
> at
> com.entersys.util.DAOHelper.getCollectionByQuery(DAOHelper.java:133)
> at
> com.entersys.util.DAOHelper.getIteratorByQuery(DAOHelper.java:139)
> at
>
com.entersys.escds.util.SecurityUtils.isUserInRole(SecurityUtils.java:36
)
> at
>
com.entersys.escds.util.SecurityUtils.isUserInRole(SecurityUtils.java:45
)
> at
>
com.entersys.escds.services.DAOSoapBindingImpl.findLookups(DAOSoapBindin
gImp
> l.java:329)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java
:383
> )
> at
>
org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.ja
va:2
> 91)
> at
>
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:330
)
> at
>
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.j
ava:
> 71)
> at
org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
> at
> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:473)
> at
org.apache.axis.server.AxisServer.invoke(AxisServer.java:322)
> at
>
org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at
>
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.j
ava:
> 339)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:371)
> at
>
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:613)
> at org.mortbay.http.HttpContext.handle(HttpContext.java:1387)
> at org.mortbay.http.HttpContext.handle(HttpContext.java:1326)
> at org.mortbay.http.HttpServer.service(HttpServer.java:757)
> at
org.mortbay.http.HttpConnection.service(HttpConnection.java:741)
> at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:914)
> at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:756)
> at
>
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:151
)
> at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:287)
> at
org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:715)
> at java.lang.Thread.run(Thread.java:484)
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR:
> PersistenceBrokerException during the execution of the query: Io
exception:
> Bad file descriptor
> Io exception: Bad file descriptor
> java.sql.SQLException: Io exception: Bad file descriptor
> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
> at
> oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:445)
> at
> oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:460)
> at
>
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatemen
t.ja
> va:185)
> at
>
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatemen
t.ja
> va:168)
> at
>
oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnec
tion
> .java:614)
> at
>
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.ja
va:4
> 92)
> at
>
org.apache.ojb.broker.util.batch.BatchConnection.prepareStatement(Unknow
n
> Source)
> at
>
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatemen
t(Un
> known Source)
> at
>
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt
(Unk
> nown Source)
> at
>
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(
Unkn
> own Source)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
> Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
> Source)
> at
> org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Unknown
> Source)
> at
>
org.apache.ojb.broker.singlevm.ReportRsIteratorFactoryImpl.createRsItera
tor(
> Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu
ery(
> Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryItera
torF
> romQuery(Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryItera
torB
> yQuery(Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getReportQuer
yIte
> ratorByQuery(Unknown Source)
> at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown
Source)
> at
> com.entersys.util.DAOHelper.getCollectionByQuery(DAOHelper.java:133)
> at
> com.entersys.util.DAOHelper.getIteratorByQuery(DAOHelper.java:139)
> at
>
com.entersys.escds.util.SecurityUtils.isUserInRole(SecurityUtils.java:36
)
> at
>
com.entersys.escds.util.SecurityUtils.isUserInRole(SecurityUtils.java:45
)
> at
>
com.entersys.escds.services.DAOSoapBindingImpl.findLookups(DAOSoapBindin
gImp
> l.java:329)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java
:383
> )
> at
>
org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.ja
va:2
> 91)
> at
>
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:330
)
> at
>
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.j
ava:
> 71)
> at
org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
> at
> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:473)
> at
org.apache.axis.server.AxisServer.invoke(AxisServer.java:322)
> at
>
org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at
>
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.j
ava:
> 339)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:371)
> at
>
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:613)
> at org.mortbay.http.HttpContext.handle(HttpContext.java:1387)
> at org.mortbay.http.HttpContext.handle(HttpContext.java:1326)
> at org.mortbay.http.HttpServer.service(HttpServer.java:757)
> at
org.mortbay.http.HttpConnection.service(HttpConnection.java:741)
> at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:914)
> at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:756)
> at
>
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:151
)
> at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:287)
> at
org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:715)
> at java.lang.Thread.run(Thread.java:484)
> rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: Io
> exception: Bad file descriptor
> at
>
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt
(Unk
> nown Source)
> at
>
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(
Unkn
> own Source)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
> Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
> Source)
> at
> org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Unknown
> Source)
> at
>
org.apache.ojb.broker.singlevm.ReportRsIteratorFactoryImpl.createRsItera
tor(
> Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu
ery(
> Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryItera
torF
> romQuery(Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryItera
torB
> yQuery(Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getReportQuer
yIte
> ratorByQuery(Unknown Source)
> at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown
Source)
> at
> com.entersys.util.DAOHelper.getCollectionByQuery(DAOHelper.java:133)
> at
> com.entersys.util.DAOHelper.getIteratorByQuery(DAOHelper.java:139)
> at
>
com.entersys.escds.util.SecurityUtils.isUserInRole(SecurityUtils.java:36
)
> at
>
com.entersys.escds.util.SecurityUtils.isUserInRole(SecurityUtils.java:45
)
> at
>
com.entersys.escds.services.DAOSoapBindingImpl.findLookups(DAOSoapBindin
gImp
> l.java:329)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java
:383
> )
> at
>
org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.ja
va:2
> 91)
> at
>
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:330
)
> at
>
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.j
ava:
> 71)
> at
org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
> at
> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:473)
> at
org.apache.axis.server.AxisServer.invoke(AxisServer.java:322)
> at
>
org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at
>
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.j
ava:
> 339)
> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:371)
> at
>
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:613)
> at org.mortbay.http.HttpContext.handle(HttpContext.java:1387)
> at org.mortbay.http.HttpContext.handle(HttpContext.java:1326)
> at org.mortbay.http.HttpServer.service(HttpServer.java:757)
> at
org.mortbay.http.HttpConnection.service(HttpConnection.java:741)
> at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:914)
> at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:756)
> at
>
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:151
)
> at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:287)
> at
org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:715)
> at java.lang.Thread.run(Thread.java:484)
> [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO:
Rollback was
> called, do rollback on current connection
> [EMAIL PROTECTED]
> [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] ERROR:
Rollback on
> the underlying connection failed
> Io exception: Bad file descriptor
> java.sql.SQLException: Io exception: Bad file descriptor
> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
> at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
> at
>
oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:889)
> at
org.apache.ojb.broker.util.batch.BatchConnection.rollback(Unknown
> Source)
> at
>
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localRollback(Un
know
> n Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.abortTransaction(Un
know
> n Source)
> at
> org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.close(Unknown
Source)
> at
> org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.finalize(Unknown
> Source)
> at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
> at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:86)
> at java.lang.ref.Finalizer.access$100(Finalizer.java:17)
> at
java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:163)
>
> Thomas
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
