[resolved] problem execution a job with a java application

One Star

[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

Accepted Solutions
One Star

Re: [resolved] problem execution a job with a java application

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

All Replies
Seventeen Stars

Re: [resolved] problem execution a job with a java application

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

Re: [resolved] problem execution a job with a java application

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