Not able to connect to teiid server through AdminApi

[nish18]

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.

[rareddy]

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.

[nish18]

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 .

[rareddy]

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.