Issue while reading data from H2 database within studio 6.2

Q&A
1

Hi All,

How can we read data from H2 DB which is saved from any task ?
Because every time we run the application from studio it removes and install app.
Where does it creates H2 database when we run any application from studio.

Thanks
Akhilesh

2

Hello,
Studio is a development environment and by default it is configured to empty the database after each restart. There is a configuration in the Studio (Preferences->Database) that allows you to save your data after each Studio restart, if this is what you want to do.
What we can also suggest is to install a bundle (Bonita+Tomcat or Bonita+JBoss) that would allow you to have a test environment with a database of your choice. You can download it from our website.
Hope this helps,
Haris

3

Thanks Haris for your response.

I understand if we install Bonita bundle on tomcat and we can select DB of our own choice. We can perform diferent DB operation.
But while running application from studio if we uncheck option “Clean Database on exit” under Preferences->Database.

  1. Than can we read form data which is saved from the task , second time when we runn application ?
  2. Actually i am asking this question in regards to reporting. If i have to extract information like who was working on which task.
    Then everytime after making any changes I have to install that app on tomcat then check the data. But this will be time consuming. So how can we make this faster ?

Thanks
Akhilesh

4

Thanks again Haris for your quick response.

But how can I read the data ?
Where is the database created ?
Where are the tables created ?
How can we access this information ?

Can you please give me some pointers.

Thanks
Akhilesh

5

I would recommend you to access to your data using APIs.

6

Thanks for your response.

7

Hello Akhilesh,

Yes, if you uncheck this option in the Studio, data will remain and you will be able to “read” it next time you run your process.

Cheers,
Haris