[teiid-issues] [JBoss JIRA] (TEIID-1762) Exception when using Teiid with BIRT Report Designer

[Steven Hawkins (Closed) (JIRA)]

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

Steven Hawkins closed TEIID-1762.
---------------------------------


    
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira