Running Joget Workflow V5 with PostgreSQL

 
1
0
-1

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

    CommentAdd your comment...

    6 answers

    1.  
      1
      0
      -1

      Hi,

      Try 

       

      workflowDriver=org.postgresql.Driver
      #workflowUrl=jdbc\:postgresql\://localhost/jwdb
      workflowUrl=jdbc:postgresql://localhost:5432/jwdb

      JOGER running with postgresql 9.5

      Regards

       

        CommentAdd your comment...
      1.  
        1
        0
        -1

        ...still an error message when importing apps :Validation Error - Error storing data: could not extract ResultSet (Version5)

         

        !!!!!!

         

        1. Owen Ong

          Thx.. we finally found the root cause and fixed it..The fix will be available in next release.. I will let u know. :)

        2. de villers

          Ok, i love mysql but my job prefers postgresql :)

        3. Janak

          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.

        4. de villers

          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.

        5. de villers

          new link : http://dev.joget.org/community/display/KBv5/Running+Joget+Workflow+with+PostgreSQL

        CommentAdd your comment...
      2.  
        1
        0
        -1

        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.  (smile)

        1. Jamsheer

          Same solution worked for me, Is there any version dependency ??i tried with Postgres 9.4

        CommentAdd your comment...
      3.  
        1
        0
        -1

        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?

          CommentAdd your comment...
        1.  
          1
          0
          -1

          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.

           

            CommentAdd your comment...
          1.  
            1
            0
            -1

            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.

              CommentAdd your comment...