error with jdbc

[afrieden]

Hi, trying to test out my vdb and got the following:

$ /tools/groovy/groovy-1.8.5/bin/groovy -classpath teiid-8.8.1-jdbc.jar testJdbc.groovy

Caught: groovy.lang.MissingPropertyException: No such property: Sql for class: testJdbc

groovy.lang.MissingPropertyException: No such property: Sql for class: testJdbc

  at testJdbc.run(testJdbc.groovy:1)

[afrieden@node013 jar]$ vi testJdbc.groovy

[afrieden@node013 jar]$ /tools/groovy/groovy-1.8.5/bin/groovy -classpath teiid-8.8.1-jdbc.jar testJdbc.groovy

Oct 12, 2014 10:50:57 AM org.teiid.jdbc.TeiidDriver connect

SEVERE: Could not create connection

org.teiid.jdbc.TeiidSQLException: TEIID20014 The required socket url format is mm[s]://server1:port1[,server2:port2]

  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)

  at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56)

  at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

  at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)

  at java.sql.DriverManager.getConnection(DriverManager.java:582)

  at java.sql.DriverManager.getConnection(DriverManager.java:185)

  at groovy.sql.Sql.newInstance(Sql.java:286)

  at groovy.sql.Sql.newInstance(Sql.java:307)

  at groovy.sql.Sql$newInstance.call(Unknown Source)

  at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42)

  at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108)

  at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128)

  at testJdbc.run(testJdbc.groovy:3)

  at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266)

  at groovy.lang.GroovyShell.run(GroovyShell.java:229)

  at groovy.lang.GroovyShell.run(GroovyShell.java:159)

  at groovy.ui.GroovyMain.processOnce(GroovyMain.java:550)

  at groovy.ui.GroovyMain.run(GroovyMain.java:337)

  at groovy.ui.GroovyMain.process(GroovyMain.java:323)

  at groovy.ui.GroovyMain.processArgs(GroovyMain.java:120)

  at groovy.ui.GroovyMain.main(GroovyMain.java:100)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

  at java.lang.reflect.Method.invoke(Method.java:597)

  at org.codehaus.groovy.tools.GroovyStarter.rootLoader(GroovyStarter.java:108)

  at org.codehaus.groovy.tools.GroovyStarter.main(GroovyStarter.java:130)

Caused by: org.teiid.net.ConnectionException: TEIID20014 The required socket url format is mm[s]://server1:port1[,server2:port2]

  at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:297)

  at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)

  ... 25 more

Caused by: java.net.MalformedURLException: The required socket url format is mm[s]://server1:port1[,server2:port2]

  at org.teiid.net.TeiidURL.<init>(TeiidURL.java:126)

  at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:295)

  ... 26 more

Caught: org.teiid.jdbc.TeiidSQLException: TEIID20014 The required socket url format is mm[s]://server1:port1[,server2:port2]

org.teiid.jdbc.TeiidSQLException: TEIID20014 The required socket url format is mm[s]://server1:port1[,server2:port2]

  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)

  at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56)

  at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

  at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)

  at testJdbc.run(testJdbc.groovy:3)

Caused by: org.teiid.net.ConnectionException: TEIID20014 The required socket url format is mm[s]://server1:port1[,server2:port2]

  at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:297)

  at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)

  ... 3 more

Caused by: java.net.MalformedURLException: The required socket url format is mm[s]://server1:port1[,server2:port2]

  at org.teiid.net.TeiidURL.<init>(TeiidURL.java:126)

  at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:295)

  ... 4 more

Here is my code:

import groovy.sql.Sql

def teiidDb = Sql.newInstance("jdbc:teiid:mongodb@mm[s]:localhost:31000;version=1","user","password","org.teiid.jdbc.TeiidDriver")

String query = "SELECT * FROM records LIMIT 5";

def rows = teiidDb.rows(query)

Any thoughts? 

[van.halbert]

The driver connection format (Driver Connection - Teiid 8.9 (draft) - Project Documentation Editor) is:

jdbc:teiid:<vdb-name>@mm[s]://<host>:<port>;[prop-name=prop-value;]*

which appears you are missing the slashes, so yours would be:

jdbc:teiid:mongodb@mm://localhost:31000;version=1

