Hi, My tAs400Inut component works fine and can readd the table however if I attempt to use the Database Table Selector dialog I get a DB connection failure. These are the same parameters (without quotes) that is used by the raed component. Can anyone help regarding this ? Database connection is failed. java.lang.RuntimeException: java.sql.SQLException: The application requester cannot establish the connection. (Malformed reply from SOCKS server) at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195) at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1092) at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315) at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:301) at org.talend.designer.core.ui.editor.properties.controllers.DbTableController.checkConnection(DbTableController.java:769) at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$6.run(DbTableController.java:558) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: java.sql.SQLException: The application requester cannot establish the connection. (Malformed reply from SOCKS server) at com.ibm.as400.access.JDError.throwSQLException(JDError.java:561) at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3342) at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1414) at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1251) at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:390) at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41) at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186) ... 6 more Caused by: java.net.SocketException: Malformed reply from SOCKS server at java.net.SocksSocketImpl.readSocksReply(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.ibm.as400.access.PortMapper.getSocketConnection(PortMapper.java:266) at com.ibm.as400.access.PortMapper.getServerSocket(PortMapper.java:161) at com.ibm.as400.access.AS400ImplRemote.signonConnect(AS400ImplRemote.java:2363) at com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:2278) at com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:3142) at com.ibm.as400.access.AS400.promptSignon(AS400.java:2706) at com.ibm.as400.access.AS400.signon(AS400.java:4035) at com.ibm.as400.access.AS400.connectService(AS400.java:1184) at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3334) ... 11 more
Hi, It seems your Socks proxy didn't work well. Is your network working well for you? Please check that your connection is successful while creating it. It should be a connection or a network problem. On which build version you got this issue?
HI Xdshi,
As far as I am aware I have loaded the latest version. I am completing a critical POC and really need this to work asap. The version I have is :- TOS_DI-20161026_1219-V6.3.0
