Use Joget DX 7 with existing database

 
1
0
-1

Hello,

  • For learning I installed on my XAMPP server MariaDB Sakila database
  • Populated it with Sakila sample data
  • In Joget created new app properties file: app_datasource-sakila.properties (Custom Database Configuration)
  • Change in app_datasource.properties value of parameter: currentProfile=sakila
  • Restart Joget 
  • During restart Joget has displayed messages " ... table not existing" and it has created these tables in my Sakila database
  • Unfortunately table sakila.shkprocessstates hasn't been created and this is cause of the big amount  of the SQLException  error messages
  • Final result is for the URL is http://localhost:8080/jw/setup - Sorry,access is forbidden in security reasons. Please refresh the previous form before submitting it.

How to get out of this?


    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, if you are using the Custom Database Configuration then you will need to pre-create the database from the relevant SQL for your database server. It is easier to just remove the app_datasource.properties file and run the database setup using Setting Up Database which will create the database for you.


      1. Jaak Ivask

        Hello,

        Thanks! This way installation went smoothly. Existing Sakila database tables (23) are in place and Joget adds some 100+ additional tables.

        Now the next question is how I can use data from these original Sakila tables. Form builder requires prefix app_fd and my real datatables doesn't have one.

        For example Sakila database has table named film with 1000 films entered. How could I build form/datalist using data from this table.

      CommentAdd your comment...