请教ibatis 连 access数据库的配置问题，谢谢！

Question

以下是配置文件内容：SqlMapConfig.xml<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"  
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig> <properties resource="SqlMapConfig.properties" /> <settings 
cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" maxRequests="512" maxSessions="256"
maxTransactions="128" useStatementNamespaces="false" 
/>

<typeAlias alias="order" type="testdomain.Order" /> <transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="${driver}" />
<property name="JDBC.ConnectionURL" value="${url}" />
<property name="JDBC.Username" value="${username}" />
<property name="JDBC.Password" value="${password}" />
<property name="JDBC.DefaultAutoCommit" value="true" />
<property name="Pool.MaximumActiveConnections" value="64" />
<property name="Pool.MaximumIdleConnections" value="32" />
<property name="Pool.MaximumCheckoutTime" value="120000" />
<property name="Pool.TimeToWait" value="20000" />
<property name="Pool.PingQuery" value="select 1 from t00_user" />
<property name="Pool.PingEnabled" value="false" />
<property name="Pool.PingConnectionsOlderThan" value="1" />
<property name="Pool.PingConnectionsNotUsedFor" value="1" />
</dataSource>
</transactionManager>

<sqlMap resource="sqlmap/T00_user.xml" />

</sqlMapConfig>以下是资源文件：SqlMapConfig.propertiesdriver=sun.jdbc.odbc.JdbcOdbcDriver
url=jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\tools\\apache-tomcat-6.0.14\\webapps\\yiqi\\manager\\jcc.mdb
username=
password=以下是错误页面：HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]可选的功能未实现
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]可选的功能未实现
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnection.setTransactionIsolation(Unknown Source)
com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.setTransactionIsolation(SimpleDataSource.java:1025)
com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:629)
com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:213)
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:92)
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93)
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:70)
manager.ActionLogin.execute(ActionLogin.java:30)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.14 logs.请教各位高人，如问题解决，不胜感激，高分相赠！

Answer 1

此回复为自动发出,仅用于显示而已，并无任何其他特殊作用
楼主【yiran515】截止到2008-07-18 14:34:45的历史汇总数据(不包括此帖)：
发帖的总数量:0                        发帖的总分数:0                        每贴平均分数:0                        
回帖的总数量:2                        得分贴总数量:0                        回帖的得分率:0%                       
结贴的总数量:0                        结贴的总分数:0                        
无满意结贴数:0                        无满意结贴分:0                        
未结的帖子数:0                        未结的总分数:0                        
结贴的百分比:---------------------结分的百分比:---------------------
无满意结贴率:---------------------无满意结分率:---------------------
如何结贴请参考这里：http://topic.csdn.net/u/20080501/09/ef7ba1b3-6466-49f6-9d92-36fe6d471dd1.html

Answer 2

http://zhidao.baidu.com/question/34865516.html?fr=qrl

Answer 3

我在SqlMapConfig.properties 里配置MYSQL数据库正常，不用ibatis，直接连接access数据库也正常，所以我觉得是ibatis配置的问题，还请大家多多帮忙，在此感激不尽！！！

Answer 4

sorry，那时baidu的时候，说access有问题，可能不是特别支持吧，