You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by GitBox <gi...@apache.org> on 2022/12/13 00:10:10 UTC
[GitHub] [hop] usbrandon opened a new issue, #2056: [Bug]: Postgres bulkloader throws class loading exception. HOP-4600
usbrandon opened a new issue, #2056:
URL: https://github.com/apache/hop/issues/2056
### Apache Hop version?
2.2
### Java version?
openjdk version "11.0.17" 2022-10-18
### Operating system
Linux
### What happened?
If you try to run the Postgress Bulk Loader against a table, it immediately throws an exception about casting objects.
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 - ERROR: Error in transform
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 - ERROR: org.apache.hop.core.exception.HopException:
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 - Error while preparing the COPY COPY "Production"."fact_sales_analysis" ( "QUANTITY_UNITS", "QUANTITY", "FILL_DATE_CREATED_TK", "FORMULA_TK", "DOCTOR_TK", "PATIENT_TK", "Business_Line", "Invoice_Date_TK", "Invoice_time_TK", "Invoice_No", "Transaction_Type", "Invoice_Desc", "Invoice_Line_Item_No", "Line_Item", "Item_Type", "Rx_No", "Rx_Fill_ID", "Revenue", "CUSTOMER_TK", "SYSTEM_ID" ) FROM STDIN WITH CSV DELIMITER AS ';' QUOTE AS '"';
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 -
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.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 @1462a99d; org.postgresql.PGConnection is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @15d18b61)
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 -
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 - at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoader.doCopy(PGBulkLoader.java:161)
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 - at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoader.processRow(PGBulkLoader.java:240)
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55)
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 - at java.base/java.lang.Thread.run(Thread.java:829)
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.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 @1462a99d; org.postgresql.PGConnection is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @15d18b61)
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 - at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoader.doCopy(PGBulkLoader.java:158)
2022/11/16 15:50:34 - PostgreSQL Bulk Loader.0 - ... 3 more
2022/11/16 15:50:34 - moveProductionFromMSSQLtoPostgres - Pipeline detected one or more transforms with errors.
2022/11/16 15:50:34 - moveProductionFromMSSQLtoPostgres - Pipeline is killing the other transforms!
### Issue Priority
Priority: 3
### Issue Component
Component: Transforms
--
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
[GitHub] [hop] hansva commented on issue #2056: [Bug]: Postgres bulkloader throws class loading exception. HOP-4600
Posted by GitBox <gi...@apache.org>.
hansva commented on issue #2056:
URL: https://github.com/apache/hop/issues/2056#issuecomment-1371919770
I created a follow up ticket here: https://github.com/apache/hop/issues/2129
I think this is the work that has to be done to make everything a bit more logical
--
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
[GitHub] [hop] usbrandon commented on issue #2056: [Bug]: Postgres bulkloader throws class loading exception. HOP-4600
Posted by GitBox <gi...@apache.org>.
usbrandon commented on issue #2056:
URL: https://github.com/apache/hop/issues/2056#issuecomment-1371528293
It turns out that the bulkloader works fine. There is a different bug in Hop related to classloading where if you use JDBC drivers in an external folder then something bad happens and these kinds of errors appear. The errors go away on the out of the box Hop as it doesn't try to use external JDBC driver folders. The safest place I found for JDBC jar files is hop/lib/core. This was what Bart and I discovered troubleshooting my environment. It caused errors to come up when I tried the Vertica bulkloader.
There is, however, still a null pointer exception when clicking the SQL button on the Postgres Bulkloader transform, but at least the data transfer functionality works.
--
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
[GitHub] [hop] hansva commented on issue #2056: [Bug]: Postgres bulkloader throws class loading exception. HOP-4600
Posted by GitBox <gi...@apache.org>.
hansva commented on issue #2056:
URL: https://github.com/apache/hop/issues/2056#issuecomment-1347879514
Could it be that you have 2 JDBC drivers in your Hop installation? on in Lib and one in plugins/databases/postgresql/lib ?
--
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
[GitHub] [hop] usbrandon commented on issue #2056: [Bug]: Postgres bulkloader throws class loading exception. HOP-4600
Posted by GitBox <gi...@apache.org>.
usbrandon commented on issue #2056:
URL: https://github.com/apache/hop/issues/2056#issuecomment-1349951337
No chance. I only have one in an external folder. Each time I try a new snapshot of Hop I delete the postgres jar and mssqlnative jar that it ships with because I have newer JDBC drivers.
--
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
[GitHub] [hop] hansva closed issue #2056: [Bug]: Postgres bulkloader throws class loading exception. HOP-4600
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #2056: [Bug]: Postgres bulkloader throws class loading exception. HOP-4600
URL: https://github.com/apache/hop/issues/2056
--
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