Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] problem execution a job with a java application

Hi all
i've followed the tutoriel in the topic : http://community.talend.com:80/t5/Design-and-Development/Talend-as-part-of-another-application/m-p/1... everything seems to be OK ! but when i execute the java program i get the following error :
Exception in component tMysqlOutput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "null"'.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:298)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at importationsql.job1_0_1.job1.tFileInputDelimited_1Process(job1.java:712)
at importationsql.job1_0_1.job1.runJobInTOS(job1.java:1212)
at importationsql.job1_0_1.job1.main(job1.java:1066)
at Talend.main(Talend.java:9)
Caused by: java.lang.NumberFormatException: For input string: "null"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at com.mysql.jdbc.NonRegisteringDriver.port(NonRegisteringDriver.java:814)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
... 6 more

Can you help me please
Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

thank you for answer but I already solved the problem.it was the connectection parameters

View solution in original post

2 Replies
Anonymous
Not applicable
Author

hi,
 Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "null"'.

check that all parameter connection are well passed ... seems that you're using a 'null' value as a parameter !
regards
laurent
Anonymous
Not applicable
Author

thank you for answer but I already solved the problem.it was the connectection parameters