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

[drikus]

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.

[drikus]

Found the problem.

I bungled the data source configuration in the file:<path>\jboss-as-7.1.1.Final\standalone\configuration\standalone-teiid.xml for the XML source, by getting my XML tags inconsistent as a result of heeding to the comment, at the top of the example file: "<!-- If susbsytem is already defined, only copy the contents under it and edit to suit your needs -->".

Don't bother with copying the snippet to suit what you find in "standalone-teiid.xml", just copy all of it over the heading in that file, given you have no other resource -adapters that may be overwritten.

Squirrel, is squirreling just fine now!