如何在Weblogic5.1中通过ODBC访问Access？

[littlefish00]

我写一个EJB测试程序的时候通过ODBC访问ACCESS数据库时发生如下错误,不知该如何解决，谢谢！
星期五 六月 22 14:25:45 GMT+08:00 2001:<I> <EJB JAR deployment C:\usr\yje\program\java\testejb\Untitled1.jar> Transaction: '993190907400_5' rolled back due to EJB exception:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access 驱动程序]可选的功能未实现
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:4089)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
at sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(JdbcOdbc.java:2990)
at sun.jdbc.odbc.JdbcOdbcConnection.setTransactionIsolation(JdbcOdbcConnection.java:671)
at weblogic.jdbcbase.jts.Connection.setTransactionIsolation(Connection.java:396)
at weblogic.jdbcbase.jts.Connection.openConnectionIfNecessary(Connection.java:628)
at weblogic.jdbcbase.jts.Connection.prepareStatement(Connection.java:135)
at com.titan.cabin.CabinPSWebLogic_CMP_RDBMS.refresh(CabinPSWebLogic_CMP_RDBMS.java:222)
at com.titan.cabin.CabinPSWebLogic_CMP_RDBMS.load(CabinPSWebLogic_CMP_RDBMS.java:203)
at weblogic.ejb.internal.EntityEJBContext.load(EntityEJBContext.java:151)
at weblogic.ejb.internal.EntityEJBContext.afterBegin(EntityEJBContext.java:212)
at weblogic.ejb.internal.StatefulEJBObject.getContextForInvoke(StatefulEJBObject.java:162)
at weblogic.ejb.internal.BaseEJBObject.preInvoke(BaseEJBObject.java:421)
at com.titan.cabin.CabinBeanEOImpl.getName(CabinBeanEOImpl.java:106)
at com.titan.cabin.CabinBeanEOImpl_WLSkel.invoke(CabinBeanEOImpl_WLSkel.java:83)
at weblogic.rmi.extensions.BasicServerObjectAdapter.invoke(BasicServerObjectAdapter.java, Compiled Code)
at weblogic.rmi.extensions.BasicRequestHandler.handleRequest(BasicRequestHandler.java, Compiled Code)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java, Compiled Code)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java, Compiled Code)

[plato]

你在设置transaction的时候，指定了access不支持的属性。

看看你的ejb配置的xml，配成什么transaction的属性了。

[plato]

你先改成NotSupported：

<trans-attribute>NotSupported</trans-attribute>