All Forums Teradata Studio
stavrosk 7 posts Joined 06/14
05 Mar 2015
Unable to connect Teradata Studio Express 14.10.01/15.00.02 to JBoss Teiid 8.4.1 using Teiid's JDBC drivers

Hello all,
We follow the Teradata Studio Express (TSE) wizard trying to connect  to JBoss Dev. Studio 7.1.1.GA (Teiid Runtime ver. 8.4.1-redhat-7) using Teiid's jdbc driver but although the jdbc URL and the rest of the paremeters get setup correctly and the connectivity test comes back succesfull, we get a couple of Eclipse errors and the connection fails.
We experimented with 2 TSE editions, namely, ver 14.10.01 and 15.00.02 and other Teiid jdbc drivers, just in case we get a quick solution to the problem but no luck.
We can't use another 3rd party JDBC/ODBC query tool per customer's request so it must be some edition of TSE.
Any ideas how to either resolve or circumvent this problem will be greatly appreciated.    
Thanks
Stavros K.

stavrosk 7 posts Joined 06/14
05 Mar 2015

The errors we get come into a window titled  "Multiple problems have occurred".
Two errors reported:

Creating SQL Model Connection to New Generic JDBC

 

Error creating SQL Model Connection connection to New Generic JDBC. (Error: null)
java.lang.NullPointerException

 

and

 

Creating connections to New Generic JDBC

 

Could not connect to New Generic JDBC.
Error creating SQL Model Connection connection to New Generic JDBC. (Error: null)
java.lang.NullPointerException
OK

fgrimmer 553 posts Joined 04/09
05 Mar 2015

Stavros, As JBoss Teiid is not one of our supported database servers, I have not tried connecting. Have you followed the steps in thie JBoss guide at http://docs.jboss.org/teiid/7.0.0/client-developers-guide/en-US/html/teiid_connection.html#connection_properties
You will need to create a New Driver Definition on the New Connection Profile page. In the Name/Type tab, give it a unique Driver Name. In the JAR List tab, specifiy the location of the Teiid JDBC library. In the Properties tab, specify the URL for teiid:

jdbc:teiid:<vdb-name>@mm[s]://<host>:<port>;
Specify the Driver Class name. You can use the elipse to choose the class file from the Jar. Specify the User ID and Database Name and any other properties needed.

stavrosk 7 posts Joined 06/14
05 Mar 2015

Hello Francine,
First of all I'd like to thank you for replying to our request. 
The steps as you described them are exactly the process we followed to setup a connection to Teiid from TSE. The only available option for a JDBC Driver was the 'New Generic JDBC' driver which we use to setup the driver definition using Teiid's jdbc driver and then a connection profile that although it had a successfull connectivity ping, there was nothing coming back from Teiid, only the 2 errors we mentioned up above.
Thanks.
 

stavrosk 7 posts Joined 06/14
09 Mar 2015

Hello all,
Thanks to Redhat tech. support and a lady engineer who tried the following that worked perfectly fine. All credit goes to her.
The way to workaround the TSE Generic JDBC issue is to create an "Oracle" connection as a new connection profile, add a new driver, for which you need to select "Other Driver", and set all the correct driver classes and URL. That'll allow TSE to connect to a JBoss Data Virtualization virtual Database.
The connection profile properties showed as follows for us:
Drivers: Other Driver
Database:  yourDBName
URL: jdbc:teiid:yourDBName@mm://JBossDVServerIPAddress:31000;user=preferredUserName;password=preferredPassword
user name: preferredUserName
password: preferredPassword
driver class can be specified manually as org.teiid.jdbc.TeiidDriver
We hope this helps some one else out there.
Thanks
Stavros K.

You must sign in to leave a comment.