我用myEclipse做了struts+hibernate+spring一个简单的例子,但是一运行就说无法建立连接。
错误 如下:
Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot createJDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL '
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spring'; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL '
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spring我的applicationContext.xml文件如下:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>
<bean id="springbean"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
<value>
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spring
</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>1234</value>
</property>
</bean>
<bean id="sf"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="springbean" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>po/Student.hbm.xml</value>
</list>
</property>
</bean>
<bean name="sel" class="dao.dao">
<property name="factory">
<ref bean="sf" />
</property>
</bean>
<bean name="/spring" class="action.SpringAction">
<property name="i">
<ref bean="sel" />
</property>
</bean>
</beans>
请大家帮忙看啊,郁闷好几天了,也解决不了这个问题!
错误 如下:
Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot createJDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL '
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spring'; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL '
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spring我的applicationContext.xml文件如下:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>
<bean id="springbean"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
<value>
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spring
</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>1234</value>
</property>
</bean>
<bean id="sf"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="springbean" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>po/Student.hbm.xml</value>
</list>
</property>
</bean>
<bean name="sel" class="dao.dao">
<property name="factory">
<ref bean="sf" />
</property>
</bean>
<bean name="/spring" class="action.SpringAction">
<property name="i">
<ref bean="sel" />
</property>
</bean>
</beans>
请大家帮忙看啊,郁闷好几天了,也解决不了这个问题!
解决方案 »
- CAS+SSO 单点登录。。。。求demo和思路,速度啦
- 编译时出现找不到软件包是什么错误?
- jfreechat 曲线图 无值不显示
- 急需tomcatPluginV3
- session混乱的问题??????
- 关于ORACLE 连接数据库的问题???第一次出现这样的错误?????
- 急,为何我的文件用jspsmart上传不了?
- 求jsp中调用随机函数的例子!!!
- 记录列表checkbox用了同一个name,value不同,提交时能否在下一页获得?
- 向大神门求助,用MVC做的婚纱摄影网站,JSP+Struts2+Spring,获取数据库信息时候获取不到
- 请问jsp页面中如何将int 类型转换为float或者double类型?急!在线等!感谢!
- 搞jsp的能算是程序员吗?
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spring</value>
写成一行!!一行啊~~~~~~~
如果写成
<value>
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spring
</value>
这样,就会报错。