Uploaded image for project: 'Apache Hop (Retired)'
  1. Apache Hop (Retired)
  2. HOP-4600

Postgres Bulk Loader - class org.postgresql.jdbc.PgConnection cannot be cast...

    XMLWordPrintableJSON

Details

    Description

      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!

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              usbrandon Brandon Jackson
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: