1 2 Previous Next 23 Replies Latest reply on Oct 23, 2014 11:04 AM by Steven Hawkins

    error with jdbc

    Alexander Frieden Newbie

      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? 

        • 1. Re: error with jdbc
          Van Halbert Master

          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

          • 2. Re: error with jdbc
            Alexander Frieden Newbie

            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!

            • 3. Re: error with jdbc
              Van Halbert Master

              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..

              • 4. Re: error with jdbc
                Alexander Frieden Newbie

                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!

                • 5. Re: error with jdbc
                  Ramesh Reddy Master

                  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..

                  • 6. Re: error with jdbc
                    Van Halbert Master

                    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

                    • 7. Re: error with jdbc
                      Alexander Frieden Newbie

                      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!

                      • 8. Re: error with jdbc
                        Alexander Frieden Newbie

                        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!

                        • 9. Re: error with jdbc
                          Alexander Frieden Newbie

                          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.  

                          • 10. Re: Re: error with jdbc
                            Ramesh Reddy Master

                            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..

                            • 11. Re: Re: error with jdbc
                              Ramesh Reddy Master

                              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?

                              • 12. Re: Re: error with jdbc
                                Alexander Frieden Newbie

                                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")

                                • 13. Re: Re: error with jdbc
                                  Ramesh Reddy Master

                                  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

                                  • 14. Re: Re: Re: error with jdbc
                                    Alexander Frieden Newbie

                                    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.  

                                    1 2 Previous Next