or the following if you are using SSL:

jdbc:teiid:mongodb@mms://localhost:31000;version=1

[afrieden]

Thanks changed to

def teiidDb = Sql.newInstance("jdbc:teiid:mongodb@mm://localhost:31000;version=1","user","password","org.teiid.jdbc.TeiidDriver")

Where mongodb is the name in my model and vdb and source.  Now getting connection refused. 

SEVERE: Could not create connection

org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: Connection refused

Any thoughts?  Thanks!

[van.halbert]

Did you added the user/password to the teiid-security-users.properties file on the server?

By default server binds to 127.0.0.1. You need to start the server with -b option like

./standalone.sh -b <ip>

or

./standalone.sh -b 0.0.0.0

Then you can connect using the ip of the machine or the DNS resolvable name.

Please note the above still does not open the management port, if you connect it from Designer you will still see issues. You can address that by

./standalone.sh -c standalone-teiid.xml -b 0.0.0.0 -Djboss.bind.address.management=0.0.0.0

or manually editing the property value in the standalone-teiid.xml file

Van..

[afrieden]

Not using designer so won't be a problem.  Username and password was added using jboss/bin/add-user.sh

I want the server to bind to localhost so I don't need to add the -b tag right?  Is there any way to see a log of when I try to connect to the vdb?  Thanks!

[rareddy]

Not using "-b" option is OK when your client and server are on the same machine as server will open ports on "localhost", if you are accessing remotely then we need -b and specify the IP or 0.0.0.0 to bind on all ports. From the exception, it looks like it is the bind issue, thus Van's recommendation.

Yes, you open server.log in the "logs" directory to see the logs.

Ramesh..

[van.halbert]

Alexander,

As for needing to add -b,   it depends on how your /etc/hosts file is configured (as a starting point).   Does it have an entry similar to:   127.0.0.1 localhost

As for seeing a log when you connect, turn on audit logging (see:  Logging - Teiid 8.8 - Project Documentation Editor) and you should see an entry.

Van

[afrieden]

So it seems it is because it didn't deploy, log is giving this error:

06:34:07,026 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-22)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

06:34:07,490 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-3)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

06:34:07,520 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/17/14 6:34 AM

06:34:07,559 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 1)  TEIID50036 VDB vcf.1 model "vcf" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "CREATE FOREIGN TABLE[*]\u00a0[*] Record (" at line 3, column 21.

Lexical error. Character is not a valid token:   : TEIID30481 Failed to find the Connection Factory with JNDI name java:/mongoDS. Please check the name or deploy the Connection Factory with specified name.

06:34:07,605 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2)  JBAS018559: Deployed "mongodb-vdb.xml" (runtime-name : "mongodb-vdb.xml")

Even though it seems like it is deployed i.e. getting mongodb-vdb.xml.deployed.  So what is going on here?  Thanks!

[afrieden]

Found the character it didn't like, now the log is complaining:

14:17:18,651 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

14:17:18,736 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-16)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

14:17:18,738 INFO  [org.teiid.RUNTIME] (MSC service thread 1-16)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/19/14 2:17 PM

14:17:18,741 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  TEIID50030 VDB vcf.1 model "vcf" metadata loaded. End Time: 10/19/14 2:17 PM

14:17:18,743 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  Data Source java:/mongoDS not accessible.

14:17:18,743 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 3)  TEIID40003 VDB vcf.1 is set to ACTIVE

14:17:18,758 INFO  [org.jboss.as.server] (management-handler-thread - 4)  JBAS018559: Deployed "mongodb-vdb.xml" (runtime-name : "mongodb-vdb.xml")

How do you make the data source java:/mongoDS available?  Is this just a placeholder for something else?   Thanks!

[afrieden]

Fixed the jndi, but stil not able to query it.  Port is at 31000, not sure why I am getting connection refused. 

SEVERE: Could not create connection

