Unfortunately the JDBC/ODBC bridge driver fails to support a great many JDBC 2.0 features. It is also buggy and has some weird usage semantics. We would have to make too many sacrifices to support excel, which is pretty rare, so we don't.
Clinton On Sun, 27 Mar 2005 10:52:39 -0500, Sancho Chiang <[EMAIL PROTECTED]> wrote: > Hi, > I would like to ask if it's possible to use excel as the persistence layer > with iBATIS doing the O/R mapping job. I have been trying to implement but > get stuck with two problems. > > Firstly, I set up a ODBC datasource with my excel file in my machine. I > tried to access the data in excel with simple JDBC command to make sure that > it's working. However, when I tried to make a query with iBATIS, I got the > following exception. > java.sql.SQLException: [Microsoft][ODBC Excel Driver]Optional feature not > implemented > at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) > at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) > at sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(JdbcOdbc.java:5115) > at > sun.jdbc.odbc.JdbcOdbcConnection.setAutoCommit(JdbcOdbcConnection.java:651) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.invoke(SimpleDataSource.java:946) > at $Proxy0.setAutoCommit(Unknown Source) > at > com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:56) > at > com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89) > at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584) > at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105) > at > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77) > at test.TestIBatis.testSelectExcel(TestIBatis.java:64) > at test.TestIBatis.main(TestIBatis.java:36) > > It seems like the ODBC driver for excel doesn't support the > setAutoCommint(). Is there anyway to get away with it? Could I just turn off > the transaction manager for iBATIS? > > Secondly, even though I get away with the first problem by changing the > source code, my sql query cannot be parsed. This is my sql: Select * from > [Sheet1$] > '$' is reserved word in SQL. I don't know if iBATIS can handle this kind of > exceptional case. > > Could somebody help to solve the problem? Thx a lot > > Regards, > Sancho Chiang > > _________________________________________________________________ > Don't just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > >
