JPA连接SQLSERVER查询报错。

applicationContext.xml
[code="java"]
<?xml version="1.0" encoding="UTF-8"?>
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 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-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">

<bean
    class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />

<!-- 配置Jpa -->
<bean id="entityManagerFactory"
    class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="jpaVendorAdapter">
        <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
            <property name="database" value="MYSQL" />
            <property name="showSql" value="true" />
        </bean>
    </property>

    <!-- 根据实体Bean自动生成表 -->
    <property name="jpaProperties">
        <props>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
        </props>
    </property>
</bean>


<!-- 配置数据源 -->

<bean id="dataSource"
    class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"></property>
    <property name="url"
        value="jdbc:sqlserver://172.16.1.48:1433;instanceName=sql08;databaseName=YXTong_BZ"></property>
    <property name="username" value="sa" />
    <property name="password" value="sa123" />
</bean>

<!-- 配置事务 -->
<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
    <property name="entityManagerFactory" ref="entityManagerFactory" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager" />


[/code]

查询代码:
[code="java"]
Query query = this.entityManager
.createQuery("select p FROM ACase p order by p.id desc");
query.setFirstResult(0);
query.setMaxResults(10);
List list = query.getResultList();
[/code]

输出错误:
[code="java"]
Hibernate: select acase0_.id as id0_, acase0_.addTime as addTime0_, acase0_.caseName as caseName0_ from ACase acase0_ order by acase0_.id desc limit ?
Dao------------getACaseByHqlAppendParameter---------org.hibernate.exception.SQLGrammarException: could not execute query
Service------------getACaseByHqlAppendParameter---------Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Transaction marked as rollbackOnly
2013-9-3 17:15:20 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet default threw exception
javax.persistence.RollbackException: Transaction marked as rollbackOnly
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:51)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:456)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:709)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:359)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy12.getACaseByHqlAppendParameter(Unknown Source)
at com.ct.yxtbz.service.impl.ACaseService.getACaseByHqlAppendParameter(ACaseService.java:185)
at com.ct.yxtbz.web.action.ACaseAction.acaseList(ACaseAction.java:99)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
[/code]

不知道是配置错了。。还是怎么了。。。
若是查询时不为Query对象加setFirstResult和setMaxResults的话,就不会报错。能查出数据。

1个回答

下面这段有问题,database属性为SQL_SERVER
[quote]









[/quote]

hecheng_job
hecheng_job MSSQL SQLSERVER都试了。。。原来是这么个玩意……
6 年多之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问