5:03 p.m.
Exception trying to preview data or execute VDB against SYBASE BQT2 table containing clob
column
------------------------------------------------------------------------------------------------
Key: TEIID-1668
URL: https://issues.jboss.org/browse/TEIID-1668
Project: Teiid
Issue Type: Bug
Reporter: Barry LaFond
Assignee: Steven Hawkins
Testing various BQT2 DB's including Sybase.
1) Imported SMALLA & SMALLB tables, added to VDB and deployed
2) Able to query SELECT IntKey FROM SMALLA and get results
2) Try to perform SELECT * FROM SMALLA and get the following
16:49:28,338 WARN [PROCESSOR] Processing exception 'BQT2_2: Unexpected exception
while translating results: Error' for request rLu0N1TlGtw/.6. Exception type
org.teiid.core.TeiidProcessingException thrown from
org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:873).
Enable more detailed logging to see the entire stacktrace.
16:49:42,992 WARN [TxConnectionManager] Connection error occured:
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1005083[state=NORMAL
mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@b0818a handles=1
lastUse=1309988982862 permit=true trackByTx=false
mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1b6e768
context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@11261d3
xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@89ede
txSync=null]
java.lang.UnsupportedOperationException: The method
com.sybase.jdbc3.jdbc.SybCursorResultSet.getClob(int) is not supported and should not be
called.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseRuntimeException(Unknown Source)
at com.sybase.jdbc3.utils.Debug.notSupported(Unknown Source)
at com.sybase.jdbc3.jdbc.SybResultSet.getClob(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedResultSet.getClob(WrappedResultSet.java:503)
at
org.teiid.translator.jdbc.JDBCExecutionFactory.retrieveValue(JDBCExecutionFactory.java:929)
at
org.teiid.translator.jdbc.sybase.SybaseExecutionFactory.retrieveValue(SybaseExecutionFactory.java:358)
at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:103)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:282)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:267)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:80)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
16:49:43,050 WARN [CONNECTOR] Connector worker process failed for
atomic-request=A1ZwTKKSzuDt.0.1.22
[TranslatorException]Unexpected exception while translating results: Error
1 [NestedSQLException]Error
at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:110)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:282)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:267)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338)
at
org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:80)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138)
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.jboss.util.NestedSQLException: Error
at
org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:873)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:852)
at
org.jboss.resource.adapter.jdbc.WrappedResultSet.checkException(WrappedResultSet.java:1947)
at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:1200)
at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:97)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira