This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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
Marshal
Posts: 35279
384
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic