Hi,
我用一样的办法用iBatis连接Oracle和Mysql操作数据都很正常。但是改为Access数据库后就怪事无常!
如下:
我的连接配置:
[code]
jdbc.driverClassName=sun.jdbc.odbc.JdbcOdbcDriver
jdbc.url=jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\xgll.mdb
jdbc.username=
jdbc.password=
[/code]
[code]
<!-- 本地 Apache Commons DBCP 数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"><value>${jdbc.driverClassName}</value></property>
<property name="url"><value>${jdbc.url}</value></property>
<property name="username"><value>${jdbc.username}</value></property>
<property name="password"><value>${jdbc.password}</value></property>
</bean>
[/code]
SqlMap配置文件如下:
[code]
<!-- 删除所有数据 -->
<delete id="deleteRootnewsDomains" parameterClass="map">
delete from rootnews
</delete>
[/code]
控制台报出的错误信息:
[code]
--- The error occurred while executing update.
--- Check the delete from rootnews .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
[/code]
我的疑惑:
1.拼出来的SQL语句后面怎么多了一个点号
2.jdbc.url=jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\xgll.mdb这里配置的绝对路径如何才能改为相对路劲!
我用一样的办法用iBatis连接Oracle和Mysql操作数据都很正常。但是改为Access数据库后就怪事无常!
如下:
我的连接配置:
[code]
jdbc.driverClassName=sun.jdbc.odbc.JdbcOdbcDriver
jdbc.url=jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\xgll.mdb
jdbc.username=
jdbc.password=
[/code]
[code]
<!-- 本地 Apache Commons DBCP 数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"><value>${jdbc.driverClassName}</value></property>
<property name="url"><value>${jdbc.url}</value></property>
<property name="username"><value>${jdbc.username}</value></property>
<property name="password"><value>${jdbc.password}</value></property>
</bean>
[/code]
SqlMap配置文件如下:
[code]
<!-- 删除所有数据 -->
<delete id="deleteRootnewsDomains" parameterClass="map">
delete from rootnews
</delete>
[/code]
控制台报出的错误信息:
[code]
--- The error occurred while executing update.
--- Check the delete from rootnews .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
[/code]
我的疑惑:
1.拼出来的SQL语句后面怎么多了一个点号
2.jdbc.url=jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\xgll.mdb这里配置的绝对路径如何才能改为相对路劲!