Hi,
I am trying to read from a MS SqlServer database, but when running, DBInputTable throws the following exception :
WARN [DB_INPUT_TABLE0] - SQLException when closing statement
java.sql.SQLException: commit() should not be called while in
auto-commit mode.
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1878)
at org.jetel.connection.SQLDataParser.close(SQLDataParser.java:281)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:178)
at org.jetel.graph.Node.run(Node.java:364)
at java.lang.Thread.run(Unknown Source)
FATAL [WatchDog] - !!! Fatal Error !!! - graph execution is aborting
My graph is really simple :
DBInputTable --> Trash
Is there anything special I should do to make this work ?
Thanks,
Franck
I am trying to read from a MS SqlServer database, but when running, DBInputTable throws the following exception :
WARN [DB_INPUT_TABLE0] - SQLException when closing statement
java.sql.SQLException: commit() should not be called while in
auto-commit mode.
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1878)
at org.jetel.connection.SQLDataParser.close(SQLDataParser.java:281)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:178)
at org.jetel.graph.Node.run(Node.java:364)
at java.lang.Thread.run(Unknown Source)
FATAL [WatchDog] - !!! Fatal Error !!! - graph execution is aborting
My graph is really simple :
DBInputTable --> Trash
Is there anything special I should do to make this work ?
Thanks,
Franck
-
Hi !
I assume your transformation finishes OK. It just outputs this problem.
There is a "commit()" call on statement sent to DB since suprisingly some DBs require this.
We are preparing better handling of different DB flavours which should remove these warnings/issues.
If the warning really annoyes you, you may switch off displaying of warnings in "log4j.properties" file (present in engine.jar)
David
Please sign in to leave a comment.
Comments 1