[resolved] Problem with connection to as400

[Anonymous]

Good day,
I have a problem to connect to as400, the error I get is: "connection failure. You Most change the Database Settings. "
My connection string is: jdbc: as400: / / xxx.xxx.x.xxx /????????; libraries = MyLibrary, prompt = false
Apparently I need to know which is the name of the database, only know the libraries but not the name of the database. How I can get the name of the database on the AS400?, I have access to the AS400 but do not know how to get the name of the database.
Anybody can help me?
Thanks!

[Anonymous]

Hi
You have to specify the database name and get it from db administrator.
Best regards
Shong

[Anonymous]

hello
Now I can make the connection to AS400, I did a test and was successful, but when running the job get the following error:
Connecting to socket on port 3950
java.net.ConnectException: Connection refused: connect
java.net.PlainSocketImpl.socketConnect at (Native Method)
java.net.PlainSocketImpl.doConnect at (Unknown Source)
java.net.PlainSocketImpl.connectToAddress at (Unknown Source)
java.net.PlainSocketImpl.connect at (Unknown Source)
java.net.SocksSocketImpl.connect at (Unknown Source)
at java.net.Socket.connect (Unknown Source)
at java.net.Socket.connect (Unknown Source)
at java.net.Socket. <init> (Unknown Source)
at java.net.Socket. <init> (Unknown Source)
at routines.system.RunStat.startThreadStat (RunStat.java: 195)
at reportes.prueba_0_1.prueba.runJobInTOS (prueba.java: 457)
at reportes.prueba_0_1.prueba.main (prueba.java: 343)
Exception in component tAS400Connection_1
java.sql.SQLException: The application requester Can not ESTABLISH the connection. (Connection refused: connect)
at com.ibm.as400.access.JDError.throwSQLException (JDError.java: 528)
at com.ibm.as400.access.AS400JDBCConnection.setProperties (AS400JDBCConnection.java: 2873)
at com.ibm.as400.access.AS400JDBCDriver.prepareConnection (AS400JDBCDriver.java: 1242)
at com.ibm.as400.access.AS400JDBCDriver.initializeConnection (AS400JDBCDriver.java: 1105)
at com.ibm.as400.access.AS400JDBCDriver.connect (AS400JDBCDriver.java: 355)
at java.sql.DriverManager.getConnection (Unknown Source)
at java.sql.DriverManager.getConnection (Unknown Source)
at reportes.prueba_0_1.prueba.tAS400Connection_1Process (prueba.java: 253)
at reportes.prueba_0_1.prueba.runJobInTOS (prueba.java: 477)
at reportes.prueba_0_1.prueba.main (prueba.java: 343)
Any ideas?

[Anonymous]

Hi

Connecting to socket on port 3950
java.net.ConnectException: Connection refused: connect

This is because the port 3950 is refused by local machine, please verify
- Go to windows-->preference-->talend-->run/debug and check the port 3950 is in the stats port range, increase the range if possible.
- Can you execute other jobs?
- The firewall or other anti-virus software on local machine allows the stats port range?
Best regards
Shong

[Anonymous · Accepted solution]

Shong thank you very much, you're right, the problem was the firewall.
It need your permission to enable Talend.
Thanks!

[Anonymous]

Hi
Thanks for your feedback! It will be helpful for other users if they meet the same problem.
Best regards
Shong