Problem with jTDS and autocommit

CloverDX Platform
1

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

2

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