-
1. Re: Error connecting to Teiid(VDB) using JDBC
rareddy Oct 24, 2012 10:45 AM (in response to sarik)Sarik,
You are using Metamatrix jdbc driver to connect to the Teiid. Metamatrix is so last year... Update the JDBC driver for Teiid in your classpath. EDS is much more improved product, if you have not moved to Redhat EDS I highly recommend moving to EDS from Metamatrix.
Also, if you are a customer, I suggest using the Redhat support lines, as they can provide you timely support.
Thanks.
Ramesh..
-
2. Re: Error connecting to Teiid(VDB) using JDBC
rareddy Oct 24, 2012 10:48 AM (in response to sarik)Sarik,
If your exception is not like above what Rakesh had, what is exception you see?
Ramesh..
-
3. Re: Error connecting to Teiid(VDB) using JDBC
sarik Oct 24, 2012 12:44 PM (in response to rareddy)Hello Ramesh,
I am using the Jdbc Teiid driver which is something like Teiid-Final-Client.jar and I am not using metamatrix jar.. My Exception is same as that of Rakesh, which is connection refused ::::Error establishing socket to host and port: lonrs08433:31000. Reason: Connection refused: connect..
What could be the possible reason for this as the connection is running fine when I am trying to connect to a VDB locally but when I deployed the VDB onto a different server it is throwing this error.
My server hostname is lonrs08433 , My JBoss is runnng on port 8280... I am assuming the teiid is by default connectiong to jdbc api on port 31000..I am using userName = user and Password = user and my VDB name is Organisation..
I am making a connection url as ::
jdbc:teiid:Organisation@mm://lonrs08433:31000Plz suggest....
Thanks
Sarik
-
4. Re: Error connecting to Teiid(VDB) using JDBC
van.halbert Oct 24, 2012 1:31 PM (in response to sarik)Can you open up your teiid client jar and tell me what packages are there?
Thanks.
Van
-
5. Re: Error connecting to Teiid(VDB) using JDBC
rareddy Oct 24, 2012 1:57 PM (in response to sarik)Sarik,
By default JBoss AS starts on localhost or 127.0.0.1. You need to make sure it runs on "ionrs08433", to do that you can start the server as
./standalone.xml -c standalone-teiid.xml -b ionrs08433
as per the port, open the standalone-teiid.xml before the server started and find "teiid-jdbc" property and change port to there if you need to run anything other than 31000. Otherwise leave this as is. Your URL points to 31000. This port is separate from the JBoss AS http port.
once the server started then you can connect remotely.
Ramesh..
-
6. Re: Error connecting to Teiid(VDB) using JDBC
sarik Oct 24, 2012 2:42 PM (in response to rareddy)Hi Ramesh,
Thanks for the reply.. but I am starting the JBoss AS as ./run.sh -b lonrs08433 only.. By the way I am using JBoss As 5.1.0 and Teiid 7.4.0 so I don't think I am able to see the file standalone-teiid.xml..
One thing Ramesh, my remote server is the unix server (lonrs08433), so when trying ti connect to that server where I am supposd to give the server credentials apart from the teiid credentials "user" and "user"??
-
7. Re: Error connecting to Teiid(VDB) using JDBC
rareddy Oct 24, 2012 3:25 PM (in response to sarik)In Teiid 7.4, for configuration file see <jboss-as>/server/default/deploy/teiid/teiid-jboss-beans.xml file. standalone-teiid.xml file is for Teiid 8.x. I recommend you move to Teiid 8.x, otherwise atleast to Teiid 7.7.
The Teiid credentials are in file <jboss-as>/server/default/conf/props/teiid-security-users.properties file. You do not need your server credentials. I am thinking, your unix server has firewall running on it, and the port 31000 is being blocked. So work with your admin to open the port in firewall rules.
Ramesh..
-
8. Re: Error connecting to Teiid(VDB) using JDBC
sarik Oct 25, 2012 4:15 AM (in response to rareddy)Hello,
What i have found is After I have generated a VDB using Designer and deployed it , I hot deployed the generated VDB onto the server and also copied the *-ds.xml file in the deploy directory of JBoss AS. But in admin console of JBoss AS , i found that the VDB is in the inactive state because the error is showing "the data source file is not accessible". But i have copied the data source file.
So where am I going wrong....
Thanks
Sarik
-
9. Re: Error connecting to Teiid(VDB) using JDBC
rareddy Oct 25, 2012 9:29 AM (in response to sarik)Check the logs, the exception should have given the reason why it is not connecting to the source. Check the URL, user id and password etc.
-
10. Re: Error connecting to Teiid(VDB) using JDBC
sarik Oct 30, 2012 5:15 AM (in response to rareddy)Hi Ramesh,
Thanks for your reply. I am now able to connect successfully. The error was ,the teiid jdbc connection was listening to the port 31300 instead of 31000 when i run my jboss.
Now one more question, in order to connect, I want teiid-7.7.0.Final-client.jar which for the time being is added manually into the build path. I want to make it the part of the maven process for my project. I can't see what groupId and artifactId entry I should place in my pom.xml. + I can't see teiid-7.7.0.Final-client.jar in the maven repository. So how can i do this task. Any suggestions??
Thanks
Sarik
-
11. Re: Error connecting to Teiid(VDB) using JDBC
rareddy Oct 30, 2012 8:26 AM (in response to sarik)Sarik,
They should be in the JBoss Nexus maven reporitory
https://repository.jboss.org/nexus/index.html#nexus-search;quick~teiid
Ramesh..