Connecting to Teiid VDB in Jasper/iReport

[eacarr]

Has anyone successfully used Teiid Embedded to connect to a VDB using Jasper iReport?

[rareddy]

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..

[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)

[rareddy]

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.