Invalid Fetch Size using JDBC ODBC bridge to query MS Access via a Teiid VDB ---------------------------------------------------------------------------- Key: TEIID-1292 URL: https://jira.jboss.org/browse/TEIID-1292 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.1 Reporter: Warren Gibson Assignee: Steven Hawkins When using Squirrel as a client to query an Access DB with a Teiid VDB using the ODBC bridge I am getting an invalid Fetch Size. I have a DSN set up and can query the Access DB with an ODBC client using the DSN. There seems to be lots of chatter on the web about this but I didn't find a solution. This seems to be a KI with the JDBC ODBC bridge and is not a Teiid Bug but possibly Teiid can offer a workaround. 2010-10-05 15:52:17,421 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue16) Source-specific command: SELECT EmpData.LastName, EmpData.FirstName, EmpData.MiddleName, EmpData.EmpId, EmpData.Department, EmpData.AnnualSalary, EmpData.Title, EmpData.HomePhone, EmpData.Manager, EmpData.Street, EmpData.City, EmpData.State, EmpData.zip FROM EmpData 2010-10-05 15:52:17,421 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue16) ERROR SRC COMMAND: endTime=2010-10-05 15:52:17.421 requestID=o1eKkvzGMfT4.7 sourceCommandID=2 txID=null modelName=ODBCTesting connectorBindingName=jdbc-simple sessionID=o1eKkvzGMfT4 principal=admin@teiid-security finalRowCount=null 2010-10-05 15:52:17,421 WARN [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue16) Connector worker process failed for atomic-request=o1eKkvzGMfT4.7.2.1 [JDBCExecutionException] 0: Error Code:0 Message:'Invalid Fetch Size' error executing statement(s): [Prepared Values: [] SQL: SELECT EmpData.LastName, EmpData.FirstName, EmpData.MiddleName, EmpData.EmpId, EmpData.Department, EmpData.AnnualSalary, EmpData.Title, EmpData.HomePhone, EmpData.Manager, EmpData.Street, EmpData.City, EmpData.State, EmpData.zip FROM EmpData] 1 [SQLException]Invalid Fetch Size at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:189) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Invalid Fetch Size at sun.jdbc.odbc.JdbcOdbcStatement.setFetchSize(Unknown Source) at org.jboss.resource.adapter.jdbc.WrappedStatement.setFetchSize(WrappedStatement.java:647) at org.teiid.translator.jdbc.JDBCBaseExecution.setSizeContraints(JDBCBaseExecution.java:138) at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:167) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:82) ... 12 more -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira