-
15. Re: Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer 10.0.2
giuseppe.cesmi Jan 26, 2018 9:56 AM (in response to rareddy)Hi Ramesh,
i tryied with squirrel in the same machine and it works.
1) I copied vdb file in v_quick_start/dv_server/standalone/deployments/loopy-vdb.xml
2) Inside squirrel i added dv_quick_start/dv_server/dataVirtualization/jdbc/teiid-8.12.5.redhat-8-jdbc.jar driver.
3) I tested connection with the same credential i used in eclipse test. I wasn't able to find any log about this test in server.log
So what i should do in Jboss developer Studio (eclipse)?
Thanks,
Giuseppe
-
16. Re: Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer 10.0.2
rareddy Jan 26, 2018 10:02 AM (in response to giuseppe.cesmi)Cool, now we established that your server is fine. I suspect something went wrong with the upgrade of the JBoss Developer Studio. There is 11.1 version now available, can you see if you can install and test with that? Red Hat JBoss Developer Studio Download | Red Hat Developers
-
17. Re: Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer 10.0.2
giuseppe.cesmi Jan 29, 2018 5:02 AM (in response to rareddy)Hi Ramesh,
I tryied with version 11.1 but i have always the same problem. Test Jdbc connection fails: Unable to establish a jdbc connection to server "jdbc:teiid:ping@mm://localhost:31000".
This is the last part of my server.log:
10:51:59,036 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "ping-vdb.xml" (runtime-name: "ping-vdb.xml")
10:51:59,064 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-8) TEIID40118 VDB ping.1 added to the repository
10:51:59,065 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB ping.1 model "Foo" metadata is currently being loaded. Start Time: 29/01/18 10.51
10:51:59,067 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB ping.1 model "Foo" metadata loaded. End Time: 29/01/18 10.51
10:51:59,068 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 1) TEIID40003 VDB ping.1 is set to ACTIVE
10:51:59,087 INFO [org.jboss.as.server] (management-handler-thread - 19) JBAS015859: Deployed "ping-vdb.xml" (runtime-name : "ping-vdb.xml")
10:51:59,105 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1) TEIID40120 VDB ping.1 will be removed from the repository
10:51:59,106 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1) TEIID40119 VDB ping.1 removed from the repository
10:51:59,107 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50026 VDB "ping.1[Foo{s=s, loopback, null}]" undeployed.
10:51:59,108 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1) TEIID40120 VDB ping.1 will be removed from the repository
10:51:59,115 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015877: Stopped deployment ping-vdb.xml (runtime-name: ping-vdb.xml) in 14ms
10:51:59,138 INFO [org.jboss.as.repository] (management-handler-thread - 19) JBAS014901: Content removed from location /home/baudo/Scrivania/dv_quick_start/dv_server/standalone/data/content/fc/f324141fb233a0401624dc0982576eb4a8fed2/content
10:51:59,138 INFO [org.jboss.as.server] (management-handler-thread - 19) JBAS015858: Undeployed "ping-vdb.xml" (runtime-name: "ping-vdb.xml")
-
18. Re: Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer 10.0.2
m.ardito Jan 29, 2018 6:56 AM (in response to giuseppe.cesmi)Have you already checked if it is not something like this? "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer
-
19. Re: Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer 10.0.2
giuseppe.cesmi Jan 29, 2018 8:09 AM (in response to m.ardito)Yes i have checked.
-
20. Re: Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer 10.0.2
rareddy Jan 29, 2018 9:53 AM (in response to giuseppe.cesmi)There is also "database" or "data profiles" view in the Eclipse, see if you can connect through it. Otherwise, I am not sure what else going on, everything seems to correct logs wise.
-
21. Re: Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer 10.0.2
giuseppe.cesmi Jan 29, 2018 10:11 AM (in response to rareddy)Hi Ramesh,
i solved the problem in eclipse in Window --> Prefreferences --> General --> Security --> Secure Storage:
1) I decided to clear all password
2) I followed the wizard clicking on Change Password.
After that i tryied the jdbc connection and it worked.
I have a question about JDV:
Suppose i map a source called mysource. After an x period I produce a new source called mysourceb. Both source have the same structure, different name and different content.
So is there a way to map mysourceb dynamically to consume data ?
Thanks,
Giuseppe
-
22. Re: Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer 10.0.2
rareddy Jan 29, 2018 10:36 AM (in response to giuseppe.cesmi)Start a new discussion, and the question was not clear. consume from where?