[teiid-issues] [JBoss JIRA] Created: (TEIID-1762) Exception when using Teiid with BIRT Report Designer
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