ssh+sql整合

[chenshiwen898019024]

<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">


<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="configLocation"
value="classpath:hibernate.cfg.xml">
</property>
</bean></beans>

有什么错误吗

[小老头头]

报什么错啊发个代码上来

[咸哼酒家]

<?xml version="1.0" encoding="UTF-8"?> 你放在第一行了吗？你试下

[猎魔人-不纯]

错误放上来啊，sessionFactory都没注入数据源

[咸哼酒家]

文件格式写好点，就很容易发现错误了 对称的代码多好看，也不要随便换行， 五官对称，身材窈窕的美女看着心情都好，而且有助咱的身心发展！

[咸哼酒家]

亲，spring整合数据库？

[chenshiwen898019024]

引用 1 楼 CEOCAO 的回复:

亲，spring整合数据库？

是的 老是报错

[chenshiwen898019024]

求支援。。。。。。。。

[_水波]

jar包版本....

[chenshiwen898019024]

原来是连oracle 数据库的 现在想用sql2000

[chenshiwen898019024]

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <aop:aspectj-autoproxy proxy-target-class="true" /> <context:component-scan base-package="biz.impl,dao.impl,action,interceptor,util" /> <!-- 加载类路径 下的资源 文件 --> <!-- <context:property-placeholder location="classpath:jdbc.properties"/>--> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" /> <property name="url" value="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=csw" /> <property name="username" value="sa" /> <property name="password" value="123" /> <!-- 连接池启动时的初始值 --> <property name="initialSize" value="1" /> <!-- 连接池的最大值 --> <property name="maxActive" value="500" /> <!-- 最大空闲值.当经过一个高峰时间后，连接池可以慢慢将已经用不到的连接慢慢释放一部分，一直减少到maxIdle为止 --> <property name="maxIdle" value="2" /> <!-- 最小空闲值.当空闲的连接数少于阀值时，连接池就会预申请一些连接，以避免洪峰来时再申请而造成的性能开销 --> <property name="minIdle" value="1" /> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean" p:dataSource-ref="dataSource" p:configLocation="classpath:hibernate.cfg.xml"/> <!-- 配置spring的事务 --> <bean id="txManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory"/> </bean> <!-- 指定实现事务的注解 --> <tx:annotation-driven transaction-manager="txManager"/> </beans>

[chenshiwen898019024]

引用 4 楼 u013230942 的回复:

jar包版本....

[chenshiwen898019024]

[OhSunshineJava]

错误呢？？？

[chenshiwen898019024]

引用 12 楼 u010497606 的回复:

错误呢？？？

驱动加载成功！ java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]ORDER BY 子句所标识的第 1 个 SELECT 项包含了一个变量，该变量位于标识列位置的表达式中。只有排序依据表达式引用的是列名时，才允许在该表达式中使用变量。 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source) at util.DButil.update1(DButil.java:101) at daoimpl.TysbDaoImpl.order(TysbDaoImpl.java:86) at test.Test2.main(Test2.java:40) java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]ORDER BY 子句所标识的第 1 个 SELECT 项包含了一个变量，该变量位于标识列位置的表达式中。只有排序依据表达式引用的是列名时，才允许在该表达式中使用变量。 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source) at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source) at util.DButil.update1(DButil.java:101) at daoimpl.TysbDaoImpl.order(TysbDaoImpl.java:86) at test.Test2.main(Test2.java:43) 连接成功！ sql语句：select * from tysb order by ?ssdfdsg:false 连接成功！ sql语句：select * from tysb order by ? 排序失败！

[yanggang832]

select * from(select * from tysb order by ?) sdasd

[chenshiwen898019024]