当前页面: 开发资料首页 → J2EE 专题 → spring+hibernate连接数据库问题

spring+hibernate连接数据库问题

摘要: spring+hibernate连接数据库问题

8797 [Main Thread] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [
jdbc:jtds:sqlserver://127.0.0.1:1433/test
]
8797 [Main Thread] DEBUG org.hibernate.util.JDBCExceptionReporter - SQL Exception
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;Ljava.lang.ClassLoader;)Ljava.sql.Connection;(Unknown Source)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;)Ljava.sql.Connection;(Unknown Source)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(Ljava.lang.String;Ljava.util.Properties;)Ljava.sql.Connection;(DriverManagerDataSource.java:290)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(Ljava.lang.String;Ljava.lang.String;)Ljava.sql.Connection;(DriverManagerDataSource.java:276)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager()Ljava.sql.Connection;(DriverManagerDataSource.java:258)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection()Ljava.sql.Connection;(DriverManagerDataSource.java:240)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection()Ljava.sql.Connection;(LocalDataSourceConnectionProvider.java:80)
at org.hibernate.cfg.SettingsFactory.buildSettings(Ljava.util.Properties;)Lorg.hibernate.cfg.Settings;(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings()Lorg.hibernate.cfg.Settings;(Configuration.java:1463)
at org.hibernate.cfg.Configuration.buildSessionFactory()Lorg.hibernate.SessionFactory;(Configuration.java:1004)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(Lorg.hibernate.cfg.Configuration;)Lorg.hibernate.SessionFactory;(LocalSessionFactoryBean.java:767)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet()V(LocalSessionFactoryBean.java:693)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(Ljava.lang.String;Ljava.lang.Object;Lorg.springframework.beans.factory.support.RootBeanDefinition;)V(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(Ljava.lang.String;Lorg.springframework.beans.factory.support.RootBeanDefinition;[Ljava.lang.Object;)Ljava.lang.Object;(AbstractAutowireCapableBeanFactory.java:348)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Ljava.lang.String;Ljava.lang.Class;[Ljava.lang.Object;)Ljava.lang.Object;(AbstractBeanFactory.java:226)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Ljava.lang.String;)Ljava.lang.Object;(AbstractBeanFactory.java:147)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons()V(DefaultListableBeanFactory.java:269)
at org.springframework.context.support.AbstractApplicationContext.refresh()V(AbstractApplicationContext.java:317)
at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh()V(AbstractRefreshableWebApplicationContext.java:134)
at org.springframework.web.struts.ContextLoaderPlugIn.createWebApplicationContext(Lorg.springframework.web.context.WebApplicationContext;)Lorg.springframework.web.context.WebApplicationContext;(ContextLoaderPlugIn.java:352)
at org.springframework.web.struts.ContextLoaderPlugIn.initWebApplicationContext()Lorg.springframework.web.context.WebApplicationContext;(ContextLoaderPlugIn.java:295)
at org.springframework.web.struts.ContextLoaderPlugIn.init(Lorg.apache.struts.action.ActionServlet;Lorg.apache.struts.config.ModuleConfig;)V(ContextLoaderPlugIn.java:224)
at org.apache.struts.action.ActionServlet.initModulePlugIns(Lorg.apache.struts.config.ModuleConfig;)V(ActionServlet.java:869)
at org.apache.struts.action.ActionServlet.init()V(ActionServlet.java:336)
at javax.servlet.GenericServlet.init(Ljavax.servlet.ServletConfig;)V(GenericServlet.java:258)
at weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run()Ljava.lang.Object;(ServletStubImpl.java:1028)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Lweblogic.security.subject.AbstractSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Lweblogic.security.acl.internal.AuthenticatedSubject;Lweblogic.security.acl.internal.AuthenticatedSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(SecurityManager.java:121)
at weblogic.servlet.internal.ServletStubImpl.createServlet()Ljavax.servlet.Servlet;(ServletStubImpl.java:904)
at weblogic.servlet.internal.ServletStubImpl.createInstances()V(ServletStubImpl.java:883)
at weblogic.servlet.internal.ServletStubImpl.prepareServlet(Lweblogic.servlet.internal.RequestCallback;)V(ServletStubImpl.java:822)
at weblogic.servlet.internal.WebAppServletContext.preloadServlet(Ljava.lang.String;)V(WebAppServletContext.java:3333)
8797 [Main Thread] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08001

---

没找到驱动啊，驱动位置没放对吧

---

驱动是找到了，开始没有驱动时是net.sourceforge.jtds.jdbc.Driver,ClassNotFound.
现在的错误是驱动找到了，但是不知道为什么会出现这个错误。

---

应该是驱动的问题，你看看你驱动版本正不正确

---