Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CachedRowSet execute query problem

 
Kim Kantola
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
{
setCommand(QUERY);
}

public boolean load(Connection con, String id) throws SQLException
{
// Fetch connection and prepare statement for execution
setString(1, id);
// Execute query
execute(con);
After this execute line, the connection is closed.
 
Nagaraju Ramanna
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Could you please let me know how we can use CachedRowSet? I have an urgent requirement to implement this.
Thanks in advance.
regards
Nagaraju
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34084
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nagaraju,
Sun has a tutorial that covers this topic.
ps -The original post was 3 years ago.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic