Hello Everyone,
I am having an issue with trying to connect to the SQL database i have been using for an application. When testing my application within my Eclipse IDE, i have no problems accessing SQL. I am able to use the Class.forname(com.microsoft.sqlserver.jdbc.SQLServerDriver) with no incident. Once i export the application as a .war and drop it into my webapps folder of apache tomcat 6.0 i run into issues. It will throw that NullPointerException on my rs.next() since rs is null because the connection was never made. My research for the last day or two has pointed to a missing .jar file in the common library folder. I have the sqljdbc.jar in that lib and within the WEB-INF/lib folder. I have numerous combinations of each and can not get it to work in my deployment outside of eclipse. Any ideas? Thank you in advance for the help.
P.S.
I read adding it to the classpath may fix it. I thought putting it into the lib folder would do this automatically, but i still try to append the com.microsoft.sqlserver.jdbc onto the bootstrap.jar that is being using when its started up. This also did not work.
I am having an issue with trying to connect to the SQL database i have been using for an application. When testing my application within my Eclipse IDE, i have no problems accessing SQL. I am able to use the Class.forname(com.microsoft.sqlserver.jdbc.SQLServerDriver) with no incident. Once i export the application as a .war and drop it into my webapps folder of apache tomcat 6.0 i run into issues. It will throw that NullPointerException on my rs.next() since rs is null because the connection was never made. My research for the last day or two has pointed to a missing .jar file in the common library folder. I have the sqljdbc.jar in that lib and within the WEB-INF/lib folder. I have numerous combinations of each and can not get it to work in my deployment outside of eclipse. Any ideas? Thank you in advance for the help.
P.S.
I read adding it to the classpath may fix it. I thought putting it into the lib folder would do this automatically, but i still try to append the com.microsoft.sqlserver.jdbc onto the bootstrap.jar that is being using when its started up. This also did not work.