org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: Connection refused

  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)

  at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56)

  at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

  at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)

  at java.sql.DriverManager.getConnection(DriverManager.java:582)

  at java.sql.DriverManager.getConnection(DriverManager.java:185)

  at groovy.sql.Sql.newInstance(Sql.java:286)

  at groovy.sql.Sql.newInstance(Sql.java:307)

  at groovy.sql.Sql$newInstance.call(Unknown Source)

  at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42)

  at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108)

  at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128)

  at connect.run(connect.groovy:2)

  at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266)

  at groovy.lang.GroovyShell.run(GroovyShell.java:229)

  at groovy.lang.GroovyShell.run(GroovyShell.java:159)

  at groovy.ui.GroovyMain.processOnce(GroovyMain.java:550)

  at groovy.ui.GroovyMain.run(GroovyMain.java:337)

  at groovy.ui.GroovyMain.process(GroovyMain.java:323)

  at groovy.ui.GroovyMain.processArgs(GroovyMain.java:120)

  at groovy.ui.GroovyMain.main(GroovyMain.java:100)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

  at java.lang.reflect.Method.invoke(Method.java:597)

  at org.codehaus.groovy.tools.GroovyStarter.rootLoader(GroovyStarter.java:108)

  at org.codehaus.groovy.tools.GroovyStarter.main(GroovyStarter.java:130)

Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: Connection refused

  at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161)

  at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)

  at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316)

  at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)

  ... 25 more

Caused by: java.net.ConnectException: Connection refused

  at java.net.PlainSocketImpl.socketConnect(Native Method)

  at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)

  at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)

  at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)

  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

  at java.net.Socket.connect(Socket.java:525)

  at java.net.Socket.connect(Socket.java:475)

  at org.teiid.net.socket.OioOjbectChannelFactory.createObjectChannel(OioOjbectChannelFactory.java:178)

  at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:94)

  at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277)

  at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239)

  at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)

  ... 28 more

Caught: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: Connection refused

org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: Connection refused

  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)

  at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56)

  at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

  at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)

  at connect.run(connect.groovy:2)

Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: Connection refused

  at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161)

  at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)

  at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316)

  at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)

  ... 3 more

Caused by: java.net.ConnectException: Connection refused

  at org.teiid.net.socket.OioOjbectChannelFactory.createObjectChannel(OioOjbectChannelFactory.java:178)

  at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:94)

  at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277)

  at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239)

  at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)

  ... 6 more

Any help is greatly appreciated.  

[rareddy]

To create a datasource for MongoDB in JBoss EAP, edit standalone-teiid.xml and add following in resource-adapters subsystem.

        <resource-adapter id="mongodb">
            <module slot="main" id="org.jboss.teiid.resource-adapter.mongodb"/>
            <transaction-support>NoTransaction</transaction-support>
            <connection-definitions>
                <connection-definition class-name="org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory"
                        jndi-name="java:/mongoDS"
                        enabled="true"
                        use-java-context="true"
                        pool-name="teiid-mongodb-ds">
                       
                      <!-- MongoDB server list (host:port[;host:port...]) -->
                      <config-property name="RemoteServerList">localhost:27017</config-property>
                      <!-- Database Name in the MongoDB -->
                      <config-property name="Database">test</config-property>
                        <!--
                            Uncomment these properties to supply user name and password
                        <config-property name="Username">user</config-property>
                        <config-property name="Password">user</config-property>
                        --> 
                </connection-definition>
            </connection-definitions>
        </resource-adapter>

Provide correct host and port for your MongoDB instance. 

Ramesh..

[rareddy]

In your "logs" directory you will find server.log file, attach it to check what may be your connection issue. Did you try "-b" option as Van suggested?

[afrieden]

My teiid instance and my script are all on the same server.  Everything is on localhost except for my mongodb instance which has the correct ip address.  Below is my server.log.

I have also noticed another issue, when I redeploy, the standalone-teiid.xml seems to go back to default.  Is this expected?

14:02:00,239 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-39)  TEIID40120 VDB vcf.1 will be removed from the repository

14:02:00,257 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-39)  TEIID40119 VDB vcf.1 removed from the repository

14:02:00,271 INFO  [org.teiid.RUNTIME] (MSC service thread 1-39)  TEIID50026 VDB "vcf.1[vcf{vcf=vcf, mongodb, java:/mongoDS}]" undeployed.

14:02:00,309 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-22)  TEIID40120 VDB vcf.1 will be removed from the repository

