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

Mon Sep 26 00:05:26 EDT 2011

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