cofactor
asked on
java.lang.UnsupportedClassVersionError
Error:
Caused by: java.lang.UnsupportedClass VersionErr or: Bad version number in .class file (unable to load class com.microsoft.sqlserver.jd bc.SQLServ erDriver)
I am using java 1.5 & sqljdbc.jar to connect to sql server 2005 database
Could you please tell what might have gone wrong ?
Caused by: java.lang.UnsupportedClass
I am using java 1.5 & sqljdbc.jar to connect to sql server 2005 database
Could you please tell what might have gone wrong ?
Check that the Java version of the driver is not > 1.5
ASKER
>>>Check that the Java version of the driver is not > 1.5
How do I do that ? I just have the sqljdbc.jar file only.
Is there any way to check the Java version of this driver ? Please let me know.
How do I do that ? I just have the sqljdbc.jar file only.
Is there any way to check the Java version of this driver ? Please let me know.
ASKER
I see this link from microsoft site..
https://msdn.microsoft.com/en-us/library/ms378422(v=sql.110).aspx
it says sqljdbc.jar does work in jdk 5
So where is the issue ?
Here is the full stacktrace of this issue:
https://msdn.microsoft.com/en-us/library/ms378422(v=sql.110).aspx
it says sqljdbc.jar does work in jdk 5
So where is the issue ?
Here is the full stacktrace of this issue:
Failed to obtain DB connection from data source 'testDS': org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'<br/>
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'testDS': org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver']
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:575)
at org.quartz.impl.jdbcjobstore.JobStoreTX.getTriggerGroupNames(JobStoreTX.java:732)
at org.quartz.core.QuartzScheduler.getTriggerGroupNames(QuartzScheduler.java:1135)
at org.quartz.impl.StdScheduler.getTriggerGroupNames(StdScheduler.java:511)
at com.pwc.cee.pais.app.global.commonutil.QuartzScheduler.cleanUp(QuartzScheduler.java:41)
at com.pwc.cee.pais.app.global.commonutil.QuartzScheduler.run(QuartzScheduler.java:74)
at com.pwc.cee.pais.web.global.servlet.PwcInitServlet.setMailScheduler(PwcInitServlet.java:144)
at com.pwc.cee.pais.web.global.servlet.PwcInitServlet.init(PwcInitServlet.java:44)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3996)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4266)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
* Nested Exception (Underlying Cause) ---------------
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.quartz.utils.PoolingConnectionProvider.getConnection(PoolingConnectionProvider.java:172)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553)
at org.quartz.impl.jdbcjobstore.JobStoreTX.getTriggerGroupNames(JobStoreTX.java:732)
at org.quartz.core.QuartzScheduler.getTriggerGroupNames(QuartzScheduler.java:1135)
at org.quartz.impl.StdScheduler.getTriggerGroupNames(StdScheduler.java:511)
at com.pwc.cee.pais.app.global.commonutil.QuartzScheduler.cleanUp(QuartzScheduler.java:41)
at com.pwc.cee.pais.app.global.commonutil.QuartzScheduler.run(QuartzScheduler.java:74)
at com.pwc.cee.pais.web.global.servlet.PwcInitServlet.setMailScheduler(PwcInitServlet.java:144)
at com.pwc.cee.pais.web.global.servlet.PwcInitServlet.init(PwcInitServlet.java:44)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3996)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4266)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: java.lang.UnsupportedClassVersionError: Bad version number in .class file (unable to load class com.microsoft.sqlserver.jdbc.SQLServerDriver)
at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1964)
at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:933)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1405)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1284)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760)
... 28 more
ASKER
comments please.
To be certain, extract the driver to a temporary directory first
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent
:)