Connectivity Problem with DB

[muleal]

Hello All,

I'm working with Jboss 4.0.3 and MS SQL 2000.
I was getting a managedconnection error a lot of times on my system when I was using Jboss 4.0.2. I have updated the to 4.0.3, the connection driver (from jtds-1.0.3.jar to jtds-1.1.jar), the <max-pool-size>200</max-pool-size> and <blocking-timeout-millis>3600000</blocking-timeout-millis>.
I still have the same symptom: Jboss continue to run JSP pages (without database connection) but loses the connection within the database (apparently). I had to restart Jboss to make it works again. The Jboss status window do not show any information about the error.
Does anyone have any idea of what can solve this problem?

Thanks in advance,
Murilo

[itcube.ians]

Hi,

problem is not in driver. U have used the connection object. but not close it that's why its error is comming.
just call the
if(conn != null)
conn.close(); after your business process complet.


thx
itcube.ians