[teiid-issues] [JBoss JIRA] Commented: (TEIID-1762) Exception when using Teiid with BIRT Report Designer
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Tue Sep 27 11:28:26 EDT 2011
[ https://issues.jboss.org/browse/TEIID-1762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12630799#comment-12630799 ]
Steven Hawkins commented on TEIID-1762:
---------------------------------------
What teiid client version are you using? It appears to be a 7.3 client. Unfortunately the metadata change to support JDBC 4 column labels is not backwards compatible with older clients. If you use a 7.4 or later client this issue should go away. If it's absolutely necessary to support older clients a server patch would be required.
> 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