topic Re: [resolved] DB Connection failure. You must change the Database Settings in Talend Studio

[resolved] DB Connection failure. You must change the Database Settings

Anonymous — Tue, 16 Dec 2014 20:24:08 GMT

Hello,
I haven't used my talend for a while. Today when I opened the Talend IDE open studio, all the db connections don't work. I am sure my database is working fine. I can connect to the database through other tools like aqua data studio. When I tried to create new connection in metadata, it fails as well. I got the following errors when I ran the connection. Anybody has any idea on what is going on here. This is my local machine's problem. My talend job in production still working fine. What can cause this issue? Thanks!
Exception in component tDB2Connection_1
java.lang.NumberFormatException: For input string: "A"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at com.ibm.db2.jcc.c.xc.<init>(xc.java:64)
at com.ibm.db2.jcc.b.f.<init>(f.java:44)
at com.ibm.db2.jcc.b.b.cb(b.java:1945)
at com.ibm.db2.jcc.c.p.a(p.java:3284)
at com.ibm.db2.jcc.b.b.a(b.java:625)
at com.ibm.db2.jcc.b.b.<init>(b.java:334)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at testxml.test_0_1.test.tDB2Connection_1Process(test.java:351)
at testxml.test_0_1.test.runJobInTOS(test.java:1251)
at testxml.test_0_1.test.main(test.java:1116)

Re: [resolved] DB Connection failure. You must change the Database Settings

Anonymous — Wed, 17 Dec 2014 03:10:21 GMT

Hi,

On which official version did you get that? Is there any error info by clicking Details button when you
tried to create new connection in metadata?
Best regards
Sabrina

Re: [resolved] DB Connection failure. You must change the Database Settings

blackfox — Mon, 17 Aug 2015 12:47:17 GMT

Hello jijli,
I've got the exactly same situation as described by you - did you find any solution? What was the problem?
Regards,
blackfox
Edit: I don't know where this "Close" at the end of my message comes from - it appears automatically and if I remove it by using "edit" it reappears after submit...
Close

Re: [resolved] DB Connection failure. You must change the Database Settings

blackfox — Mon, 17 Aug 2015 13:08:39 GMT

Hi,
I've found the solution. For anybody else having the same problem:
In my case the db2-jars were too old (http://www-01.ibm.com/support/docview.wss?uid=swg21625290).
Replacing them in <TOS-installdir>\lib\java\ with newer versions worked fine...
Close

Re: [resolved] DB Connection failure. You must change the Database Settings

_AnonymousUser — Thu, 24 Dec 2015 15:16:04 GMT

I am getting the same error. COuld you please help me in resolve the issue. It is coming to only two Datasource connections, remaining are working fine.
Mine is was6.1.
00000027 DataSourceCon E DSRA8040I: Failed to connect to the DataSource. Encountered "": java.lang.NumberFormatException: For input string: "A"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:63)
at java.lang.Integer.parseInt(Integer.java:481)
at java.lang.Integer.parseInt(Integer.java:531)
at com.ibm.db2.jcc.c.ad.<init>(ad.java:80)
at com.ibm.db2.jcc.b.f.<init>(f.java:55)
at com.ibm.db2.jcc.b.b.ib(b.java:1760)
at com.ibm.db2.jcc.c.p.a(p.java:2490)
at com.ibm.db2.jcc.b.b.a(b.java:470)
at com.ibm.db2.jcc.b.b.a(b.java:356)
at com.ibm.db2.jcc.b.b.<init>(b.java:292)
at com.ibm.db2.jcc.DB2PooledConnection.<init>(DB2PooledConnection.java:67)
at com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPooledConnectionX(DB2ConnectionPoolDataSource.java:144)
at com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPooledConnection(DB2ConnectionPoolDataSource.java:58)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1292)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1324)

Re: [resolved] DB Connection failure. You must change the Database Settings

Anonymous — Fri, 25 Dec 2015 09:42:11 GMT

Hi Naresh1313,
On which talend build version did you got that? Have you tried to update your db jar file to see if it works?
Best regards
Sabrina

Re: [resolved] DB Connection failure. You must change the Database Settings

Anonymous — Mon, 04 Jan 2016 17:42:16 GMT

Yes, just make sure you are using the right version of db2jcc jars.