3 Replies Latest reply on Dec 9, 2015 10:23 AM by rareddy

Not able to connect to teiid server through AdminApi

nish18 Dec 8, 2015 8:37 AM

Hi Everyone. I am facing problem while using AdminApi from my test api to deploy VDB which needs to connect to teiid server. ( I tried different methods also other than deploy)

But Its throwing connection exception.

I am currently using teiid 7.7 version on JBOSS AS 5.1.

Please help me on this.

Exception in thread "main" org.teiid.poc.AdminApiClientException: TEIID70015 java.io.IOException: java.net.ConnectException: JBAS012144: Could not connect to remote://localhost:9999. The connection timed out

I tried passing different ports like :8080 ,9999,31443. and Hostname as 127.0.0.1, still getting same error

please find snippet of my code :

CallbackHandler cbh = new AuthenticationCallbackHandler("admin", "admin".toCharArray());

this.admin = AdminFactory.getInstance().createAdmin(ModelControllerClient.Factory.create(localhost, 9999,cbh));

final Properties p = new Properties();

p.setProperty("class-name","org.teiid.resource.adapter.file.FileManagedConnectionFactory");

p.setProperty("pool-name", "marketdata-file");

p.setProperty("max-pool-size", "4");

p.setProperty("enabled", "true");

p.setProperty("use-java-context", "true");

p.setProperty("ParentDirectory", "../data/");

p.setProperty("AllowParentPaths", "true");

this.admin.createDataSource("java:/marketdata-file3", "file", p);

I am getting exception at last line of code.

1. Re: Not able to connect to teiid server through AdminApi

rareddy Dec 8, 2015 9:16 AM (in response to nish18)

Teiid 7.7 such a old version, I had to download and documents and dig through

The URL will be in the form "mm://localhost:34413"

I am not sure if the above code is correct but you can see this for getting the connection teiid/AdminFactory.java at 7.7.x · rareddy/teiid · GitHub

Port 9999, came into existence with Teiid 8.0, so I am sure mixing the code a bit, and management API in 7.x line was completely different from 8.x. But above link should give you starting point.
Actions
2. Re: Not able to connect to teiid server through AdminApi

nish18 Dec 9, 2015 8:38 AM (in response to rareddy)

Thanks Ramesh.

I was able to connect. But I am facing some different problem.

I have only one data source currently. i.e MYSQL . I created VDB layer of that.
When I directly queried on MYSQL DB , I am able to fetch primary key as expected using ResultSet rs = metadata.getPrimaryKeys(null, null, "employee");

But while performing same thing on VirtualDB , I am getting null value for that.
ResultSet rs = metadata.getPrimaryKeys("aakash_test", "user@teiid-security", "employee"); with parameter and
for without parameters ResultSet rs = metadata.getPrimaryKeys(null, null, "employee"); without parameters

on teiid-7.7.0.Final-client and jboss-5.1.0.GA.

I know some jdbc methods are not supported for teiid. But I dont see metadata.getPrimaryKeys() methods in that list.
http://docs.jboss.org/teiid/7.7.0.Final/client-developers-guide/en-US/html/unsupported_jdbc.html

Thanks in advance .
Actions
3. Re: Not able to connect to teiid server through AdminApi

rareddy Dec 9, 2015 10:23 AM (in response to nish18)

It depends on how you imported your mysql model, and that has the PK information specified on it. Then it will work. Take look at the System tables and see if the information is present.
Actions

Go to original post