You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "samuelfarrus (via GitHub)" <gi...@apache.org> on 2025/02/13 20:01:48 UTC
[I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
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: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "dsanderbi (via GitHub)" <gi...@apache.org>.
dsanderbi commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-2736752678
Hi @hansva,
Would it be possible to add the PSQL JDBC driver to the core by default until the issue is resolved?
This would be a helpful workaround and save me from having to move the JDBC with every release.
It would also be quite handy for the Docker image.
What do you think?
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-2659322612
Ok, then I will have to check if I can reproduce this on Windows. We have daily tests including this transform.
https://ci-builds.apache.org/job/Hop/job/Hop-integration-tests/1703/testReport/(root)/database/0017_postgresql_bulkloader/
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-2657694848
Do you by any chance have 2 PostgreSQL drivers in your hop installation? This might cause this issue.
we include the driver in the default zip under /lib/jdbc/
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "samuelfarrus (via GitHub)" <gi...@apache.org>.
samuelfarrus commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-2662824547
Thank you all for the reply! @dsanderbi moving the JDBC driver worked like a charm. I will close this issue since it solves the problem.
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-2736907434
Could you try with the [current snapshot](https://repository.apache.org/content/repositories/snapshots/org/apache/hop/hop-client/2.13.0-SNAPSHOT/) and/or provide a sample that causes this issue?
I tried using a table input -> postges bulk loader but I am not getting the issue
Tried on both linux and windows
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #4906: [Bug]: PostgreSQL Bulk Loader throwing class excception
URL: https://github.com/apache/hop/issues/4906
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-2662827556
Let's keep it open as it is a workaround and not a real fix.
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "samuelfarrus (via GitHub)" <gi...@apache.org>.
samuelfarrus commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-2659318683
Nope. The last execution (from which I copied the log) was with a newly downloaded Hop, with only the default JDBCs.
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "dsanderbi (via GitHub)" <gi...@apache.org>.
dsanderbi commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-2661406891
@hansva
The issue might be related to this one:
https://github.com/apache/hop/issues/2907
@samuelfarrus move the JDBC driver from lib/jdbc to lib/core will fix your issue.
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "samuelfarrus (via GitHub)" <gi...@apache.org>.
samuelfarrus closed issue #4906: [Bug]: PostgreSQL Bulk Loader throwing class excception
URL: https://github.com/apache/hop/issues/4906
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "dsanderbi (via GitHub)" <gi...@apache.org>.
dsanderbi commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-2739494479
Hi,
I have now used the latest version as well. However, I cannot reproduce it with a simple example.
It looks like this only occurs with my ETL process, so I will need to invest more time to figure out what's going on.
I’ll let you know as soon as I have more information.
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: PostgreSQL Bulk Loader throwing class excception (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #4906:
URL: https://github.com/apache/hop/issues/4906#issuecomment-4183740068
I do not think this is still an issue.
--
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: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org