A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
multiple threads for database
Joined: May 17, 2004
Sep 09, 2005 16:41:00
I changed a process to multiple threads to read data from DB. the original code works fine. I just change main process to multiple threads with DBPool and keep all DB code without change.
after changed to multiple thread, it throws SQLException as
java.sql.SQLException: ORA-01001: invalid cursor
java.sql.SQLException: Closed Statement: next
Any advices for the change for multiple threads DB access?
[ September 09, 2005: Message edited by: Steve Jiang ]
Joined: Sep 29, 2002
Sep 09, 2005 17:52:00
Use only local variables for thread-safety.
SCJP 1.4, SCWCD 1.3, SCBCD 1.3
I agree. Here's the link:
subject: multiple threads for database
help in sql
member variables in servlet
Multiple Java processes when tomcat starts
A lock could not be obtained within the time requested
on FILE attributes (badly need help)
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014