Struts, Connection Pool & DBCP

[Douglas Reames <do...@rmsfinance.com>]

I get the following exception ( "java.sql.SQLException: Already closed." )
when I attempt to execute an INSERT. All other sql transaction types work: 
Select, Update, and Delete. Why would the Insert be different? NOTE also 
that I can successfully execute the Insert with a Jedit plug-in client 
immediately after the failure.

insert into employees values ("dilbert", "james", "2", "dilbert", "789456", 
"dil@rms.com", "4");
java.sql.SQLException: Already closed.
at 
org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:110)
at com.wiley.AddEmployeeAction.insertUser(AddEmployeeAction.java:77)
at com.wiley.AddEmployeeAction.perform(AddEmployeeAction.java:119)
at org.apache.struts.action.Action.execute(Action.java:401)
at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at ...

Regards,
Douglas Reames


---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org