RE: Internal driver error (No buffer space available)

Troy,

Have you tried running with a different version of the driver to see if you
get the same error?

cheers
Colin.W

http://as400blog.blogspot.com
 
Extension   5800
Direct dial   0870 429 5800


-----Original Message-----
From: LaPlante, Troy [mailto:Troy.LaPlante@xxxxxxxxxxxxxxxxxxx] 
Sent: 28 January 2005 14:42
To: java400-l@xxxxxxxxxxxx
Subject: Internal driver error (No buffer space available)


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)

-- 
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.