2 Replies Latest reply on Apr 7, 2015 12:47 AM by nandini123

    Unable to establish jdbc connection to server

    nandini123

      Hi all,

      I get the following error when tried to Test JDBC connection in the Teiid Instance.

       

      16:54:29,366 INFO  [org.jboss.as.repository] (management-handler-thread - 7)  JBAS014900: Content added at location C:\Documents and Settings\nandini_jayaram\Desktop\Server\jboss-eap-6.3\standalone\data\content\fc\f324141fb233a0401624dc0982576eb4a8fed2\content

      16:54:29,366 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4)  JBAS015876: Starting deployment of "ping-vdb.xml" (runtime-name: "ping-vdb.xml")

      16:54:29,460 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-4)  TEIID40118 VDB ping.1 added to the repository - is reloading false

      16:54:29,460 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 4:54 PM

      16:54:29,460 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2)  TEIID50030 VDB ping.1 model "Foo" metadata loaded. End Time: 4/6/15 4:54 PM

      16:54:29,460 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 2)  TEIID40003 VDB ping.1 is set to ACTIVE

      16:54:29,600 INFO  [org.jboss.as.server] (management-handler-thread - 7)  JBAS018559: Deployed "ping-vdb.xml" (runtime-name : "ping-vdb.xml")

      16:54:29,600 INFO  [org.jboss.as.controller] (management-handler-thread - 7)  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

       

      16:54:30,802 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40120 VDB ping.1 will be removed from the repository

      16:54:30,802 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40119 VDB ping.1 removed from the repository

      16:54:30,802 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1)  TEIID50026 VDB "ping.1[Foo{s=s, loopback, null}]" undeployed.

      16:54:30,802 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2)  TEIID40120 VDB ping.1 will be removed from the repository

      16:54:30,834 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1)  JBAS015877: Stopped deployment ping-vdb.xml (runtime-name: ping-vdb.xml) in 16ms

      16:54:31,084 INFO  [org.jboss.as.repository] (management-handler-thread - 8)  JBAS014901: Content removed from location C:\Documents and Settings\nandini_jayaram\Desktop\Server\jboss-eap-6.3\standalone\data\content\fc\f324141fb233a0401624dc0982576eb4a8fed2\content

      16:54:31,084 INFO  [org.jboss.as.server] (management-handler-thread - 8)  JBAS018558: Undeployed "ping-vdb.xml" (runtime-name: "ping-vdb.xml")

      16:54:31,084 INFO  [org.jboss.as.controller] (management-handler-thread - 8)  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

       

      How to start the jboss.teiid.transport.jdbc service? Please help

        • 1. Re: Unable to establish jdbc connection to server
          rareddy

          Please DO NOT POST same question in multiple forums, asking different ways. It only put strain on limited resources we got in answering your duplicate questions. Ask in Teiid forum, and someone will answer your question. If it is different question, use another thread.

           

          Your server installation is wrong, or you have modified the configuration after the install or you have another server running the same machine which is taking the port 31000

          • 2. Re: Unable to establish jdbc connection to server
            nandini123

            Thanks for your reply Ramesh. I changed the JDBC connection port number in the standalone-teiid.xml file and now its working fine.