Bonjour j'ai crée un job qui importe un fichier CSV dans une bdd Mysql
le job marche bien sous talend mais quand je l'exporte pour l'executer sous java j'ai l'erreur suivante :
Aidez moi SVP
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26 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
Partager