samuelfarrus opened a new issue, #4906: URL: https://github.com/apache/hop/issues/4906
### 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 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
