We have a Java application running on a Weblogic server using the
com.ibm.as400.access.AS400JDBCDriver from the JT400 toolkit.  After the
program has been running for a couple of weeks, we receive the following
SQLException.  I can see that the connections are being closed in the
JDBC log.  What are the other causes of this error?



java.sql.SQLException: Internal driver error.(No buffer space available
(maximum connections reached?): recv failed)
        at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:336)
        at
com.ibm.as400.access.AS400JDBCConnection.send(AS400JDBCConnection.java:1
672)
        at
com.ibm.as400.access.AS400JDBCConnection.send(AS400JDBCConnection.java:1
583)
        at
com.ibm.as400.access.AS400JDBCStatement.syncRPB(AS400JDBCStatement.java:
2152)
        at
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement
.java:979)
        at
com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:
1162)
        at
weblogic.jdbc.common.internal.ConnectionEnv.test(ConnectionEnv.java:665)
        at
weblogic.jdbc.common.internal.ConnectionEnv.test(ConnectionEnv.java:386)
        at
weblogic.common.resourcepool.ResourcePoolImpl.checkResource(ResourcePool
Impl.java:1454)
        at
weblogic.common.resourcepool.ResourcePoolImpl.checkAndReturnResource(Res
ourcePoolImpl.java:1350)
        at
weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePo
olImpl.java:281)
        at
weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePo
olImpl.java:252)
        at
weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java
:428)
        at
weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPo
olManager.java:78)
        at
weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPo
olManager.java:85)
        at weblogic.jdbc.pool.Driver.connect(Driver.java:145)
        at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:444)
        at weblogic.jdbc.jts.Driver.connect(Driver.java:138)
        at
weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.
java:305)
        at
com.harley_davidson.pave.submit_queue.data_access.DataSourceManager.open
Connection(DataSourceManager.java:119)
        at
com.harley_davidson.pave.submit_queue.data_access.DataSourceManager.hand
leTransaction(DataSourceManager.java:32)
        at
com.harley_davidson.pave.submit_queue.data_access.QueueDataAccess.prepar
eUpdateState(QueueDataAccess.java:83)
        at
com.harley_davidson.pave.submit_queue.data_access.QueueDataAccess.prepar
eQueueRequestForRetry(QueueDataAccess.java:113)
        at
com.harley_davidson.pave.submit_queue.RequestDispatcher.prepareRequestFo
rProcessing(RequestDispatcher.java:138)
        at
com.harley_davidson.pave.submit_queue.RequestDispatcher.dispatchRequests
(RequestDispatcher.java:88)
        at
com.harley_davidson.pave.submit_queue.QueueManager.dispatchRetryRequests
WhileQueueNotEmpty(QueueManager.java:256)
        at
com.harley_davidson.pave.submit_queue.QueueManager.scanQueueUntilSuspend
ed(QueueManager.java:244)
        at
com.harley_davidson.pave.submit_queue.QueueManager.access$100(QueueManag
er.java:25)
        at
com.harley_davidson.pave.submit_queue.QueueManager$1.run(QueueManager.ja
va:73)
        at java.lang.Thread.run(Thread.java:536)
SQLException: SQLState(HY000) vendor code(-99999)


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.