Details
-
Bug
-
Status: Closed
-
Normal
-
Resolution: Not A Problem
-
2.0.0
-
None
-
None
-
Windows 10
Description
We are trying to use Postgres as a generic database connection for the configurability.
1. We are moving the "postgresql-42.3.3.jar" because the generic driver does not seem to load from \hop\plugins\databases\postgresql and we are getting the following error:
2022/08/17 12:06:05 - Insert / update.0 - Driver class 'org.postgresql.Driver' could not be found, make sure the 'Generic database' driver (jar file) is installed. 2022/08/17 12:06:05 - Insert / update.0 - Unable to load class 'org.postgresql.Driver' in this classloader or in the parent
2. When moving the "postgresql-42.3.3.jar" from \hop\plugins\databases\postgresql to the folder set in "HOP_SHARED_JDBC_FOLDER" then the following error occurs:
2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - ERROR: Unexpected error 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - ERROR: java.lang.NoClassDefFoundError: org/postgresql/copy/PGCopyOutputStream 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoader.doCopy(PGBulkLoader.java:158) 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoader.processRow(PGBulkLoader.java:240) 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:51) 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - at java.base/java.lang.Thread.run(Thread.java:829) 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - Caused by: java.lang.ClassNotFoundException: Unable to load class 'org.postgresql.copy.PGCopyOutputStream' in this classloader or in the parent 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - at org.apache.hop.core.plugins.HopURLClassLoader.loadClass(HopURLClassLoader.java:96) 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522) 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - ... 4 more 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - Caused by: java.lang.ClassNotFoundException: org.postgresql.copy.PGCopyOutputStream 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476) 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - at org.apache.hop.core.plugins.HopURLClassLoader.loadClassFromThisLoader(HopURLClassLoader.java:66) 2022/08/17 11:47:59 - PostgreSQL Bulk Loader.0 - at org.apache.hop.core.plugins.HopURLClassLoader.loadClass(HopURLClassLoader.java:91)
3. When moving the "postgresql-42.3.3.jar" from \hop\plugins\databases\postgresql to \hop\lib insted of "HOP_SHARED_JDBC_FOLDER" then the error does NOT occur.