請(qǐng)教ibatis運(yùn)行異常

ttl_web

日志：
2007-12-03 21:06:47,828 INFO [lsjGui.JinRu] - com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in lsjDomain/Js.xml.
--- The error occurred while applying a result map.
--- Check the Js.RMJs.
--- The error happened while setting a property on the result object.
--- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can´t start a cloned connection while in manual transaction mode.

代碼：
lsjGui/JinRu.java

1. 
   
2. ...
   
3. private static final Logger log = Logger.getLogger(JinRu.class);
   
4. 
   
5. private static SqlMapClient sqlMapper;
   
6. static {
   
7. try {
   
8. Reader reader = Resources
   
9. .getResourceAsReader("lsjDomain/SqlMapConfig.xml");
   
10. sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
    
11. reader.close();
    
12. } catch (IOException e) {
    
13. throw new RuntimeException(
    
14. "Something bad happened while building the SqlMapClient instance."
    
15. + e, e);
    
16. }
    
17. }
    
18. 
    
19. public void zb() {
    
20. try {
    
21. sqlMapper.startTransaction();
    
22. List js = sqlMapper.queryForList("queryAll");
    
23. sqlMapper.commitTransaction();
    
24. } catch (Exception e) {
    
25. log.info(e.toString());
    
26. System.exit(0);
    
27. } finally {
    
28. try {
    
29. sqlMapper.endTransaction();
    
30. }
    
31. catch (Exception e) {
    
32. log.info(e.toString());
    
33. System.exit(0);
    
34. }
    
35. }
    

復(fù)制代碼

====================
lsjDomain/SqlMapConfig.xml

1. 
   
2. <?xml version="1.0" encoding="UTF-8" ?>
   
3. 
   
4. <!DOCTYPE sqlMapConfig
   
5. PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
   
6. "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
   
7. 
   
8. <sqlMapConfig>
   
9. <transactionManager type="JDBC" commitRequired="false">
   
10. <dataSource type="SIMPLE">
    
11. <property name="JDBC.Driver"
    
12. value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
    
13. <property name="JDBC.ConnectionURL"
    
14. value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=EMIS" />
    
15. <property name="JDBC.Username" value="sa" />
    
16. <property name="JDBC.Password" value="" />
    
17. </dataSource>
    
18. </transactionManager>
    
19. 
    
20. <sqlMap resource="lsjDomain/Js.xml" />
    
21. 
    
22. </sqlMapConfig>
    

復(fù)制代碼

========
lsjDomain/Js.java

1. 
   
2. package lsjDomain;
   
3. 
   
4. import java.io.IOException;
   
5. import java.io.Reader;
   
6. import java.sql.SQLException;
   
7. import java.util.List;
   
8. 
   
9. import com.ibatis.common.resources.Resources;
   
10. import com.ibatis.sqlmap.client.SqlMapClient;
    
11. import com.ibatis.sqlmap.client.SqlMapClientBuilder;
    
12. 
    
13. public class Js {
    
14. public Integer c0;
    
15. public String c1;
    
16. public Integer getC0() {
    
17. return c0;
    
18. }
    
19. public void setC0(int c0) {
    
20. this.c0 = c0;
    
21. }
    
22. public String getC1() {
    
23. return c1;
    
24. }
    
25. public void setC1(String c1) {
    
26. this.c1 = c1;
    
27. }
    
28. public String toString() {
    
29. return "c0 = "+c0+ " , c1 = "+c1;
    
30. }
    
31. }
    

復(fù)制代碼

========
lsjDomain/Js.xml

1. 
   
2. <?xml version="1.0" encoding="UTF-8" ?>
   
3. <!DOCTYPE sqlMap
   
4. PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
   
5. "http://ibatis.apache.org/dtd/sql-map-2.dtd">
   
6. <sqlMap namespace="Js">
   
7. <typeAlias alias="js" type="lsjDomain.Js" />
   
8. <resultMap class="js" id="RMJs">
   
9. <result property="c0" column="c0" />
   
10. <result property="c1" column="c1" />
    
11. </resultMap>
    
12. <select id="queryAll" resultMap="RMJs">
    
13. select c0, c1 from emis_1
    
14. </select>
    
15. </sqlMap>
    

復(fù)制代碼

kakasi

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs;SelectMethod=Direct;User=User;Password=Password
==>
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs;SelectMethod=Cursor;User=User;Password=Password

參考這里
http://support.microsoft.com/kb/313181/zh-cn

ttl_web

謝謝
我來試試