Kbase P37386: Problem to release connection from connection pooling after executing SQL INSERT and UPDATE through
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Problem to release connection from connection pooling after executing SQL INSERT and UPDATE through JDBC.
Error during the release of JDBC connection after executing an SQL Update or an SQL Insert.
Error during the release of JDBC connection [command=voi.web.services.createur.ValideOffreSqlCommand] [dsName=jdbc/voi_prog][target=local_sql][message=Error occurred while closing Proxy children"
WebSphere Error: "Error occurred while closing proxy children"
WebSphere WAS 3.5
Progress version prior to 9.1D06
FIX:
In a configuration:
Java Application <--> Framework <--> Websphere <-> Progress DB
The recommended is:
-------------------
Upgrade WebSphere to (at least) WAS 4.0 (preferably WAS 5.0)
Use Progress 9.1D + latest patch.
This offers the multithreaded SQL server.
(In 9.1C and earlier, the one connection/one SQL server rule caused scalability issues.)
More information on the WebSphere error:"Error occurred while closing proxy children":
http://www.jguru.com/forums/view.jsp?EID=1085017
The solution: a ResultSet open when trying to close the connection.