no suitable driver - need urgent help !!! :-(

[vradhik]

Hi, I am using spring 2.5 and hibernate 3.2.1 and JDBC driver: IBM DB2 JDBC 2.0 Type 2, version: 08.02.0009
hibernate settings are available in the trace.

I get the following log trace :


[12/8/08 14:53:48:300 IST] 00000038 Environment I Hibernate 3.2.1
[12/8/08 14:53:48:330 IST] 00000038 Environment I loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=COM.ibm.db2.jdb c.app.DB2Driver, hibernate.cglib.use_reflection_optimizer=false, hibernate.current_session_context_class=thread, hibernate.dialect=org.hibernate.dialect.DB2Dialect , hibernate.query.substitutions=false='N', true='Y', hibernate.jdbc.batch_size=0, hibernate.connection.username=db2admin, hibernate.connection.url=jdbc:db2:tftool, hibernate.connection.password=****, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=true}
[12/8/08 14:53:48:360 IST] 00000038 Environment W Property [hibernate.cglib.use_reflection_optimizer] has been renamed to [hibernate.bytecode.use_reflection_optimizer]; update your properties appropriately
.....
[12/8/08 14:53:49:792 IST] 00000038 DriverManager I using driver: COM.ibm.db2.jdbc.app.DB2Driver at URL: jdbc:db2:tftool
[12/8/08 14:53:49:812 IST] 00000038 DriverManager I connection properties: {user=db2admin, password=****}
[12/8/08 14:53:49:832 IST] 00000038 SettingsFacto W Could not obtain connection metadata
[12/8/08 14:53:49:842 IST] 00000038 SettingsFacto W TRAS0014I: The following exception was logged java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager .java:559)
at java.sql.DriverManager.getConnection(DriverManager .java:158)
at org.hibernate.connection.DriverManagerConnectionPr ovider.getConnection(DriverManagerConnectionProvid er.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(Se ttingsFactory.java:76)
at org.hibernate.cfg.Configuration.buildSettings(Conf iguration.java:2006)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1289)
at com.ibm.testbase.dao.ComponentImpl.load_componentT ypes(ComponentImpl.java:72)
at com.ibm.testbase.model.ComponentModel.getComponent Types(ComponentModel.java:23)
at com.ibm.testbase.controller.LoginController.handle RequestInternal(LoginController.java:98)
at org.springframework.web.servlet.mvc.AbstractContro ller.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter.handle(SimpleControllerHandlerAda pter.java:48)
at org.springframework.web.servlet.DispatcherServlet. doDispatch(DispatcherServlet.java:874)
at org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:808)
at org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:476)
at org.springframework.web.servlet.FrameworkServlet.d oPost(FrameworkServlet.java:441)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrappe r.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest (WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.read y(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCa llback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.reque stComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attem ptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.worke rRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worke r.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:1332)
.
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager .java:559)
at java.sql.DriverManager.getConnection(DriverManager .java:158)
at org.hibernate.connection.DriverManagerConnectionPr ovider.getConnection(DriverManagerConnectionProvid er.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(Se ttingsFactory.java:76)
at org.hibernate.cfg.Configuration.buildSettings(Conf iguration.java:2006)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1289)
at com.ibm.testbase.dao.ComponentImpl.load_componentT ypes(ComponentImpl.java:72)
at com.ibm.testbase.model.ComponentModel.getComponent Types(ComponentModel.java:23)
at com.ibm.testbase.controller.LoginController.handle RequestInternal(LoginController.java:98)
at org.springframework.web.servlet.mvc.AbstractContro ller.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter.handle(SimpleControllerHandlerAda pter.java:48)
at org.springframework.web.servlet.DispatcherServlet. doDispatch(DispatcherServlet.java:874)
at org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:808)
at org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:476)
at org.springframework.web.servlet.FrameworkServlet.d oPost(FrameworkServlet.java:441)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrappe r.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest (WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.read y(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCa llback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.reque stComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attem ptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.worke rRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worke r.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:1332)


Thanks for any help!

[denis.zhdanov]

What kind of help do you expect to get?

The error message is rather clear - 'No suitable driver'. Google is happy to provide you with necessary details about that.

[vradhik]

Sorry if my question is vague.
I do have the right driver, and it is in the class path, and this same setup seems to be working fine in another project in the same workspace in RSA. I am desperately looking for any pointers.
Again, my apologies if this is not the right forum, if that is the case, pls ignore.
Thanks

[Goran]

http://forum.hibernate.org/viewtopic...04 790aea46f7

G

[duffymo]

Sorry if my question is vague.
I do have the right driver, and it is in the class path, and this same setup seems to be working fine in another project in the same workspace in RSA. I am desperately looking for any pointers.
Again, my apologies if this is not the right forum, if that is the case, pls ignore.
Thanks

that message usually means that the url you gave is incorrect. typo, bad syntax - check the URL.

%