https://community.qlik.com/t5/Talend-Studio/resolved-fail-to-retrieve-schema-with-JDBC-connection-metadata/m-p/2222827#M16270 Hello <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>Impossible d'écouter sur le port 2155, sur l'hôte 127.0.0.1 :<BR />java.net.BindException: Address already in use: JVM_Bind</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />The port 2155 have been used by another application on your machine. <BR />Best regards <BR /> <BR /> shong Tue, 11 Nov 2008 02:05:10 GMT Anonymous 2008-11-11T02:05:10Z https://community.qlik.com/t5/Talend-Studio/resolved-fail-to-retrieve-schema-with-JDBC-connection-metadata/m-p/2222826#M16269 Hello, <BR />the new TOS 3.0 version enables to use JDBC driver to define metadata source. <BR />Connection succeed, however TOS can not retrieve any table shema. <BR />The pictures enclosed show what I mean. <BR />If I use the metadata as repository information, there also seem to lack some information such as database type or name. Even if I set it manually (createTableWithJDBCCo2.bmp), that still fails at execution. <BR />Starting job testBase at 14:45 10/11/2008. <BR />Impossible d'écouter sur le port 2155, sur l'hôte 127.0.0.1 : <BR /> java.net.BindException: Address already in use: JVM_Bind <BR />Erreur sur le socket client : <BR /> Connection reset <BR />Connection reset <BR />java.net.SocketException: Connection reset <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source) <BR /> at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source) <BR /> at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169) <BR /> at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331) <BR /> at elysctrl.testbase_0_1.testBase.main(testBase.java:245) <BR />Erreur sur le socket client : <BR /> Connection reset <BR />Connection reset <BR />java.net.SocketException: Connection reset <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source) <BR /> at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source) <BR /> at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169) <BR /> at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331) <BR /> at elysctrl.testbase_0_1.testBase.main(testBase.java:245) <BR />Erreur sur le socket client : <BR /> Connection reset <BR />Connection reset <BR />java.net.SocketException: Connection reset <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source) <BR /> at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source) <BR /> at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169) <BR /> at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331) <BR /> at elysctrl.testbase_0_1.testBase.main(testBase.java:245) <BR />Erreur sur le socket client : <BR /> Connection reset <BR />Connection reset <BR />java.net.SocketException: Connection reset <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source) <BR /> at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source) <BR /> at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169) <BR /> at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331) <BR /> at elysctrl.testbase_0_1.testBase.main(testBase.java:245) <BR />Erreur sur le socket client : <BR /> Connection reset <BR />Connection reset <BR />java.net.SocketException: Connection reset <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at java.net.SocketInputStream.read(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source) <BR /> at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source) <BR /> at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source) <BR /> at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169) <BR /> at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331) <BR /> at elysctrl.testbase_0_1.testBase.main(testBase.java:245) <BR />Job testBase ended at 14:45 10/11/2008. <BR /> <BR />Either I don't use it correctly, or that doesnt work yet. <BR />With mySql database, all works well, but with a "GUPTA SQLBase" one, that fails. "retrieve shema is disable". <BR />Even if i move the mapping file definition from the default mysql_id value to "javadb_id", that doesnt work. <BR />What I do to retrieve schema and get advantage of metadata? <BR />Is it a bug? Sat, 16 Nov 2024 14:09:59 GMT https://community.qlik.com/t5/Talend-Studio/resolved-fail-to-retrieve-schema-with-JDBC-connection-metadata/m-p/2222826#M16269 Anonymous 2024-11-16T14:09:59Z https://community.qlik.com/t5/Talend-Studio/resolved-fail-to-retrieve-schema-with-JDBC-connection-metadata/m-p/2222827#M16270 Hello <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>Impossible d'écouter sur le port 2155, sur l'hôte 127.0.0.1 :<BR />java.net.BindException: Address already in use: JVM_Bind</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />The port 2155 have been used by another application on your machine. <BR />Best regards <BR /> <BR /> shong Tue, 11 Nov 2008 02:05:10 GMT https://community.qlik.com/t5/Talend-Studio/resolved-fail-to-retrieve-schema-with-JDBC-connection-metadata/m-p/2222827#M16270 Anonymous 2008-11-11T02:05:10Z https://community.qlik.com/t5/Talend-Studio/resolved-fail-to-retrieve-schema-with-JDBC-connection-metadata/m-p/2222828#M16271 Sorry to mix CreateTable problem with schema retrieve wizard.<BR />The 2155 port is the one that works for this database. If I change this value, the error back is still the same. Data select in tJDBCInput component works with the metadata source, as well as check connection succeeds!<BR />However tCreateTabale and Wizard fail to "retrieve any table schema" !!<BR />1. What's wrong in tCreateTable settings?<BR />2. What's wrong in metadata "database connection" settings?<BR />So what can I do to retrieve schema and get advantage of metadata with a JDBC connection? Wed, 12 Nov 2008 09:34:52 GMT https://community.qlik.com/t5/Talend-Studio/resolved-fail-to-retrieve-schema-with-JDBC-connection-metadata/m-p/2222828#M16271 Anonymous 2008-11-12T09:34:52Z