Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS SQL jdbc drivers and JRE compatibility

Andres Delrotti
Ranch Hand
Posts: 178
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


This is the current setup of one of our old applications

JRE: 1.3
Deployed at Websphere 5.1
Database: MS SQL 2000
JDBC drivers used: msbase.jar, mssqlserver.jar, msutil.jar

Now, there is a plan to upgrade the database to MS SQL 2008 R2. We found out that those three jdbc drivers we are using would not work in 2008 R2. The available JDBC driver for MS SQL 2008 R2 would be sqljdbc.jar

The problem is, from the specs we saw that sqljdbc.jar is only compatible for java 5 and higher. With this it seems we need to upgrade our application to at least java 5 and be deployed on a higher version of Websphere
to be able to connect to MS SQL 2008 R2. This approach doesnt seem practical. Do you guys know any other workaround for this?

  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic