13 Replies Latest reply on Apr 6, 2015 9:07 AM by Ramesh Reddy

    "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer

    jiaxing kou Newbie

      Hello,

       

      I've set up JBOSS EAP 6.3 on Ubuntu. I've installed Teiid Designer  in JBoss Developer Studio 7.1.  All I'm trying to do is "Test JDBC Connection" and it gives me the message: unable to establish connection to the jdbc server. "jdbc:teiid:ping@mm//localhost:31000". There are no errors in the log that I can see, and testing the administration connection comes back" ok". I've also started JBoss EAP with the standalone-teiid.xml configuration.

       

      What could be causing this to happen?

       

      Thanks in advance for any help!


      Kou

        • 1. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
          jiaxing kou Newbie

          10:43:19,648 INFO  [org.jboss.as.repository] (management-handler-thread - 17)  JBAS014900: 在位置 /home/kjx/jboss-eap-6.3/standalone/data/content/fc/f324141fb233a0401624dc0982576eb4a8fed2/content 上添加内容

          10:43:19,651 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2)  JBAS015876: 开始 "ping-vdb.xml" 的部署(runtime-name: "ping-vdb.xml")

          10:43:19,683 INFO  [org.teiid.RUNTIME] (MSC service thread 1-5)  TEIID50029 VDB ping.1 model "Foo" metadata is currently being loaded. Start Time: 15-1-22 上午10:43

          10:43:19,684 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  TEIID50030 VDB ping.1 model "Foo" metadata loaded. End Time: 15-1-22 上午10:43

          10:43:19,685 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  TEIID40003 VDB ping.1 is set to ACTIVE

          10:43:19,765 INFO  [org.jboss.as.server] (management-handler-thread - 17)  JBAS018559: 已部署的 "ping-vdb.xml"(runtime-name: "ping-vdb.xml")

          10:43:19,765 INFO  [org.jboss.as.controller] (management-handler-thread - 17)  JBAS014774: 服务状态报告

          JBAS014777: 启动失败的服务:      service jboss.web.deployment.default-host./: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host./: Failed to start service

           

          10:43:19,798 WARN  [org.teiid.SECURITY] (New I/O worker #7) null TEIID40011 Processing exception 'TEIID50072 The username "kjx" and/or password and/or payload token could not be authenticated by any membership domain.' for session null.  Exception type org.teiid.client.security.LogonException thrown from org.teiid.jboss.JBossSessionService.authenticate(JBossSessionService.java:74). Enable more detailed logging to see the entire stacktrace.

          10:43:19,820 INFO  [org.teiid.RUNTIME] (MSC service thread 1-7)  TEIID50026 VDB "ping.1[Foo{s=s, loopback, null}]" undeployed.

          10:43:19,824 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2)  JBAS015877: Stopped deployment ping-vdb.xml (runtime-name: ping-vdb.xml) in 4ms

          10:43:19,898 INFO  [org.jboss.as.repository] (management-handler-thread - 16)  JBAS014901: 在位置 /home/kjx/jboss-eap-6.3/standalone/data/content/fc/f324141fb233a0401624dc0982576eb4a8fed2/content 上删除内容

          10:43:19,899 INFO  [org.jboss.as.server] (management-handler-thread - 16)  JBAS018558: 已卸载的 "ping-vdb.xml"(runtime-name: "ping-vdb.xml")

          10:43:19,899 INFO  [org.jboss.as.controller] (management-handler-thread - 16)  JBAS014774: 服务状态报告

          JBAS014777: 启动失败的服务:      service jboss.web.deployment.default-host./: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host./: Failed to start service

          • 2. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
            Ramesh Reddy Master

            JBoss Developer Studio 7.1 does not support connecting to Teiid 8.9 + EAP 6.3.Alpha.

             

            See here for latest supported versions Download & Install - JBoss Community

            • 3. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
              jiaxing kou Newbie

              Hi Ramesh:

              Thanks for your reply.

              I have another question.If I want to use the Jboss Developer Studio 7.1. Which version of Teiid or EAP can be connected to  the JBoss Developer Studio 7.1  connect ?

              Thank you.

              • 4. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                Ramesh Reddy Master

                JBoss Developer Studio 7.1.1 works with DV-6.0.0, you can download here http://www.jboss.org/products/datavirt/overview/

                 

                If you want use Designer 9.0 from here Download & Install - JBoss Community then you can use Teiid 8.8 + EAP 6.1Alpha

                • 5. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                  jiaxing kou Newbie

                  Hi Ramesh:

                  Thanks for your reply.

                  There are two questions :

                  1.When I  install the Teiid Designer 9.0 into Eclipse 4.4.1,there are some errors like this:

                  Cannot complete the install because one or more required items could not be found.

                    Software being installed: Teiid Runtime Clients Developer Resources 9.0.0.Final-v20141216-2002-B3222 (org.teiid.designer.teiid.client.feature.source.feature.group 9.0.0.Final-v20141216-2002-B3222)

                    Missing requirement: org.teiid.datatools.connectivity.ui 9.0.0.Final-v20141216-2002-B3222 (org.teiid.datatools.connectivity.ui 9.0.0.Final-v20141216-2002-B3222) requires 'bundle org.jboss.tools.locus.sf.saxon [9.2.1,10.0.0)' but it could not be found

                    Cannot satisfy dependency:

                      From: Teiid Runtime Clients 9.0.0.Final-v20141216-2002-B3222 (org.teiid.designer.teiid.client.feature.feature.group 9.0.0.Final-v20141216-2002-B3222)

                      To: org.teiid.runtime.client [9.0.0.Final-v20141216-2002-B3222]

                    Cannot satisfy dependency:

                      From: Teiid Runtime Clients Developer Resources 9.0.0.Final-v20141216-2002-B3222 (org.teiid.designer.teiid.client.feature.source.feature.group 9.0.0.Final-v20141216-2002-B3222)

                      To: org.teiid.designer.teiid.client.feature.feature.group [9.0.0.Final-v20141216-2002-B3222]

                    Cannot satisfy dependency:

                      From: Teiid Runtime Client 9.0.0.Final-v20141216-2002-B3222 (org.teiid.runtime.client 9.0.0.Final-v20141216-2002-B3222)

                      To: bundle org.teiid.datatools.connectivity.ui [9.0.0,10.0.0)

                   

                  2.I've download and install the DV-6.0.0.There is a file named jboss-eap-6.1.In the JBoss Developer Studio 7.1.1 ,which version of the Teiid Designer should I choose and install? The error "unable to establish connection to the jdbc server. 'jdbc:teiid:ping@mm//localhost:31000'" is still existed.

                  • 6. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                    Ramesh Reddy Master

                    jiaxing,

                     

                    You asked what works with JBoss Developer Studio 7.1.1, I told you DV-6.0.0, so there is no reason to install Teiid Designer 9.0, so ignore your question (1). Coming to question (2), in the "JBoss Central" page (Help->JBoss Central), you will see a tab called "Software/Update", click on it and find "JBoss Data Virtualization" and install. Before you can connect to server using JBoss Developer Studio, you have to install DV-6.0.0 and have it running. Then you can start a "external" server from JBoss Developer Studio from "Server" view window.

                     

                    Ramesh..

                    • 7. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                      jiaxing kou Newbie

                      Hi Ramesh:

                      Thanks for your reply.

                      In the question (1),I ask about the Teiid Designer 9.0 and Eclipse 4.4.1,not the JBoss Developer Studio 7.1.1.

                      So,would you mind giving me some advice about the question (1).

                      Thanks very much.

                      • 8. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                        Ramesh Reddy Master

                        You installation is wrong. You missed a step to install, see "Install Into Luna" directions here Download & Install - JBoss Community and follow each one carefully

                        • 9. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                          jiaxing kou Newbie

                          Hi Ramesh,

                          Thanks for your help.

                          I've connected to the JDBC successfully and import a XML file via remote URL.However,when I want to Preview Data,there is an error like this image showing2015-01-23 15:55:07的屏幕截图.png

                          • 10. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                            Ramesh Reddy Master

                            That dialog is not an error, it is asking to enter a input value to execute a preview. However you may want to preview on the view table you created as part of import of XML (orange colored table) file than previewing source procedure (blue colored) for the XML data.

                             

                            Ramesh..

                            • 11. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                              Barry LaFond Master

                              Ramesh is correct.

                               

                              The getTextFile() procedure is generated and is required by Teiid runtime and is used in the generated view table transformation. It's not intended to be previewed on it's own.

                               

                              Performing Preview Data on your generated view table should return a relational view (result sets) of your underlying XML data.

                               

                              Barry

                              • 12. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                                Nandini K J Newbie

                                Hi Ramesh,

                                I get the following error when tried to connect to Teiid Server.

                                 

                                13:18:55,701 INFO  [org.jboss.as.repository] (management-handler-thread - 15)  JBAS014900: Content added at location C:\Documents and Settings\nandini_jayaram\Desktop\Server\jboss-eap-6.3\standalone\data\content\fc\f324141fb233a0401624dc0982576eb4a8fed2\content

                                13:18:55,701 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2)  JBAS015876: Starting deployment of "ping-vdb.xml" (runtime-name: "ping-vdb.xml")

                                13:18:55,810 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-4)  TEIID40118 VDB ping.1 added to the repository - is reloading false

                                13:18:55,810 INFO  [org.teiid.RUNTIME] (MSC service thread 1-4)  TEIID50029 VDB ping.1 model "Foo" metadata is currently being loaded. Start Time: 4/6/15 1:18 PM

                                13:18:55,810 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4)  TEIID50030 VDB ping.1 model "Foo" metadata loaded. End Time: 4/6/15 1:18 PM

                                13:18:55,810 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 4)  TEIID40003 VDB ping.1 is set to ACTIVE

                                13:18:55,950 INFO  [org.jboss.as.server] (management-handler-thread - 15)  JBAS018559: Deployed "ping-vdb.xml" (runtime-name : "ping-vdb.xml")

                                13:18:55,950 INFO  [org.jboss.as.controller] (management-handler-thread - 15)  JBAS014774: Service status report

                                JBAS014777:   Services which failed to start:      service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service

                                 

                                13:18:56,964 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40120 VDB ping.1 will be removed from the repository

                                13:18:56,964 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40119 VDB ping.1 removed from the repository

                                13:18:56,964 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1)  TEIID50026 VDB "ping.1[Foo{s=s, loopback, null}]" undeployed.

                                13:18:56,980 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40120 VDB ping.1 will be removed from the repository

                                13:18:56,980 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4)  JBAS015877: Stopped deployment ping-vdb.xml (runtime-name: ping-vdb.xml) in 14ms

                                13:18:57,120 INFO  [org.jboss.as.repository] (management-handler-thread - 14)  JBAS014901: Content removed from location C:\Documents and Settings\nandini_jayaram\Desktop\Server\jboss-eap-6.3\standalone\data\content\fc\f324141fb233a0401624dc0982576eb4a8fed2\content

                                13:18:57,120 INFO  [org.jboss.as.server] (management-handler-thread - 14)  JBAS018558: Undeployed "ping-vdb.xml" (runtime-name: "ping-vdb.xml")

                                13:18:57,120 INFO  [org.jboss.as.controller] (management-handler-thread - 14)  JBAS014774: Service status report

                                JBAS014777:   Services which failed to start:      service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service

                                 

                                What is the error?

                                • 13. Re: "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
                                  Ramesh Reddy Master

                                  Your server installation is wrong, or you may have another instance of the server running on the same machine making the JDBC port 31000 not available.