3 Replies Latest reply on Apr 29, 2009 6:29 AM by Ramesh Reddy

    Connecting to Teiid VDB in Jasper/iReport

    Eric Carr Newbie

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

        • 1. Re: Connecting to Teiid VDB in Jasper/iReport
          Ramesh Reddy Master

          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
            Eric Carr Newbie

            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
              Ramesh Reddy Master

              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.