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