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

Ramesh -

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

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

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)

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

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)

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