Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
Received-SPF: pass (hermes.apache.org: domain of chiangpak@hotmail.com
 designates 64.4.61.42 as permitted sender)
Message-ID: <BAY102-F323315C542972A63EC92D6BF430@phx.gbl>
From: "Sancho Chiang" <chiangpak@hotmail.com>
To: ibatis-user-java@incubator.apache.org
Bcc: 
Subject: Problem with Excel+iBATIS
Date: Sun, 27 Mar 2005 10:52:39 -0500
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

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/