[Bug]: MSSQL JDBC driver: info is wrongly routed in console / supress message

[ggrohmann]

Apache Hop version?

2.17

Java version?

17

Operating system

Windows

What happened?

When using mssql native driver (e.g. mssql-jdbc-13.4.0.jre11.jar), plenty messages occur in the error log in windows environment. Logs are routed through batch command > and 2> (see attached cmd file). These messages are infos by the driver, but not errors. Unfortunately this creates a lot of noise in the error log (see screenshot). These messages are not shown, when running the workflow/ pipeline directly in hop).

This seems to occur mainly in table output step in pipelines, sql statements in workflow are not affected. Sample workflow/ pipeline attached.

Messages in error log:

Jun 15, 2026 5:39:12 PM com.microsoft.sqlserver.jdbc.TDSTokenHandler onColMetaData
INFO: ConnectionID:4 ClientConnectionId: dfa2e1ce-ace8-4609-a7d5-31965f27eed6: SQLServerConnection.supportsTransactions: Discarding extra metadata which can be a result of SHOWPLAN settings:  TDS_COLMETADATA (0x81)

test-sql-metadata.zip

Issue Priority

Priority: 2

Issue Component

Component: Hop Run

[dheerusri324]

Hi @ggrohmann, I'd like to investigate this logging configuration issue. Could a maintainer assign this to me?

[hansva]

You can assign a ticket to yourself with the [.]take-issue command (remove the [])

[dheerusri324]

.take-issue

[ggrohmann]

Thanks @dheerusri324 for the quick fix. Looking forward to see it in the next release.

[hansva]

Thank you for the contribution @dheerusri324 !

[dheerusri324]

Glad I could contribute!😄