-
1. Re: Teiid 8.0 JDBC JAR download not found
rareddy May 3, 2012 11:34 PM (in response to ceefour)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
Ramesh..
-
2. Re: Teiid 8.0 JDBC JAR download not found
carvalho27 Jun 26, 2012 3:41 PM (in response to rareddy)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
rareddy Jun 26, 2012 10:31 PM (in response to carvalho27)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
carvalho27 Jun 27, 2012 7:01 AM (in response to rareddy)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
rareddy Jun 27, 2012 8:06 AM (in response to carvalho27)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
carvalho27 Jul 11, 2012 7:31 PM (in response to rareddy)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.jarC:\jboss-as-7.1.1.Final\docs\teiid\examples\simpleclient>dir
Volume in drive C is OSDisk
Volume Serial Number is 925A-C21ADirectory 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 freeC:\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
shawkins Jul 12, 2012 10:16 AM (in response to carvalho27)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