[teiid-issues] [JBoss JIRA] Created: (TEIID-1292) Invalid Fetch Size using JDBC ODBC bridge to query MS Access via a Teiid VDB

[Warren Gibson (JIRA)]

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 at 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