DB2查询问题

[此贴子已经被作者于2007-1-11 20:28:44编辑过]

Junit 测试错误



org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not inspect JDBC autocommit mode; uncategorized SQLException for SQL [???]; SQL state [null]; error code [-99999]; bug check; nested exception is com.ibm.db2.jcc.b.SQLException: bug check
com.ibm.db2.jcc.b.SQLException: bug check
at com.ibm.db2.jcc.b.o.a(o.java:1308)
at com.ibm.db2.jcc.b.o.k(o.java:410)
at com.ibm.db2.jcc.b.o.K(o.java:968)
at com.ibm.db2.jcc.b.cg.getString(cg.java:543)
at com.ibm.db2.jcc.b.cl.getMessage(cl.java:228)
at com.ibm.db2.jcc.b.SQLException.getMessage(SQLException.java:177)
at java.lang.Throwable.getLocalizedMessage(Unknown Source)
at java.lang.Throwable.toString(Unknown Source)
at org.apache.log4j.spi.VectorWriter.println(ThrowableInformation.java:97)
at java.lang.Throwable.printStackTrace(Unknown Source)
at org.apache.log4j.spi.ThrowableInformation.getThrowableStrRep(ThrowableInformation.java:59)
at org.apache.log4j.spi.LoggingEvent.getThrowableStrRep(LoggingEvent.java:342)
at org.apache.log4j.WriterAppender.subAppend(WriterAppender.java:304)
at org.apache.log4j.WriterAppender.append(WriterAppender.java:159)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65)
at org.apache.log4j.Category.callAppenders(Category.java:203)
at org.apache.log4j.Category.forcedLog(Category.java:388)
at org.apache.log4j.Category.log(Category.java:853)
at org.apache.commons.logging.impl.Log4JLogger.debug(Log4JLogger.java:121)
at org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:63)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:42)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at org.springframework.orm.hibernate3.HibernateTemplate$38.doInHibernate(HibernateTemplate.java:1012)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.findByExample(HibernateTemplate.java:1001)
at org.springframework.orm.hibernate3.HibernateTemplate.findByExample(HibernateTemplate.java:994)
at dao.impl.AdminDAO.findByExample(AdminDAO.java:76)
at service.impl.AdminServiceImpl.isAdmin(AdminServiceImpl.java:22)
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)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
at $Proxy1.isAdmin(Unknown Source)
at junit.Junit.testIsAdmin(Junit.java:54)
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)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

package model;
// default package

/**
* @hibernate.class table="admin"
*/
public class Admin implements java.io.Serializable {

private static final long serialVersionUID = -4189537965746427533L;

private Long id;
private String userid;
private String password;
private String position;
private String phone;
private String address;
private String remark;

/**
* @hibernate.id generator-class="increment" unsaved-value="null" length="10"
*/
public Long getId() {
return this.id;
}

public void setId(Long id) {
this.id = id;
}

/**
* @hibernate.property length="30" unique="true"
*/
public String getUserid() {
return this.userid;
}
public void setUserid(String userid) {
this.userid = userid;
}

/**
* @hibernate.property length="200"
*/
public String getPassword() {
return this.password;
}

public void setPassword(String password) {
this.password = password;
}

/**
* @hibernate.property length="100"
*/
public String getPosition() {
return this.position;
}
public void setPosition(String position) {
this.position = position;
}

/**
* @hibernate.property length="40"
*/
public String getPhone() {
return this.phone;
}
public void setPhone(String phone) {
this.phone = phone;
}

/**
* @hibernate.property length="100"
*/
public String getAddress() {
return this.address;
}

public void setAddress(String address) {
this.address = address;
}

/**
* @hibernate.property length="200"
*/
public String getRemark() {
return this.remark;
}

public void setRemark(String remark) {
this.remark = remark;
}
}

<?xml version="1.0" encoding="UTF-8"?>

<beans>
<!--定义Hibernate参数 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.ibm.db2.jcc.DB2Driver</value>
<!-- MYSQL的驱动
<value>com.mysql.jdbc.Driver</value>
-->
<!-- SQL SERVER的驱动
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
-->
</property>
<property name="url">
<value>jdbc:db2://localhost:50000/film</value>
<!-- <value>jdbc:db2:film</value>-->
<!-- 连接 Microsoft SQL Server 2000
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=registration</value>
-->
</property>
<property name="username">
<!-- <value>root</value> -->

<value>root</value>

