Help demonstration example I can't use #421

Activity

1. jcflack commented on Mar 11, 2023

   

   jcflack

   on Mar 11, 2023

   Contributor

   More actions

   Hi,

   Can you include the output of the following?

   SELECT schemaname, jarname
     FROM sqlj.classpath_entry NATURAL JOIN sqlj.jar_repository
     ORDER BY schemaname, ordinal;
   
   SHOW pljava.classpath;
   SHOW search_path;

   Very often, an issue like what you are reporting will have an explanation among those settings.
2. exqmjmz commented on Mar 11, 2023

   

   exqmjmz

   on Mar 11, 2023

   Author

   More actions

   SELECT schemaname, jarname
     FROM sqlj.classpath_entry NATURAL JOIN sqlj.jar_repository
     ORDER BY schemaname, ordinal;
   
   SHOW pljava.classpath;
   SHOW search_path;

   SELECT schemaname, jarname
   FROM sqlj.classpath_entry NATURAL JOIN sqlj.jar_repository
   ORDER BY schemaname, ordinal;
   return:

   schemaname jarname
   public pgjar

   SHOW pljava.classpath;
   return:

   ERROR: unrecognized configuration parameter "pljava.classpath"

   SHOW search_path;
   return:

   search_path
   public, "$user", public
3. jcflack commented on Mar 11, 2023

   

   jcflack

   on Mar 11, 2023

   Contributor

   More actions

   Oops, sorry, I copied the show pljava.classpath from an older issue, before the variable name changed. It would be show pljava.module_path in recent versions.

   But even that might be less important here than

   SELECT sqlj.get_classpath('public');
4. exqmjmz commented on Mar 11, 2023

   

   exqmjmz

   on Mar 11, 2023

   Author

   More actions

   Oops, sorry, I copied the show pljava.classpath from an older issue, before the variable name changed. It would be show pljava.module_path in recent versions.

   But even that might be less important here than

   SELECT sqlj.get_classpath('public');

   It's all right, glad you helped!
   return:

   get_classpath
   pgjar
5. jcflack commented on Mar 11, 2023

   

   jcflack

   on Mar 11, 2023

   Contributor

   More actions

   This may show more:

   \c
   SET client_min_messages TO debug1;
   CREATE OR REPLACE FUNCTION test_pljava(query TEXT) RETURNS TEXT AS 'com.kamin.pljava.Cases.executeSelect' LANGUAGE java;

   Sometimes during create-time validation, another exception further down the stacktrace may end up looking like the method wasn't found.

   If you don't see more useful output at the client, also take a look in the server log afterward.
6. jcflack commented on Jun 7, 2023

   

   jcflack

   on Jun 7, 2023

   Contributor

   More actions

   Was there any resolution?
7. jcflack commented on Apr 5, 2024

   

   jcflack

   on Apr 5, 2024

   Contributor

   More actions

   Closed waiting on reporter
8. jcflack

   closed this as completedon Apr 5, 2024