[teiid-issues] [JBoss JIRA] Issue Comment Edited: (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