[ess_stegra]

When running or debugging in MyEclipse I can connect to SQLServer 2005 when using my own Tomcat 5.X server. In this scenario I place sqljdbc.jar in $CATALINA_HOME/common/lib. When using the built in MyEclipse Tomcat server I get the error message:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’

I know Tomcat 6.X wants sqljdbc.jar to be in $CATALINA_HOME/lib, but where should I place sqljdbc.jar so that the MyEclipse IDE will deploy sqljdbc.jar correctly when using the built in MyEclipse Tomcat server?

[support-swapna]

ess_stegra,

You can add the sqljdbc.jar file to your project using “Add External JARs”. Right click on your project and from the context menu select Build Path > Configure Build Path. Under the libraries tab click “Add External JARs” and select the jar files you wish to add.

Let me know if that helps.

[ess_stegra]

Hi Swapna,
Unfortunately sqljdbc.jar is already added to the Build Path (I verified this). Something else is apparently going on. Any ideas?
Thanks!

[support-swapna]

ess_stegra,

I could not replicate it at my end.

1) Can you make sure that you are adding the right version of sqljdbc.jar to the buildpath? MyEclipse Tomcat is Tomcat 6.0 version.

2) Also make sure you have added msutil.jar,msbase.jar,mssqlserver.jar to the Build Path.

[Author]

Posts