[Bug]: Table output does not close prepared statements

[hansva]

Apache Hop version?

2.12

Java version?

17

Operating system

macOS

What happened?

The table output transform has it's own implementation for prepared statements.
When we close the connection with data.db.disconnect(); the prepared statements are not being closed.

I do not think this has a big impact on most database servers as they probably close everything when the connection is closed. But DuckDB for example does not release the table lock when de statement isn't closed.

Issue Priority

Priority: 2

Issue Component

Component: Database

[hansva]

.take-issue