Hi Matthias,

 
> Hi
> I try again to get help from some one. We try to run 
> multiple users (up to 3000) to a webbased prototype that uses OJB and
> runs on Websphere 4.x on z/OS. The Database is DB2.
> Run the tests with one user works. Run the test with more 
> then one (50 or
> 100) we get
> in moste case (48 or 98 users) the following error message:
> method is not valid on a closed logical connection.prepareStatement()
> SQLSTATE=57015 and SQLCODE=-923
> Have some body an idee what the problem can be? 
> Is there some one how is working successfull with Websphere 
> 4.x on z/OS with
> db2 and OJB?
> 
> The problem is only on z/OS. If the Websphere is running on 
> NT (DB2 on z/OS)
> then 50 users works
> with out problems


We are also using a similar setup with an Appserver on WIndows and DB2 on
zOS without problems with a large user base.
We originally planned to run our servlets also on Wepshpere zOS, but we did
not manage to get things running in a reasonable timeframe.

I know that there are several problems with the JDBC driver and also the
pooling JDBC driver on zOS. I assume that you encounter a similar problem. 
Maybe you can try to play around with the JDBC driver settings a bit. Maybe
you can bypass the pooling driver and use the OJB built in pooling directly.

Unfortunately I have no real solution at hand :-(

cu,
Thomas

> 
> Thanks for every hint
> 
> regards
> 
> Matthias Roth
> 
> Bundesamt f�r Informatik und Telekommunikation BIT 
> Office f�d�ral de l'informatique et de la t�l�communication OFIT
> 
> Ufficio federale dell'informatica e della telecomunicazione UFIT   
> Monbijoustrasse 74, CH-3003 Bern
> 
> Tel.        ++41 (0)31 325 84  68 
> Fax        ++41 (0)31 325 97 54
> [EMAIL PROTECTED]
> http://www.bit.admin.ch/
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to