11:11 a.m.
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