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

[Steven Hawkins (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-1292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1292.
-----------------------------------

    Fix Version/s: 7.1.1
       Resolution: Done


added a catch block and a log of the exception.

> 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
>             Fix For: 7.1.1
>
>
> 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