14:02:00,369 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-14)  JBAS015877: Stopped deployment mongodb-vdb.xml (runtime-name: mongodb-vdb.xml) in 158ms

14:02:00,371 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-13)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

14:02:00,449 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-39)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

14:02:00,450 INFO  [org.teiid.RUNTIME] (MSC service thread 1-39)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/19/14 2:02 PM

14:02:00,454 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2)  TEIID50030 VDB vcf.1 model "vcf" metadata loaded. End Time: 10/19/14 2:02 PM

14:02:00,459 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2)  Data Source java:/mongoDS not accessible.

14:02:00,459 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 2)  TEIID40003 VDB vcf.1 is set to ACTIVE

14:02:00,473 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1)  JBAS018565: Replaced deployment "mongodb-vdb.xml" with deployment "mongodb-vdb.xml"

14:09:50,861 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5)  TEIID40120 VDB vcf.1 will be removed from the repository

14:09:50,863 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5)  TEIID40119 VDB vcf.1 removed from the repository

14:09:50,866 INFO  [org.teiid.RUNTIME] (MSC service thread 1-5)  TEIID50026 VDB "vcf.1[vcf{vcf=vcf, mongodb, java:/mongoDS}]" undeployed.

14:09:50,868 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-16)  TEIID40120 VDB vcf.1 will be removed from the repository

14:09:50,880 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-11)  JBAS015877: Stopped deployment mongodb-vdb.xml (runtime-name: mongodb-vdb.xml) in 20ms

14:09:50,900 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2)  JBAS018558: Undeployed "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

14:17:18,649 INFO  [org.jboss.as.repository] (management-handler-thread - 4)  JBAS014900: Content added at location /opt/jboss/standalone/data/content/69/620cb8b5b09404843e175ec135f5097a986680/content

14:17:18,651 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

14:17:18,736 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-16)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

14:17:18,738 INFO  [org.teiid.RUNTIME] (MSC service thread 1-16)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/19/14 2:17 PM

14:17:18,741 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  TEIID50030 VDB vcf.1 model "vcf" metadata loaded. End Time: 10/19/14 2:17 PM

14:17:18,743 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  Data Source java:/mongoDS not accessible.

14:17:18,743 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 3)  TEIID40003 VDB vcf.1 is set to ACTIVE

14:17:18,758 INFO  [org.jboss.as.server] (management-handler-thread - 4)  JBAS018559: Deployed "mongodb-vdb.xml" (runtime-name : "mongodb-vdb.xml")

14:21:31,400 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-9)  TEIID40120 VDB vcf.1 will be removed from the repository

14:21:31,403 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-9)  TEIID40119 VDB vcf.1 removed from the repository

14:21:31,405 INFO  [org.teiid.RUNTIME] (MSC service thread 1-9)  TEIID50026 VDB "vcf.1[vcf{vcf=vcf, mongodb, java:/mongoDS}]" undeployed.

14:21:31,407 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-44)  TEIID40120 VDB vcf.1 will be removed from the repository

14:21:31,419 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-48)  JBAS015877: Stopped deployment mongodb-vdb.xml (runtime-name: mongodb-vdb.xml) in 22ms

14:21:31,422 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

14:21:31,476 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-30)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

14:21:31,478 INFO  [org.teiid.RUNTIME] (MSC service thread 1-30)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/19/14 2:21 PM

14:21:31,481 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4)  TEIID50030 VDB vcf.1 model "vcf" metadata loaded. End Time: 10/19/14 2:21 PM

14:21:31,482 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4)  Data Source java:/mongoDS not accessible.

14:21:31,483 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 4)  TEIID40003 VDB vcf.1 is set to ACTIVE

14:21:31,497 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1)  JBAS018565: Replaced deployment "mongodb-vdb.xml" with deployment "mongodb-vdb.xml"

14:22:46,568 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-25)  TEIID40120 VDB vcf.1 will be removed from the repository

14:22:46,570 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-25)  TEIID40119 VDB vcf.1 removed from the repository

14:22:46,572 INFO  [org.teiid.RUNTIME] (MSC service thread 1-25)  TEIID50026 VDB "vcf.1[vcf{vcf=vcf, mongodb, java:/mongoDS}]" undeployed.

