Connections to IBM DB2 does not die when inactive.

[wellington.jorge]

The company I work for has a client that uses the IBD as DB2 AS400 database and is happening overflow connection pool.

Can you help me?

We use JBoss AS 7.1.0

[wdfink]

What you mean? Could you show a Exception or a pice of code?

[wellington.jorge]

Thanks for you interest.

When try to run some instruction in the system, the following message appears: "IJ000655: No managed connections available ....."

[jamezp]

How do you have the data source setup? I assume you're using jt400. If so make sure you're using the JDBC 4 compliant JAR and you should be able to deploy it.

--

James R. Perkins

[wellington.jorge]

James,

URL Connection: jdbc:as400://IP_ADDRESS/ged; thread used=false; socket timeout=30000; cursor hold=false

Driver: com.ibm.as400.access.AS400JDBCDriver

Thanks.

[jamezp]

Where do you define your configuration? I'm assuming you set up a data source via CLI, the web console or in an *-ds.xml file.

--

James R. Perkins

[wellington.jorge]

James,

my configuration  is in standalone.xml file in datasources.

[fsezoes]

Hi Wellington,

I'm having the same problem. Did you find a way to resolve it?