Thu, 24 Sep 2026
Login

Use Joget DX 7 with existing database

Confluence User - 14 Dec, 2022

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?


server

2

Confluence User •
15 Dec, 2022 •
confluenceUser •
1 •
confluenceUser •

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.


Confluence User •
15 Dec, 2022 •
confluenceUser •
•
confluenceUser •

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.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
i am building an app, and for some reason i am not able to open it anymore. All apps --> my app --> system error
How to Fix CSRF (j_spring_security_check after login) when doing Reverse Proxy Joget (tomcat) with Cloudflare (globally) ?
How to transfer all files and users data from on-premise to on-demand server?
how to generate the unique ID using textField
how to log into Power BI while logged into Joget
Error java.io.IOException: Broken pipe from org.joget.commons.spring.web.CustomDelegatingFilterProxy
Building AI Agents with Joget Workflow
Building AI Agents with Joget
Email Not Sending
Hyperlink needs loggin
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print