Java Database Connectivity (JDBC)

java.sql.SQLException: Closed Connection: next

Here's the JDBC SELECT code:

Class.forName(driver);
con = DriverManager.getConnection(url, user, password);
stmt = con.createStatement();

rs = stmt.executeQuery(select_query);

while(rs.next()) /*Exception occurs on this line! */
{
....
}

Here's what I know:

I can connect to the instance using TORA ok.

The SQL query returns rows from TORA.

I believe the connections are ok because if I purposely mess up the syntax, I get back ORA-errors.

I can execute an INSERT statement ok from a servlet.

I'm using the classes12.zip drivers from the oracle jdbc installation directory.

I'm using the default JDK in WSAD 5.1

Thank you all for helping!

Ryan
rreynoldsx@bellsouth.net