1 Reply Latest reply on Sep 7, 2012 8:31 AM by Drikus Roux

    Teiid 8.1-Connect to VDB [Quick Start]: Error establishing socket to host and port: localhost:31000. Reason: Connection refused

    Drikus Roux Newbie

      Hello,

       

      I have followed the [quick start] (connect to VDB through JDBC), and tried it unsuccessfully, with the message: "TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: Connection refused: connect".

       

      I have turned off the virus-checker, and the fire-wall, to no avail.  The URL is: jdbc:teiid:DynamicPortfolio@mm://localhost:31000, and I am blindly assuming the port and the credentials, as those in the example.

       

      I am using Windows 7, Teiid 8.1, with JBoss 7.1.1 and JRE6.  I verified that the Deployments are visible in the JBoss adminstration console, for the jdbc driver and vdb.  There is a comment, in the quick-start: you will see an informational message in the JBoss AS 7.1 console that the VDB has been deployed and in "active" state , which is something I don't see.  My list is different, and as follows:

       

      11:16:44,994 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-ws.rar"

      11:16:44,995 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-salesforce.rar"

      11:16:44,996 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-ldap.rar"

      11:16:44,996 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-file.rar"

      11:16:44,997 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-8.1.0.Final-jdbc.jar"

      11:16:44,998 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "portfolio-vdb.xml"

       

      I am assuming that JBoss starts an instance of the teiid run-time, when it fires up.  The VDB should thence be in a state, ready to accept incoming connections.

       

      In Squirrel, after configuring the driver, I get a message: "Driver class org.teiid.jdbc.TeiidDriver successfully registered for driver definition: TEIID-VD", so I am assuming the driver is aligned to its jar, and ready to access the VDB.  This driver, I consequently use, by employing the above mentioned URL, with credentials user/ user, which results in the said error message.  This is also the case, when executing the run script in the folder; <jboss-install>/docs/teiid/examples/simpleclient.

       

      Am I missing something obvious?

       

      You help is appreciated.