topic Re: [resolved] Problem with connection to as400 in Talend Studio

[resolved] Problem with connection to as400

Anonymous — Sat, 16 Nov 2024 12:58:24 GMT

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!

Re: [resolved] Problem with connection to as400

Anonymous — Wed, 20 Apr 2011 02:16:28 GMT

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

Re: [resolved] Problem with connection to as400

Anonymous — Wed, 20 Apr 2011 16:19:44 GMT

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?

Re: [resolved] Problem with connection to as400

Anonymous — Thu, 21 Apr 2011 07:49:07 GMT

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

Re: [resolved] Problem with connection to as400

Anonymous — Fri, 06 May 2011 19:07:58 GMT

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

Re: [resolved] Problem with connection to as400

Anonymous — Sat, 07 May 2011 15:30:12 GMT

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