It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes CachedRowSet execute query problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "CachedRowSet execute query problem" Watch "CachedRowSet execute query problem" New topic

CachedRowSet execute query problem

Kim Kantola
Ranch Hand

Joined: May 17, 2001
Posts: 276
Hi there,
I am having a strange problem with a class that extends the CachedRowSet class. After performing an execute(Connection
connection) the connection is closed. I need to use this connection again later in the code.
After trying to use the con again, I get this exception:
java.sql.SQLException: [TDS Driver]Connection is closed
This connection only gets closed
when I run this code on my machine, but not when I run it on another machine at my office so I think it is probably some kind of
configuration problem.
Anyone ever experience this type of problem?
Thanks for any info.
The code:
public MarkInfo() throws SQLException

public boolean load(Connection con, String id) throws SQLException
// Fetch connection and prepare statement for execution
setString(1, id);
// Execute query
After this execute line, the connection is closed.
Nagaraju Ramanna

Joined: Sep 07, 2003
Posts: 4
Could you please let me know how we can use CachedRowSet? I have an urgent requirement to implement this.
Thanks in advance.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

Sun has a tutorial that covers this topic.
ps -The original post was 3 years ago.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: CachedRowSet execute query problem
It's not a secret anymore!