14:22:46,574 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-23)  TEIID40120 VDB vcf.1 will be removed from the repository

14:22:46,644 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-11)  JBAS015877: Stopped deployment mongodb-vdb.xml (runtime-name: mongodb-vdb.xml) in 78ms

14:22:46,646 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-29)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

14:22:46,729 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-42)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

14:22:46,749 INFO  [org.teiid.RUNTIME] (MSC service thread 1-42)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/19/14 2:22 PM

14:22:46,752 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1)  TEIID50030 VDB vcf.1 model "vcf" metadata loaded. End Time: 10/19/14 2:22 PM

14:22:46,753 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1)  Data Source java:/mongoDS not accessible.

14:22:46,753 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 1)  TEIID40003 VDB vcf.1 is set to ACTIVE

14:22:46,771 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2)  JBAS018565: Replaced deployment "mongodb-vdb.xml" with deployment "mongodb-vdb.xml"

14:24:01,865 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-45)  TEIID40120 VDB vcf.1 will be removed from the repository

14:24:01,892 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-45)  TEIID40119 VDB vcf.1 removed from the repository

14:24:01,894 INFO  [org.teiid.RUNTIME] (MSC service thread 1-45)  TEIID50026 VDB "vcf.1[vcf{vcf=vcf, mongodb, java:/mongoDS}]" undeployed.

14:24:01,897 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-45)  TEIID40120 VDB vcf.1 will be removed from the repository

14:24:01,940 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-33)  JBAS015877: Stopped deployment mongodb-vdb.xml (runtime-name: mongodb-vdb.xml) in 78ms

14:24:01,959 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1)  JBAS018558: Undeployed "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

14:26:12,698 INFO  [org.jboss.as.repository] (management-handler-thread - 8)  JBAS014900: Content added at location /opt/jboss/standalone/data/content/27/9088e257c2880f495d95612168b9f552176e4c/content

14:26:12,701 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-26)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

14:26:12,779 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-26)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

14:26:12,780 INFO  [org.teiid.RUNTIME] (MSC service thread 1-26)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/19/14 2:26 PM

14:26:12,784 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2)  TEIID50030 VDB vcf.1 model "vcf" metadata loaded. End Time: 10/19/14 2:26 PM

14:26:12,785 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2)  Data Source java:/mongoDS not accessible.

14:26:12,786 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 2)  TEIID40003 VDB vcf.1 is set to ACTIVE

14:26:12,797 INFO  [org.jboss.as.server] (management-handler-thread - 8)  JBAS018559: Deployed "mongodb-vdb.xml" (runtime-name : "mongodb-vdb.xml")

14:26:42,120 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-14)  TEIID40120 VDB vcf.1 will be removed from the repository

14:26:42,121 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-14)  TEIID40119 VDB vcf.1 removed from the repository

14:26:42,123 INFO  [org.teiid.RUNTIME] (MSC service thread 1-14)  TEIID50026 VDB "vcf.1[vcf{vcf=vcf, mongodb, java:/mongoDS}]" undeployed.

14:26:42,126 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-32)  TEIID40120 VDB vcf.1 will be removed from the repository

14:26:42,133 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-26)  JBAS015877: Stopped deployment mongodb-vdb.xml (runtime-name: mongodb-vdb.xml) in 15ms

14:26:42,136 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-36)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

14:26:42,182 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

14:26:42,183 INFO  [org.teiid.RUNTIME] (MSC service thread 1-15)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/19/14 2:26 PM

14:26:42,186 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  TEIID50030 VDB vcf.1 model "vcf" metadata loaded. End Time: 10/19/14 2:26 PM

14:26:42,187 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  Data Source java:/mongoDS not accessible.

14:26:42,188 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 3)  TEIID40003 VDB vcf.1 is set to ACTIVE

14:26:42,193 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1)  JBAS018565: Replaced deployment "mongodb-vdb.xml" with deployment "mongodb-vdb.xml"

16:59:52,850 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-9)  TEIID40120 VDB vcf.1 will be removed from the repository

16:59:52,851 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-9)  TEIID40119 VDB vcf.1 removed from the repository

16:59:52,853 INFO  [org.teiid.RUNTIME] (MSC service thread 1-9)  TEIID50026 VDB "vcf.1[vcf{vcf=vcf, mongodb, java:/mongoDS}]" undeployed.

