Exception by loading data from databaze MySQL

vsvoboda@trask.cz

• July 25, 2007 00:00

• Answered

Follow

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 !

• 

  mzatopek

  • July 25, 2007 12:05

  0

  Comment actions Permalink

  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
• 

  vsvoboda@trask.cz

  • July 25, 2007 12:38

  0

  Comment actions Permalink

  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>

Please sign in to leave a comment.