Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

any known jtds jdbc driver problems?

 
graham king
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I was wondering if anyone has come across any problems using the jtds jdbc driver classes?

i liked the idea of finally updating to a higher level of jdbc code by using jtds. but, i don't like not knowing its performance capabilities nor it's overall behavior. on my dev machine's it seems fine, but, in production there appears to be a problem; one application server is locking up we don't have the slightest clue as to why.

by locking up i mean that the application server looses the ability to talk to the database.

being the newest developer within the bunch, they like to joke and say it's gotta be something that i've done. they only thing i could think of is the switch to the jtds driver classes?

are there known methods on how to trace memory usage?

could someone give me suggestions on ways to debug such a situation.

Thanks,

graham
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
by locking up i mean that the application server looses the ability to talk to the database.

Tell us a little more about what that means. Are you using a connection pool? Connections can go stale (i.e., become unusable), so they should be cycled (closed and reopened) every so often, maybe after 5 minutes of being idle.
 
graham king
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ulf,

We're using SilverStream and connecting to a SQLServer. SilverStream, supports Connection pooling. So, basically we ask for a Connection from the pool and return it back by saying Connection.close();...

That aspect of production is only accessible via SS right now. The problem existed before, but, through basic controls, i.e. restarting the server each week, we've been able to maintain a dependable environment.

We're in the process of moving away from SS and onto JBoss . I develop a maintenance piece. This is on JBoss and connecting to the same SQLServer. I had just recently switched to Jtds about a month ago; basically I liked the convience of some of their methods. Today, I came in and went to check if JBoss was still connecting and did find that one of the cached resources had been closed.

I gotta connection reset by peer. Since I look up the resources myself I can usually detect when a cached connection has been reset and then recache a new one, but, reading the server.log I found that wasn't the case with Jtds.

So, just outta paranoia I have to believe that maybe these classes are causing some new problem. I've removed the net.sourceforge.jtds.jdbcx.JtdsDataSource classes and reverted back to the com.microsoft.jdbc.sqlserver.SQLServerDriver classes just to see if there might possibly be a link.

Graham
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic