-
1. Re: Connecting to Teiid VDB in Jasper/iReport
rareddy Apr 28, 2009 3:03 PM (in response to eacarr)It has been successfully tested previously with "metamatrix" server, which is the product that Teiid evolved from. The VDB was created to have the star schema.
I have not doubt, why it would be any different with Embedded. As long as you can configure a JDBC source in Jasper iReport you can make Embedded work.
Let us know, how it goes.
Ramesh.. -
2. Re: Connecting to Teiid VDB in Jasper/iReport
eacarr Apr 28, 2009 3:08 PM (in response to eacarr)iReport does allow configuration of JDBC drivers.
I have added the teiid-embedded-6.0.0 folder and /lib /extension .jar files to iReport's classpath.
Setting up the driver I point to teiid-6.0.0-client.jar, select com.metamatrix.jdbc.EmbeddedDriver with a URL of jdbc:metamatrix:MetadataDict
The error being returned is:
Unable to add connection. Cannot establish a connection to jdbc:metamatrix.MetadataDict using com.metamatrix.jdbc.EmbeddedDriver (com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl cannot be cast to com.metamatrix.jdbc.EmbeddedConnectionFactory) -
3. Re: Connecting to Teiid VDB in Jasper/iReport
rareddy Apr 29, 2009 6:29 AM (in response to eacarr)I see some kind of class loading issue the way you have the classpath creation. I not familiar with iReport's JDBC driver definition mechanism.
I would suggest you use the "File path Profile" specified in this document
http://www.jboss.org/community/docs/DOC-13182
With this profile, you copy your VDB into "deploy" directory and only put the embedded client jar in the iReport's classpath.