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

Six Stars

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

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)

Accepted Solutions
One Star

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

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

All Replies
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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
One Star

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

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
One Star

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

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)
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

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

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