• Post Reply Bookmark Topic Watch Topic
  • New Topic

Object has been closed

 
Celso Pereira
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a problem in my application, I use JBoss with MSSQL 2K and sometimes I have the Exception: java.sql.SQLException: Object has been closed.

How can I solve this problem?

But if I use JBoss with Oracle9i it doesn't happen.

I notice that this Exception is throwing when the query return very much data.

Anyone know how can I solve?

sorry about my poor English.
Celso
[ September 01, 2005: Message edited by: Celso Pereira ]
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36007
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Celso,
In all likelyhood, the connection/statement/resultset is timing out. Compare your database settings to see if one is longer than the other.

Welcome to JavaRanch! [Your English is very good.]
 
Celso Pereira
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jeanne. I'll try to do this.
 
Celso Pereira
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I tried to find connection time-out in SQL Server 2000, but I didn't find it.

Anybody knows where can I set the time-out of my connections?

Thanks, Celso
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!