Unable to connect Teradata Studio Express 14.10.01/15.00.02 to JBoss Teiid 8.4.1 using Teiid's JDBC drivers

Teradata Studio
Enthusiast

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.

4 REPLIES
Enthusiast

Re: Unable to connect Teradata Studio Express 14.10.01/15.00.02 to JBoss Teiid 8.4.1 using Teiid's JDBC drivers

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

Teradata Employee

Re: Unable to connect Teradata Studio Express 14.10.01/15.00.02 to JBoss Teiid 8.4.1 using Teiid's JDBC drivers

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

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.

Enthusiast

Re: Unable to connect Teradata Studio Express 14.10.01/15.00.02 to JBoss Teiid 8.4.1 using Teiid's JDBC drivers

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.

Enthusiast

Re: 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,

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.