I have tried to reproduce the issue by the description, but in my environment, everything works well.
Does the problem still occur? If yes, could you provide some details:
Which version of the platform do you use? Have you migrated the project from some of the previous versions?
Do you use the same database for the launched by Studio application and deployed to Tomcat one?
Could you also share the whole log one more time? As the file was lost during the forum maintenance.
Hi,
In my environment, everything still works well. With the Oracle DB - too.
Try to deploy the WAR to a brand-new tomcat. Maybe, this could help.
Or clean the tomcat before deployment: remove work, app_home folders, and app, app-core from the webapps directory.
One more assumption. In your log, we have found that cuba.dbmsType is set to HSQLDB. But you have said that you use Oracle.
DBMS type and context.xml should correspond to each other. Also before building the WAR, DB-scripts for the runtime DBMS should be generated.
So it is recommended to use the same DBMS type in both: development- and runtime.
It seems the issue is there as you wrote that the application works well when launched from Studio.
Read the documentation if you did not see it before: WAR deployment to Tomcat Windows Service - CUBA Platform. Developer’s Manual
Thanks for your help, I guess the HSQLDB configuration was helding me back. I restarted the project all over again and this time it worked, just took me 6 days to rebuild that stuff.
Anyway if it was the real problem here I think the error message could be improved a little bit. As I got no HSQLDB on any of my environnements I dont know why there was no error in the logs related to a potential connection issue with the database.
You can now close this thread.
Thank you again for the investigation on your end, really appreciated.