16:59:52,855 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-42)  TEIID40120 VDB vcf.1 will be removed from the repository

16:59:52,865 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3)  JBAS015877: Stopped deployment mongodb-vdb.xml (runtime-name: mongodb-vdb.xml) in 18ms

16:59:52,866 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-11)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

16:59:52,914 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-21)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

16:59:52,915 INFO  [org.teiid.RUNTIME] (MSC service thread 1-21)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/19/14 4:59 PM

16:59:52,918 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4)  TEIID50030 VDB vcf.1 model "vcf" metadata loaded. End Time: 10/19/14 4:59 PM

16:59:52,920 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 4)  TEIID40003 VDB vcf.1 is set to ACTIVE

16:59:52,932 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1)  JBAS018565: Replaced deployment "mongodb-vdb.xml" with deployment "mongodb-vdb.xml"

17:00:02,946 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-44)  TEIID40120 VDB vcf.1 will be removed from the repository

17:00:02,947 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-44)  TEIID40119 VDB vcf.1 removed from the repository

17:00:02,950 INFO  [org.teiid.RUNTIME] (MSC service thread 1-44)  TEIID50026 VDB "vcf.1[vcf{vcf=vcf, mongodb, java:jboss/datasources/ExampleDS}]" undeployed.

17:00:02,952 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-8)  TEIID40120 VDB vcf.1 will be removed from the repository

17:00:02,961 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-15)  JBAS015877: Stopped deployment mongodb-vdb.xml (runtime-name: mongodb-vdb.xml) in 16ms

17:00:02,976 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1)  JBAS018558: Undeployed "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

17:00:10,091 INFO  [org.jboss.as.repository] (management-handler-thread - 13)  JBAS014900: Content added at location /opt/jboss/standalone/data/content/df/edd7848a2c812e20eec52c9b6ff5881fe252b3/content

17:00:10,094 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-41)  JBAS015876: Starting deployment of "mongodb-vdb.xml" (runtime-name: "mongodb-vdb.xml")

17:00:10,162 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-13)  TEIID40118 VDB vcf.1 added to the repository - is reloading false

17:00:10,164 INFO  [org.teiid.RUNTIME] (MSC service thread 1-13)  TEIID50029 VDB vcf.1 model "vcf" metadata is currently being loaded. Start Time: 10/19/14 5:00 PM

17:00:10,166 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1)  TEIID50030 VDB vcf.1 model "vcf" metadata loaded. End Time: 10/19/14 5:00 PM

17:00:10,167 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 1)  TEIID40003 VDB vcf.1 is set to ACTIVE

17:00:10,180 INFO  [org.jboss.as.server] (management-handler-thread - 13)  JBAS018559: Deployed "mongodb-vdb.xml" (runtime-name : "mongodb-vdb.xml")

[rareddy]

1) What another instance? you need to be specific about your question so that we can follow If there is another instance of JBoss EAP, then you need to stop that version. If you are talking about having "standalone.xml" file, then it does not matter. Also when you start the JBoss EAP, you need to issue

./standalone.sh -c standalone-teiid.xml

or

standalone.bat -c standalone-teiid.xml

2) Your VDB name looks like "vcf" not "mongodb" as you shown in above comments? so you need to fix that in the connection URL.

3) You only gave part of the log, not complete. I wanted to see how you are binding and what are the ports, that information is not there. so delete your server.log, then restart the server and issue the SQL call, then attach the server.log.

PS: please attach log files etc, do not post in the main message as it is hard to read. use advance editor and then you can attach the files

[afrieden]

1)  Sorry Ramesh about the confusion, I will start a new thread for that issue.  There is only one JBoss instance.  It is on the same server as my script to query it.  I have changed the script to:

import groovy.sql.Sql

def teiidDb = Sql.newInstance("jdbc:teiid:vcf@mm://127.0.0.1:31000;version=1","username","password","org.teiid.jdbc.TeiidDriver")

String query = "SELECT * FROM records LIMIT 5";

def rows = teiidDb.rows(query)

2) This should be fixed in my script.  This is the entire server.log from before.  I am still getting the same connection refused error from before.