<!--<value>db2admin</value>-->
</property>
<property name="password">
<value>987654321</value>
</property>

<property name="maxActive">
<value>30</value>
</property>
<property name="maxWait">
<value>30000</value>
</property>
<property name="defaultAutoCommit">
<value>false</value>
</property>
<property name="defaultReadOnly">
<value>false</value>
</property>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<!-- DB2数据库方言 -->
<prop key="hibernate.dialect">org.hibernate.dialect.DB2Dialect</prop>

<!-- MYSQL数据库方言
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>-->

<!-- SQL SERVER数据库方言
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
-->
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>model/Admin.hbm.xml</value>
<value>model/Spectator.hbm.xml</value>
<value>model/Hall.hbm.xml</value>
<value>model/Ticket.hbm.xml</value>
<value>model/Film.hbm.xml</value>
</list>
</property>
</bean>
<!--定义Hibernate参数 -->

<!-- 向BaseDAO的实现类注入SessionFactory-->
<bean id="BaseHibernateDAO" class="dao.impl.BaseHibernateDAO" lazy-init="false" singleton="true">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<!-- 向BaseDAO的实现类注入SessionFactory-->

<!-- 管理员DAO -->
<bean id="AdminDAO" class="dao.impl.AdminDAO" >
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<!-- 管理员DAO -->

<!-- 电影DAO -->
<bean id="FilmDAO" class="dao.impl.FilmDAO" >
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<!-- 电影DAO -->

<!-- 放映厅DAO -->
<bean id="HallDAO" class="dao.impl.HallDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<!-- 放映厅DAO -->

<!-- 电影票DAO -->
<bean id="TicketDAO" class="dao.impl.TicketDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<!-- 电影票DAO -->

<!-- 观众DAO -->
<bean id="SpectatorDAO" class="dao.impl.SpectatorDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<!-- 电影票DAO -->

<!-- 注入服务xxxServiceImpl之开始 -->
<bean id="AdminServiceImpl" class="service.impl.AdminServiceImpl" lazy-init="false" singleton="true">
<property name="adminDAO">
<ref bean="AdminDAO"/>
</property>
</bean>
<bean id="FilmServiceImpl" class="service.impl.FilmServiceImpl" lazy-init="false" singleton="true">
<property name="filmDAO">
<ref bean="FilmDAO"/>
</property>
<property name="baseDAO">
<ref bean="BaseHibernateDAO"/>
</property>
</bean>
<bean id="HallServiceImpl" class="service.impl.HallServiceImpl" lazy-init="false" singleton="true">
<property name="hallDAO">
<ref bean="HallDAO"/>
</property>
<property name="baseDAO">
<ref bean="BaseHibernateDAO"/>
</property>
</bean>
<bean id="TicketServiceImpl" class="service.impl.TicketServiceImpl" lazy-init="false" singleton="true">
<property name="ticketDAO">
<ref bean="TicketDAO"/>
</property>
<property name="baseDAO">
<ref bean="BaseHibernateDAO"/>
</property>
</bean>
<bean id="SpectatorServiceImpl" class="service.impl.SpectatorServiceImpl" lazy-init="false" singleton="true">
<property name="spectatorDAO">
<ref bean="SpectatorDAO"/>
</property>
<property name="baseDAO">
<ref bean="BaseHibernateDAO"/>
</property>
</bean>
<!-- 注入服务xxxServiceImpl之结束 -->





<!-- 注入事务 -->
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>

<bean id="adminServiceProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="target">
<ref local="AdminServiceImpl" />
</property>
<property name="transactionAttributes">
<props>
<prop key="show*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="add*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>

<bean id="filmServiceProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="target">
<ref local="FilmServiceImpl" />
</property>
<property name="transactionAttributes">
<props>
<prop key="show*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="add*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>

<bean id="hallServiceProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="target">
<ref local="HallServiceImpl" />
</property>
<property name="transactionAttributes">
<props>
<prop key="show*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="add*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>

<bean id="spectatorServiceProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="target">
<ref local="SpectatorServiceImpl" />
</property>
<property name="transactionAttributes">
<props>
<prop key="show*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="add*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>

<bean id="ticketServiceProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="target">
<ref local="TicketServiceImpl" />
</property>
<property name="transactionAttributes">
<props>
<prop key="show*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="add*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>
<!-- 注入事务 -->
</beans>

[此贴子已经被作者于2007-1-12 0:47:44编辑过]