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