Dear Joget Community,
Is it possible in the cloud environment to use Java and SQL integrations?
In my local Joget environment I use Java code to access tables with SQL and populate fields:
SELECT Toezichthouder.c_id, Toezichthouder.c_Naam, Toezichthouder.c_Email FROM app_fd_klachten as Klachten, app_fd_plaatsen as Plaatsen, app_fd_organisaties as Veroorzaker, app_fd_organisaties as Toezichthouder WHERE Klachten.c_OrganisatieID = Veroorzaker.c_id AND Veroorzaker.c_Plaats = Plaatsen.c_Plaatsnaam AND Plaatsen.c_OrganisatieID = Toezichthouder.id AND Klachten.c_KlachtID = 'ID-000054'
This works OK in my local environment but in the cloud I get the following error :
Exception = com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jwc_vdschoot.app_fd_klachten' doesn't exist
This error states that a referenced table does not exists, which is strange.
Maybe I need a more specific table path in the definition , but that would make the code dependent on the environment.
Thanks for the help,
Joost van der Schoot