Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Hi,
Try
workflowDriver=org.postgresql.Driver
#workflowUrl=jdbc\:postgresql\://localhost/jwdb
workflowUrl=jdbc:postgresql://localhost:5432/jwdb
JOGER running with postgresql 9.5
Regards
...still an error message when importing apps :Validation Error - Error storing data: could not extract ResultSet (Version5)
!!!!!!
Thx.. we finally found the root cause and fixed it..The fix will be available in next release.. I will let u know. :)
Ok, i love mysql but my job prefers postgresql :)
Hi Owen Ong / De Villers, if you share the short summary with steps followed, its will help for forum members, as I too Plan to upgrade joget from V4 to V5 and thinking for opt Postgres as DB.
Hi Janak, as the bug is fixed, you may just follow exactly same steps in this http://dev.joget.org/community/display/KBv4/Running+Joget+Workflow+with+PostgreSQL (Running Joget Workflow with PostgreSQL). And then you'll can migrate your apps.
Hi,
yes it works !
Thanks a lot.
So data tables are empty.
After having imported my apps in the new portal, I'm trying to insert data from mysql to postgresql data tables.
Same solution worked for me, Is there any version dependency ??i tried with Postgres 9.4
Hi, i just following exactly same steps in this Running Joget Workflow with PostgreSQL, it seem to work without issue. I am running PostgreSQL 9.4.5 with Joget enterprise RC3. Since i can't replicate ur issue, i have no idea how to help u. Sorry. May be u can redo all the steps to following the steps in the above article again?
Hello Owen,
thanks for your reply.
I restarted tomcat...
I directly modified the app_datasource-xxx.properties files as described in the Running Joget with PostgreSQL in V4.
the app_datasource-postgresql.properties :
#
#Tue Nov 03 17:38:06 CET 2015
workflowDriver=org.postgresql.Driver
workflowUrl=jdbc\:postgresql\://localhost/jwdb
workflowUser=postgres
workflowPassword=postgres
the joget.log :
INFO 04 nov. 2015 16:11:39 org.joget.commons.util.SetupManager - Using base directory: ./wflow/
INFO 04 nov. 2015 16:11:43 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:postgresql://localhost/jwdb, user=postgres
INFO 04 nov. 2015 16:11:49 org.joget.commons.util.SetupManager - Initializing setup cache
INFO 04 nov. 2015 16:11:49 org.joget.plugin.base.PluginManager - PluginManager initialized
INFO 04 nov. 2015 16:11:59 org.joget.workflow.model.service.WorkflowManagerImpl - Datasource bound to jwdb
INFO 04 nov. 2015 16:12:00 org.displaytag.filter.ResponseOverrideFilter - Filter initialized. Response buffering is enabled
INFO 04 nov. 2015 16:12:17 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:postgresql://localhost/jwdb, user=postgres
INFO 04 nov. 2015 16:12:18 org.joget.commons.util.SetupManager - Initializing setup cache
INFO 04 nov. 2015 16:12:18 org.joget.plugin.base.PluginManager - PluginManager initialized
INFO 04 nov. 2015 16:12:20 org.joget.workflow.model.service.WorkflowManagerImpl - Datasource bound to jwdb
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
Position : 35
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
Position : 35
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
Position : 35
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
Position : 35
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
Position : 35
We can see the name of the table has changed "resourcebu0_" instead of "wf_resource_bundle_message" in the mysql database and the postgreSQL database too.
What is the exception in the log file? You may need to restart tomcat after switching Datasource to let Hibernate to update your database schema.
Hello,
i have tried to connect joget workflow v5 with postgreSQL but it did not work.
i have converted the existing mysql base in a postgresql base.
I think the datasource properties from V4 (running joget workflow with postgresql community article) have changed in V5.
When switching Datasource & Profile Settings, the Database test is OK on Save.
But the Joget Workflow Enterprise App Center cannot be loaded
Thank you for your help,
Frederic