The users are in database ...\bonita_journal.db and the relevant tables are
- Group_
- Profile
- Profileentry (not sure about this one...
- Profilemember
- Role
- User_
- User_ContactInfo
- User_Login
- User_Membership
regards
Seán
PS: As this reply answers your question, please mark as resolved.
Comments
Thank you
Best regards
In my Bonita database I have these tables (I put them all down)
The tables that you said I do not have (the USERS table is of users that access the BBDD), I need the table of users that enter the portal of Bonita
I have a free version of Bonita, is that the problem?
CATALOGS
COLLATIONS
COLUMNS
COLUMN_PRIVILEGES
CONSTANTS
CONSTRAINTS
CROSS_REFERENCES
DOMAINS
FUNCTION_ALIASES
FUNCTION_COLUMNS
HELP
INDEXES
IN_DOUBT
LOCKS
QUERY_STATISTICS
RIGHTS
ROLES
SCHEMATA
SEQUENCES
SESSIONS
SESSION_STATE
SETTINGS
TABLES
TABLE_PRIVILEGES
TABLE_TYPES
TRIGGERS
TYPE_INFO
USERS
VIEWS
That is not the Bonita Database, that is a database that you've created called bonita_journal_etc.
This is a common problem when accessing h2 databases,
for your connection string you must only call it bonita_journal.db do not call it bonita_journal.db.h2.db
The h2 driver adds the h2.db automatically.
So if you open the folder
{{ bonitaInstallDir }}\workspace\default\h2_database
you will find you've created a invalid empty database called bonita_journal.db.h2.db.h2.db you can safely delete this
regards
Seán
Hi,
I'm having trouble accessing the database, sometimes it works for me sometimes, what file should I run to open the database?
I have many same files on directories called "h2-1.3.175.jar" and "h2-1.3.170.jar"
In the following path: "{{bonitaInstallDir}} \ workspace \ default \ h2_database" There is no file "bonita_journal.db", there is only the file "bonita_journal.db.h2.db" that I just deleted as you told me
What is the fastest and easiest way to open the Bonita database?
Thank you very much
Best regards
I searched the Bonita directory and there is no file named: "bonita_journal.db"
After deleting the file you told me, it does not work for me. I can not log in to localhost, nor can I run the Bonita portal. I'm going to uninstall and reinstall Bonita on my machine
And is it possible to select this data in a connector? And how can I select these data and display them to check the users already registered?