[teiid-issues] [JBoss JIRA] Commented: (TEIID-1762) Exception when using Teiid with BIRT Report Designer
Graeme Gillies (JIRA)
jira-events at lists.jboss.org
Mon Sep 26 23:50:26 EDT 2011
[ https://issues.jboss.org/browse/TEIID-1762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12630612#comment-12630612 ]
Graeme Gillies commented on TEIID-1762:
---------------------------------------
Hi,
Using the teiid query logger I can see
{noformat}
2011-09-27 13:47:00,566 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=2011-09-27 13:47:00.566 requestID=skFqdNgpv8QW.0 txID=null sessionID=skFqdNgpv8QW applicationName=JDBC principal=admin at REDHAT.COM vdbName=BneDS vdbVersion=1 sql=SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables g WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(SchemaName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' AND (CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME
2011-09-27 13:47:00,760 DEBUG [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue5) END USER COMMAND: endTime=2011-09-27 13:47:00.76 requestID=skFqdNgpv8QW.0 txID=null sessionID=skFqdNgpv8QW principal=admin at REDHAT.COM vdbName=BneDS vdbVersion=1 finalRowCount=795
{noformat}
So I think the query is
{noformat}
SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables g WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(SchemaName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' AND (CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME
{noformat}
> Exception when using Teiid with BIRT Report Designer
> ----------------------------------------------------
>
> Key: TEIID-1762
> URL: https://issues.jboss.org/browse/TEIID-1762
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 7.5
> Environment: java-1.6.0-openjdk-1.6.0.0-59.1.10.3.fc15.i686
> java version "1.6.0_22"
> OpenJDK Runtime Environment (IcedTea6 1.10.3) (fedora-59.1.10.3.fc15-i386)
> OpenJDK Server VM (build 20.0-b11, mixed mode)
> On Fedora 15
> Eclipse version Helios, using Birt version 3.7 milestone.
> Connecting to teiid 7.5 (in JBoss EAP 5.1.1) running on RHEL 5
> Reporter: Graeme Gillies
> Assignee: Steven Hawkins
>
> Hi,
> I've been trying to use the Birt report Designer tool in eclipse to talk to teiid in order to look at designing some reports on top of it.
> I can add the datasource fine but when I go to create a data set, I notice the following error getting spammed to the eclipse log
> {code}
> Sep 26, 2011 12:00:39 PM org.eclipse.birt.report.data.oda.jdbc.ui.model.SchemaNode refetchChildren
> WARNING: Column name "TABLE_NAME" does not exist.
> org.teiid.jdbc.TeiidSQLException: Column name "TABLE_NAME" does not exist.
> at org.teiid.jdbc.ResultSetImpl.findColumnIndex(ResultSetImpl.java:1227)
> at org.teiid.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1214)
> at org.teiid.jdbc.ResultSetImpl.getString(ResultSetImpl.java:826)
> at org.eclipse.birt.report.data.oda.jdbc.ui.model.SchemaNode.refetchChildren(SchemaNode.java:71)
> at org.eclipse.birt.report.data.oda.jdbc.ui.model.RootNode.refetchChildren(RootNode.java:106)
> at org.eclipse.birt.report.data.oda.jdbc.ui.model.ChildrenAllowedNode$1TempThread.run(ChildrenAllowedNode.java:35)
> Sep 26, 2011 12:00:54 PM org.eclipse.birt.report.data.oda.jdbc.ui.model.SchemaNode refetchChildren
> WARNING: Column name "TABLE_NAME" does not exist.
> org.teiid.jdbc.TeiidSQLException: Column name "TABLE_NAME" does not exist.
> at org.teiid.jdbc.ResultSetImpl.findColumnIndex(ResultSetImpl.java:1227)
> at org.teiid.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1214)
> at org.teiid.jdbc.ResultSetImpl.getString(ResultSetImpl.java:826)
> at org.eclipse.birt.report.data.oda.jdbc.ui.model.SchemaNode.refetchChildren(SchemaNode.java:71)
> at org.eclipse.birt.report.data.oda.jdbc.ui.model.RootNode.refetchChildren(RootNode.java:106)
> at org.eclipse.birt.report.data.oda.jdbc.ui.model.ChildrenAllowedNode$1TempThread.run(ChildrenAllowedNode.java:35)
> {code}
> We have also noticed the problem when using other reporting engines like http://datavision.sourceforge.net/ which throw the same error.
> Is it possible to have the column added to whatever table is needed (I assume the SYS model) in order for these errors to not occur?
> Thanks,
> Graeem
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list