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]
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>(OraclePreparedStatement.ja
va:185)
at
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.ja
va:168)
at
oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection
.java:614)
at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:4
92)
at
org.apache.ojb.broker.util.batch.BatchConnection.prepareStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(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.createRsIterator(
Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorF
romQuery(Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorB
yQuery(Unknown Source)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getReportQueryIte
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(DAOSoapBindingImp
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.java:2
91)
at
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:330)
at
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:
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.java:
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>(OraclePreparedStatement.ja
va:185)
at
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.ja
va:168)
at
oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection
.java:614)
at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:4
92)
at
org.apache.ojb.broker.util.batch.BatchConnection.prepareStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(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.createRsIterator(
Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorF
romQuery(Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorB
yQuery(Unknown Source)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getReportQueryIte
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(DAOSoapBindingImp
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.java:2
91)
at
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:330)
at
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:
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.java:
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.createRsIterator(
Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorF
romQuery(Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorB
yQuery(Unknown Source)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getReportQueryIte
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(DAOSoapBindingImp
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.java:2
91)
at
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:330)
at
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:
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.java:
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(Unknow
n Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.abortTransaction(Unknow
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]
