View Single Post
  #3  
Old 08-25-2010, 01:23 PM
erlendfg erlendfg is offline
Junior Member
 
Join Date: Aug 2010
Location: Oslo, Norway
Posts: 3
Default

Yes, it seems that they are opened once and not reused. The number of connections are growing fast and suddenly we get an exception such as: "Closing dangling connections. All connections must have a close() in a finally block".

I'm just posting the log from Resin 4.0.9 Professional. I do have logs for 3.0.26 as well. The first part of the log is from the first request. Then I'm doing a lot of other requests which is not shown in the log - just for showing that the connections are not reused. So take a look at the end, where all the connections are released at max-idle-time:

Code:
[2010-08-25 15:05:57.590] {main} ProResin[id=pay-2] started in 4383ms
[2010-08-25 15:06:09.201] {server://127.0.0.1:6861-2} jdbc/epay.0:getMetaData() -> oracle.jdbc.driver.OracleDatabaseMetaData
[2010-08-25 15:06:09.241] {server://127.0.0.1:6861-2} jdbc/epay.0:clearWarnings()
[2010-08-25 15:06:09.976] {server://127.0.0.1:6861-2} jdbc/epay.0:getAutoCommit() -> true
[2010-08-25 15:06:09.976] {server://127.0.0.1:6861-2} jdbc/epay.0:setAutoCommit(false)
[2010-08-25 15:06:10.143] {server://127.0.0.1:6861-2} jdbc/epay.0.0:prepareStatement(select country0_.COUNTRY_CODE as col_0_0_ from COUNTRY country0_ where country0_.COUNTRY_CODE=?)
[2010-08-25 15:06:10.258] {server://127.0.0.1:6861-2} jdbc/epay.0.0:setString(1,NO)
[2010-08-25 15:06:10.258] {server://127.0.0.1:6861-2} jdbc/epay.0.0:executeQuery(select country0_.COUNTRY_CODE as col_0_0_ from COUNTRY country0_ where country0_.COUNTRY_CODE=?)
[2010-08-25 15:06:10.272] {server://127.0.0.1:6861-2} jdbc/epay.0.1:prepareStatement(select country0_.COUNTRY_CODE as COUNTRY1_7_0_, country0_.NAME as NAME7_0_ from COUNTRY country0_ where country0_.COUNTRY_CODE=?)
[2010-08-25 15:06:10.272] {server://127.0.0.1:6861-2} jdbc/epay.0.1:setString(1,NO)
[2010-08-25 15:06:10.272] {server://127.0.0.1:6861-2} jdbc/epay.0.1:executeQuery(select country0_.COUNTRY_CODE as COUNTRY1_7_0_, country0_.NAME as NAME7_0_ from COUNTRY country0_ where country0_.COUNTRY_CODE=?)
[2010-08-25 15:06:10.278] {server://127.0.0.1:6861-2} jdbc/epay.0.1:getMaxRows() -> 0
[2010-08-25 15:06:10.278] {server://127.0.0.1:6861-2} jdbc/epay.0.1:getQueryTimeout() -> 0
[2010-08-25 15:06:10.278] {server://127.0.0.1:6861-2} jdbc/epay.0.1:clearParameters()
[2010-08-25 15:06:10.278] {server://127.0.0.1:6861-2} jdbc/epay.0.1:clearParameters()
[2010-08-25 15:06:10.278] {server://127.0.0.1:6861-2} jdbc/epay.0:isClosed() -> false
[2010-08-25 15:06:10.278] {server://127.0.0.1:6861-2} jdbc/epay.0:getAutoCommit() -> false
[2010-08-25 15:06:10.281] {server://127.0.0.1:6861-2} jdbc/epay.0.0:getMaxRows() -> 0
[2010-08-25 15:06:10.281] {server://127.0.0.1:6861-2} jdbc/epay.0.0:getQueryTimeout() -> 0
[2010-08-25 15:06:10.281] {server://127.0.0.1:6861-2} jdbc/epay.0.0:clearParameters()
[2010-08-25 15:06:10.281] {server://127.0.0.1:6861-2} jdbc/epay.0.0:clearParameters()
[2010-08-25 15:06:10.282] {server://127.0.0.1:6861-2} jdbc/epay.0:isClosed() -> false
[2010-08-25 15:06:10.282] {server://127.0.0.1:6861-2} jdbc/epay.0:getAutoCommit() -> false
[2010-08-25 15:06:10.616] {server://127.0.0.1:6861-2} jdbc/epay.0:isClosed() -> false
[2010-08-25 15:06:10.616] {server://127.0.0.1:6861-2} jdbc/epay.0:getAutoCommit() -> false
[2010-08-25 15:06:10.616] {server://127.0.0.1:6861-2} jdbc/epay.0:commit()
[2010-08-25 15:06:10.617] {server://127.0.0.1:6861-2} jdbc/epay.0:setAutoCommit(true)
[2010-08-25 15:06:10.617] {server://127.0.0.1:6861-2} jdbc/epay.0:isClosed() -> false
[2010-08-25 15:06:10.619] {server://127.0.0.1:6861-2} jdbc/epay.0:getWarnings() -> null
[2010-08-25 15:06:10.619] {server://127.0.0.1:6861-2} jdbc/epay.0:clearWarnings()
[2010-08-25 15:06:10.619] {server://127.0.0.1:6861-2} jdbc/epay.0:clearWarnings()
[2010-08-25 15:06:10.623] {server://127.0.0.1:6861-2} jdbc/epay.0:getAutoCommit() -> true
[2010-08-25 15:06:10.623] {server://127.0.0.1:6861-2} jdbc/epay.0:setAutoCommit(false)
[2010-08-25 15:06:10.624] {server://127.0.0.1:6861-2} jdbc/epay.0:isClosed() -> false
[2010-08-25 15:06:10.624] {server://127.0.0.1:6861-2} jdbc/epay.0:getWarnings() -> null
[2010-08-25 15:06:10.624] {server://127.0.0.1:6861-2} jdbc/epay.0:clearWarnings()
[2010-08-25 15:06:10.624] {server://127.0.0.1:6861-2} jdbc/epay.0:rollback()
[2010-08-25 15:06:10.625] {server://127.0.0.1:6861-2} jdbc/epay.0:setAutoCommit(true)
[2010-08-25 15:06:10.625] {server://127.0.0.1:6861-2} jdbc/epay.0:clearWarnings()
[2010-08-25 15:12:22.989] {server://127.0.0.1:6861-20} jdbc/epay.1.18:close()
[2010-08-25 15:12:22.990] {server://127.0.0.1:6861-20} jdbc/epay.1.9:close()
[2010-08-25 15:12:22.990] {server://127.0.0.1:6861-20} jdbc/epay.1.8:close()
[2010-08-25 15:12:22.990] {server://127.0.0.1:6861-20} jdbc/epay.1.4:close()
[2010-08-25 15:12:22.990] {server://127.0.0.1:6861-20} jdbc/epay.1.10:close()
[2010-08-25 15:12:22.990] {server://127.0.0.1:6861-20} jdbc/epay.1.7:close()
[2010-08-25 15:12:22.990] {server://127.0.0.1:6861-20} jdbc/epay.1.6:close()
[2010-08-25 15:12:22.990] {server://127.0.0.1:6861-20} jdbc/epay.1.5:close()
[2010-08-25 15:12:22.990] {server://127.0.0.1:6861-20} jdbc/epay.1.20:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.19:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.17:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.16:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.15:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.14:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.13:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.12:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.11:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.3:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.2:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.1:close()
[2010-08-25 15:12:22.992] {server://127.0.0.1:6861-20} jdbc/epay.1.0:close()
[/CODE]
Reply With Quote