Patti Steiner

Greenhorn
+ Follow
since Oct 28, 2003
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Patti Steiner

Jamie,
Thank you for the additional information. I'm new to using java for database connections and everything you said was really helpful. It's funny you mentioned that I shouldn't return a ResultSet from a method -- I was originally doing that but figured out pretty quickly that it was a problem. Thanks again.
Avi,
Just to follow-up - deregistering the drivers wasn't closing the connection. A CON.close() fixed my problem. Thank you so much.
Thank you for your quick response. I am calling the close() methods in my finally block -- it's just that my finally block calls a method of my data access class to clean everything up. But I wasn't calling a close() on the connection object (what a goober!!) and I'm sure that's the problem. Before I can confirm I have to figure out how to clear the Oracle processes that are still hung a day later. Good grief. Anyway, thank you very very much.
Hi, I have an application that pulls Oracle data onto a web form. In our test environment that Oracle db only allows 38 processes. I'm finding that after an hour or so of testing I receive the error above which seems to imply that I'm not completely closing the connection ... but I think I am closing everything...
My data access class has a constructor that opens a db connection and statement object. And my finalize calls a method of the data access class that closes everything up. I've printed log statements that show that the statement and resultSet objects are closed when all is done and that the driver is deregistered. Does anybody know what would cause this error?
Here's an excerpt from my constructor (DRV, CON and ST have class scope):
String url = "jdbc racle ci:@myDBName";
String driver = "oracle.jdbc.OracleDriver";
Properties p = new Properties();
DRV = (Driver) Class.forName(driver).newInstance();
p.put("user", "xxxxx");
p.put("password", "xxxxx");
CON = DRV.connect(url, p);
ST = CON.createStatement();
and an excerpt from my finalize:
RS.close();
ST.close();
DriverManager.deregisterDriver(DRV);
If anyone can tell me what I'm doing wrong (or help me to better understand what Oracle means by an open process) I would GREATLY appreciate it! Thanks.