Hi, I'd be forever grateful to anyone who could point me in the right direction with this problem..
I'm fairly new to websphere so please be patient.
I'm using Websphere V5 running on an i-series.
I've configured a datasource, mapped an alias for context lookups within
servlets and server singletons. My Servlets all prep their sql statements in their init methods just fine but when they are executed at a later stage (i.e by some user actions) an exception is thrown saying that "The Statement is Closed". since this is running on a new installation of Websphere and I'm the only one using it, I've been able to up the Statement Cache size to 100, and the minimum pool size to 100 so I don't think my problem is lack of connections. The same code runs fine on
JBOSS 3.2 all I've had to change was the datasource context lookup as u may have guessed the application was developed on JBoss and now needs to be moved to Websphere 5.
I'm starting to think I may need a separate connection for each prepared statement and yes I know this is utter madness.
so to finish... help help help please....
By the way the maximum pool size is 300 (its a big machine)..