[resolved] fail to retrieve schema with JDBC connection (metadata )!

[Anonymous]

Hello,
the new TOS 3.0 version enables to use JDBC driver to define metadata source.
Connection succeed, however TOS can not retrieve any table shema.
The pictures enclosed show what I mean.
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.
Starting job testBase at 14:45 10/11/2008.
Impossible d'écouter sur le port 2155, sur l'hôte 127.0.0.1 :
java.net.BindException: Address already in use: JVM_Bind
Erreur sur le socket client :
Connection reset
Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source)
at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source)
at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169)
at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331)
at elysctrl.testbase_0_1.testBase.main(testBase.java:245)
Erreur sur le socket client :
Connection reset
Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source)
at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source)
at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169)
at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331)
at elysctrl.testbase_0_1.testBase.main(testBase.java:245)
Erreur sur le socket client :
Connection reset
Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source)
at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source)
at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169)
at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331)
at elysctrl.testbase_0_1.testBase.main(testBase.java:245)
Erreur sur le socket client :
Connection reset
Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source)
at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source)
at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169)
at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331)
at elysctrl.testbase_0_1.testBase.main(testBase.java:245)
Erreur sur le socket client :
Connection reset
Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.pingWithNoOpen(Unknown Source)
at org.apache.derby.impl.drda.NetworkServerControlImpl.ping(Unknown Source)
at org.apache.derby.drda.NetworkServerControl.ping(Unknown Source)
at elysctrl.testbase_0_1.testBase.tCreateTable_1Process(testBase.java:169)
at elysctrl.testbase_0_1.testBase.runJobInTOS(testBase.java:331)
at elysctrl.testbase_0_1.testBase.main(testBase.java:245)
Job testBase ended at 14:45 10/11/2008.

Either I don't use it correctly, or that doesnt work yet.
With mySql database, all works well, but with a "GUPTA SQLBase" one, that fails. "retrieve shema is disable".
Even if i move the mapping file definition from the default mysql_id value to "javadb_id", that doesnt work.
What I do to retrieve schema and get advantage of metadata?
Is it a bug?

[Anonymous · Accepted solution]

Hello

Impossible d'écouter sur le port 2155, sur l'hôte 127.0.0.1 :
java.net.BindException: Address already in use: JVM_Bind

The port 2155 have been used by another application on your machine.
Best regards

shong

[Anonymous]

Sorry to mix CreateTable problem with schema retrieve wizard.
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!
However tCreateTabale and Wizard fail to "retrieve any table schema" !!
1. What's wrong in tCreateTable settings?
2. What's wrong in metadata "database connection" settings?
So what can I do to retrieve schema and get advantage of metadata with a JDBC connection?