7 Replies Latest reply: Jul 12, 2012 10:16 AM by Steven Hawkins RSS

Teiid 8.0 JDBC JAR download not found

Hendy Irawan Newbie

Teiid 8.0 JDBC JAR download is Error 404 not found

  • 1. Re: Teiid 8.0 JDBC JAR download not found
    Ramesh Reddy Master

    Hendy,

     

    Sorry about that! in 8.0 we are individually supplying the JDBC jar file, I will fix the link. Meanwhile, you can get it from JBoss maven repo here

     

    https://repository.jboss.org/nexus/content/groups/public/org/jboss/teiid/teiid/8.0.0.Final/teiid-8.0.0.Final-jdbc.jar

     

    Ramesh..

  • 2. Re: Teiid 8.0 JDBC JAR download not found
    al carvalho Newbie

    Ramesh -

    I can't find the Teiid 7.7.0.Final jdbc jar in the download either - where is that file ?

  • 3. Re: Teiid 8.0 JDBC JAR download not found
    Ramesh Reddy Master

    Al,

     

    In 7.7 the "jdbc" jar is called client jar, it is in the "lib" directory of the distribution. In 8.0, since it uses a different classloading structure it has a separate jar file.

     

    Ramesh..

  • 4. Re: Teiid 8.0 JDBC JAR download not found
    al carvalho Newbie

    Thanks Ramesh -

    Any idea what is causing ClassNotFound error with C:\teiid-7.7.0.Final-jboss-dist\lib in the Classpath ?

    C:\jboss-as-7.1.1.Final\docs\teiid\examples\simpleclient>java JDBCClient 31000 DynamicPortfolio Select * from Accounts
    Executing using the TeiidDriver
    Exception in thread "main" java.lang.ClassNotFoundException: org.teiid.jdbc.TeiidDriver
            at java.net.URLClassLoader$1.run(Unknown Source)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
            at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
            at java.lang.Class.forName0(Native Method)
            at java.lang.Class.forName(Unknown Source)
            at JDBCClient.getDriverConnection(JDBCClient.java:52)
            at JDBCClient.main(JDBCClient.java:42)

  • 5. Re: Teiid 8.0 JDBC JAR download not found
    Ramesh Reddy Master

    try using "C:\teiid-7.7.0.Final-jboss-dist\server\default\lib\teiid-7.7.0.Final-client.jar" in your classpath

     

    as per the example you are using take look at the "run.bat" script in the same directory

  • 6. Re: Teiid 8.0 JDBC JAR download not found
    al carvalho Newbie

    Ramesh -

    Here is the relevant JDBCClient code, SET output, directory contents and the Exception I'm getting -

    It appears that I'm finding JDBCClient but something is going wrong on line 42

    Any thoughts to share ?

     

    execute(getDriverConnection(args[0], args[1], args[2]), args[3]);

    System.out.println("-----------------------------------");
    System.out.println("Executing using the TeiidDataSource");
      // this is showing how to make a Data Source connection.
      execute(getDataSourceConnection(args[0], args[1], args[2]), args[3]);
    }

    static Connection getDriverConnection(String host, String port, String vdb) throws Exception {
      String url = "jdbc:teiid:"+vdb+"@mm://"+host+":"+port+";showplan=on"; //note showplan setting
      Class.forName("org.teiid.jdbc.TeiidDriver");

     

    C:\jboss-as-7.1.1.Final\docs\teiid\examples\simpleclient>set
    CLASSPATH=.;C:\Program Files\Java\jre1.6.0_07\lib\ext\QTJava.zip;C:\Program File
    s\Java\jre6\lib\ext\QTJava.zip;C:\teiid-7.7.0.Final-jboss-dist\lib;c:\jboss-as-7
    .1.1.Final\lib
    CLIENT_PATH=.
    JAVA_HOME=C:\Program Files\Java\jre6
    TEIID_PATH=../../lib/teiid-7.7.0.Final-client.jar

    C:\jboss-as-7.1.1.Final\docs\teiid\examples\simpleclient>dir
    Volume in drive C is OSDisk
    Volume Serial Number is 925A-C21A

    Directory of C:\jboss-as-7.1.1.Final\docs\teiid\examples\simpleclient

    07/10/2012  09:35 AM    <DIR>          .
    07/10/2012  09:35 AM    <DIR>          ..
    05/02/2012  02:46 PM             3,838 JDBCClient.class
    05/02/2012  02:46 PM             3,470 JDBCClient.java
    05/02/2012  02:46 PM               651 README.txt
    02/27/2012  10:13 AM               205 run.bat
    05/02/2012  02:46 PM               334 run.sh
                   5 File(s)        576,612 bytes
                   2 Dir(s)  138,177,417,216 bytes free

     

    C:\jboss-as-7.1.1.Final\docs\teiid\examples\simpleclient>java JDBCClient localho
    st 31000 dynamicportfolio "Select * from Accounts"
    Executing using the TeiidDriver
    Exception in thread "main" java.lang.ClassNotFoundException: org.teiid.jdbc.Teii
    dDriver
            at java.net.URLClassLoader$1.run(Unknown Source)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
            at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
            at java.lang.Class.forName0(Native Method)
            at java.lang.Class.forName(Unknown Source)
            at JDBCClient.getDriverConnection(JDBCClient.java:52)
            at JDBCClient.main(JDBCClient.java:42)

  • 7. Re: Teiid 8.0 JDBC JAR download not found
    Steven Hawkins Master

    Al,

     

    It looks like your are trying to run a teiid 7.7 instance in AS 7.1.1. That will not work.  If you use Teiid 8, then you'll see that the TEIID_PATH will reference our module jar and not look in the lib path, which no longer exists in AS 7.

     

    Steve