ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Rogov <ko...@i-c.com.ua>
Subject Re: Problem with Excel+iBATIS
Date Mon, 28 Mar 2005 13:08:51 GMT


SC> Hi,
SC> I would like to ask if it's possible to use excel as the persistence layer 
SC> with iBATIS doing the O/R mapping job. I have been trying to implement but 
SC> get stuck with two problems.

SC> Firstly, I set up a ODBC datasource with my excel file in my machine. I 
SC> tried to access the data in excel with simple JDBC command to make sure that 
SC> it's working. However, when I tried to make a query with iBATIS, I got the 
SC> following exception.
SC> java.sql.SQLException: [Microsoft][ODBC Excel Driver]Optional feature not 
SC> implemented
SC>         at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
SC>         at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
SC>         at sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(JdbcOdbc.java:5115)
SC>         at 
SC> sun.jdbc.odbc.JdbcOdbcConnection.setAutoCommit(JdbcOdbcConnection.java:651)
SC>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
SC>         at 
SC> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
SC>         at 
SC> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
SC>         at java.lang.reflect.Method.invoke(Method.java:324)
SC>         at 
SC> com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.invoke(SimpleDataSource.java:946)
SC>         at $Proxy0.setAutoCommit(Unknown Source)
SC>         at 
SC> com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:56)
SC>         at 
SC> com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
SC>         at 
SC> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
SC>         at 
SC> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
SC>         at 
SC> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
SC>         at 
SC> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
SC>         at 
SC> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
SC>         at test.TestIBatis.testSelectExcel(TestIBatis.java:64)
SC>         at test.TestIBatis.main(TestIBatis.java:36)

SC> It seems like the ODBC driver for excel doesn't support the 
SC> setAutoCommint(). Is there anyway to get away with it? Could I just turn off 
SC> the transaction manager for iBATIS?

SC> Secondly, even though I get away with the first problem by changing the 
SC> source code, my sql query cannot be parsed. This is my sql: Select * from 
SC> [Sheet1$]
SC> '$' is reserved word in SQL. I don't know if iBATIS can handle this kind of 
SC> exceptional case.

SC> Could somebody help to solve the problem? Thx a lot

SC> Regards,
SC> Sancho Chiang

SC> _________________________________________________________________
SC> Don’t just search. Find. Check out the new MSN Search! 
SC> http://search.msn.click-url.com/go/onm00200636ave/direct/01/

С уважением,
 Andrey                          mailto:konus@i-c.com.ua

View raw message