1. Home
  2. Development
  3. RE: RE: Issues connecting with HSQL Database in local environment

RE: RE: Issues connecting with HSQL Database in local environment

Olaf Kock, modified 3 Years ago.
Issues connecting with HSQL Database in local environment
New Member Posts: 2 Join Date: 7/26/22 Recent Posts

When I am trying to view public schema files, I am getting this error - user lacks privilege or object not found: ADDRESS / Error Code: -5501 / State: 42501.

thumbnail
Olaf Kock, modified 3 Years ago.
RE: Issues connecting with HSQL Database in local environment
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts

Any steps leading up to this? Do you actually have permissions on the file system? Which version do you use?

Just an error message without context makes it hard to guess

Olaf Kock, modified 3 Years ago.
RE: Issues connecting with HSQL Database in local environment
New Member Posts: 2 Join Date: 7/26/22 Recent Posts

Thanks for your response. 
I installed DXP 7.4 which comes with default database HSQL. 
When I create an Object in liferay, I would like to know which tables they get stored in and which schema?

I can see that record in the lportal txt document, But I am not able see public schema tables in hsql database manager. 
Are there any specific changes we need to do to connect to hsql database manager 

thumbnail
Olaf Kock, modified 3 Years ago.
RE: RE: Issues connecting with HSQL Database in local environment
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts

Recommendation: configure a proper database if you want to access it to look at it. HSQL database manager might conflict with Liferay's accessing the database file, and HSQL is only for debugging anyway. Your problems might be lock-related and go away if you use a proper database.

That being said, my recommendation in general is to not look at the database at all.