Hi Armin,
I still get the exception after changing the conf to:
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="Oracle"
jdbc-level="1.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle"
dbalias="thin:@localhost:1521:es"
username="esf"
password="esf"
eager-release="false"
batch-mode="false"
useAutoCommit="0"
ignoreAutoCommitExceptions="true"
>
<connection-pool
maxActive="21"
validationQuery="" />
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
<attribute attribute-name="grabSize" attribute-value="20"/>
</sequence-manager>
</jdbc-connection-descriptor>
[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:es
user=esf
password=*****
eager-release=false
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=false
[EMAIL PROTECTED]
sequenceManagerClass=class
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
Properties={grabSize=20}
]
]
[2003-03-13 09:23:06,755 LV: INFO CL:jcrontab]
org.jcrontab.data.DataNotFoundException: No CrontabEntries available
[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
Thomas
----- Original Message -----
From: "Armin Waibel" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 3:51 AM
Subject: Re: OJB 0.9.9 and Oracle 817 always rollback
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
