Hi,
How can I remove Warn log by loading data from databaze MySQL in running graph. The graph finsh successfully.
Component - Readers - DB Input Table
Thanks
INFO [WatchDog] - Sucessfully started all nodes in phase!
WARN [DB_INPUT_TABLE0] - SQLException when closing statement
java.sql.SQLException: Can’t call commit when autocommit=true
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:914)
at com.mysql.jdbc.Connection.commit(Connection.java:2274)
at org.jetel.connection.SQLDataParser.close(SQLDataParser.java:283)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:178)
at org.jetel.graph.Node.run(Node.java:364)
at java.lang.Thread.run(Thread.java:595)
INFO [WatchDog] - Execution of phase [0] successfully finished - elapsed time(sec): 1
INFO [main] - WatchDog thread finished - total execution time: 5 (sec)
WARN [main] - DBConnection0 - close operation failed.
INFO [main] - Graph execution finished successfully
Execution of graph successful !
Hello.
This warning is caused by a inconsistent implementation of MySQL jdbc driver, since the commit call is under condition (autocommit == false).
The first repair release 2.2.1 will contain a fix to avoid this warning. Now you can turn off all log messages on the warning level in the log4j.properties config file:
log4j.rootLogger=DEBUG, A1
- →
log4j.rootLogger=ERROR, A1
This is Error by running from command line.
Thanks I test it.
Graph definition file: Tabulky.grf
INFO [main] - Checking graph configuration…
ERROR [main] - java.io.FileNotFoundException: DB connection\Table2connection.cfg (The system cannot find the path specified)
INFO [main] - Initializing DB connection:
INFO [main] - DBConnection driver[null]:url[null]:user[null] … !!! ERROR !!!
ERROR [main] - Can’t connect to database
java.lang.NullPointerException
at org.jetel.connection.DBConnection.free(DBConnection.java:355)
at org.jetel.graph.TransformationGraph.init(TransformationGraph.java:419)
at org.jetel.main.runGraph.main(runGraph.java:290)
ERROR [main] - Error - graph’s configuration invalid !
org.jetel.exception.GraphConfigurationException: Graph initialization failed.
at org.jetel.main.runGraph.main(runGraph.java:291)
C:\install\CloverETL\Prikazove_spusteni\examples>