[Bug]: PostgreSQL Bulk Loader throwing class excception #4906
Description
Apache Hop version?
2.11
Java version?
JDK 23
Operating system
Windows
What happened?
Greetings!
I created a simple Hop Pipeline with one table input and one PostgreSQL Bulk Loader through the UI. When I run the Pipeline, I get the following error:
2025/02/13 16:53:25 - tbl_pipeline - Execution started for pipeline [tbl_pipeline]
2025/02/13 16:53:26 - load.0 - Detect client_encoding: UTF8
2025/02/13 16:53:26 - load.0 - Launching command: TRUNCATE test.hop_tbl
2025/02/13 16:53:26 - load.0 - Launching command: COPY test.hop_tbl ( <columns> ) FROM STDIN WITH CSV DELIMITER AS ';' QUOTE AS '"';
2025/02/13 16:53:26 - load.0 - ERROR: Error in transform
2025/02/13 16:53:26 - load.0 - ERROR: org.apache.hop.core.exception.HopException:
2025/02/13 16:53:26 - load.0 - Error while preparing the COPY COPY test.hop_tbl ( <columns> ) FROM STDIN WITH CSV DELIMITER AS ';' QUOTE AS '"';
2025/02/13 16:53:26 - load.0 -
2025/02/13 16:53:26 - load.0 - class org.postgresql.jdbc.PgConnection cannot be cast to class org.postgresql.PGConnection (org.postgresql.jdbc.PgConnection is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @24eb9073; org.postgresql.PGConnection is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @1b2213b2)
2025/02/13 16:53:26 - load.0 -
2025/02/13 16:53:26 - load.0 - at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoader.doCopy([PGBulkLoader.java:160](https://pgbulkloader.java:160/))
2025/02/13 16:53:26 - load.0 - at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoader.processRow([PGBulkLoader.java:238](https://pgbulkloader.java:238/))
2025/02/13 16:53:26 - load.0 - at [org.apache.hop.pipeline.transform.RunThread.run](https://org.apache.hop.pipeline.transform.runthread.run/)([RunThread.java:54](https://runthread.java:54/))
2025/02/13 16:53:26 - load.0 - at java.base/java.lang.Thread.run(Unknown Source)
2025/02/13 16:53:26 - load.0 - Caused by: java.lang.ClassCastException: class org.postgresql.jdbc.PgConnection cannot be cast to class org.postgresql.PGConnection (org.postgresql.jdbc.PgConnection is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @24eb9073; org.postgresql.PGConnection is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @1b2213b2)
2025/02/13 16:53:26 - load.0 - at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoader.doCopy([PGBulkLoader.java:157](https://pgbulkloader.java:157/))
2025/02/13 16:53:26 - load.0 - ... 3 more
2025/02/13 16:53:26 - load.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2025/02/13 16:53:26 - tbl_pipeline - Pipeline detected one or more transforms with errors.
2025/02/13 16:53:26 - tbl_pipeline - Pipeline is killing the other transforms!
2025/02/13 16:53:26 - input.0 - Finished reading query, closing connection.
2025/02/13 16:53:26 - input.0 - Finished processing (I=2830, O=0, R=0, W=2828, U=0, E=0)
2025/02/13 16:53:26 - tbl_pipeline - Pipeline duration : 0.793 seconds [ 0.793" ]
2025/02/13 16:53:26 - tbl_pipeline - Execution finished on a local pipeline engine with run configuration 'local'
The same error happens when running the pipeline with hop-run.bat.
Notes:
- PostgreSQL JDBC version: 42.7.4 (also tested with 42.7.5, same error)
- Tried reinstalling Hop, unsuccessful
- Also tested with Java 21, unsuccessful
Issue Priority
Priority: 2
Issue Component
Component: Pipelines