[teiid-issues] [JBoss JIRA] Commented: (TEIID-1668) Exception trying to preview data or execute VDB against SYBASE BQT2 table containing clob column

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12617142#comment-12617142 ] 

Steven Hawkins commented on TEIID-1668:
---------------------------------------

Did you test this again?

> 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 at 1005083[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection at b0818a handles=1 lastUse=1309988982862 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 1b6e768 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 11261d3 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource at 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