Eclipse Community Forums: Jubula » How to view the contents of embedded.h2.db file

Home » Archived » Jubula » How to view the contents of embedded.h2.db file(How to view the contents of embedded.h2.db file created in the .jubula folder)

How to view the contents of embedded.h2.db file [message #1711653]

Mon, 19 October 2015 01:33

Eclipse User

Hi,

I would like to view the structure of tables used by Jubula for storing the Testcases.I found the embedded.h2.db ,embedded.trace.db,embedded_8.1.lock.db,embedded_8.1.trace.db files in the .jubula folder.But when I try opening the folder it shows data is in encrypted format.Can someone tell how to view the structure of tables?

Thanks in advance,
Pyntamil.

Re: How to view the contents of embedded.h2.db file [message #1711741 is a reply to message #1711653]

Mon, 19 October 2015 09:28

Eclipse User

Jubula uses H2 as a database to store data for evaluation purposes. It is not recommended for production use.

That being said, H2 is described at http://www.h2database.com/
You can download tools for inspecting the database.
Please be advised that the db schema is not guaranteed to keep the same between releases. Since we use a JPA and EclipseLink as the provider we actually have no control over changes once we change the EclipseLink version.

- Achim

Re: How to view the contents of embedded.h2.db file [message #1711831 is a reply to message #1711741]

Tue, 20 October 2015 01:49

Eclipse User

Hi ,
Thanks for ur reply.We are trying to understand how testcases are stored in database.For production we are planning to use other database not h2 as recommended by jubula.
I tried opening the embedded.h2.db file using RasorSQL tool but it shows only the system tables information.We actually want to view the content following db schema ,how testcases are stored,how project details are stored etc.Any help in this will be highly usefull.

P.S : PFA of table sturcture obtained using RasorSQL tool

Attachment: RasorSQL.png
(Size: 196.95KB, Downloaded 215 times)

Re: How to view the contents of embedded.h2.db file [message #1711832 is a reply to message #1711741]

Tue, 20 October 2015 01:50

Eclipse User

Hi,
Thanks for ur reply.We are trying to understand how testcases are stored in database.For production we are planning to use other database not h2 as recommended by jubula.
I tried opening the embedded.h2.db file using RasorSQL tool but it shows only the system tables information.We actually want to view the content following db schema ,how testcases are stored,how project details are stored etc.Any help in this will be highly usefull.

P.S : PFA of table sturcture obtained using RasorSQL tool

Attachment: RasorSQL.png
(Size: 196.95KB, Downloaded 207 times)

Re: How to view the contents of embedded.h2.db file [message #1711833 is a reply to message #1711653]

Tue, 20 October 2015 01:53

Eclipse User

Thanks for ur reply.We are trying to understand how testcases are stored in database.For production we are planning to use other database not h2 as recommended by jubula.
I tried opening the embedded.h2.db file using RasorSQL tool but it shows only the system tables information.We actually want to view the content following db schema ,how testcases are stored,how project details are stored etc.Any help in this will be highly usefull.

P.S : PFA of table sturcture obtained using RasorSQL tool

Attachment: RasorSQL.png
(Size: 196.95KB, Downloaded 213 times)

Re: How to view the contents of embedded.h2.db file [message #1711834 is a reply to message #1711741]

Tue, 20 October 2015 01:53

Eclipse User

Re: How to view the contents of embedded.h2.db file [message #1711835 is a reply to message #1711741]

Tue, 20 October 2015 01:53

Eclipse User

Re: How to view the contents of embedded.h2.db file [message #1711836 is a reply to message #1711741]

Tue, 20 October 2015 01:54

Eclipse User

Re: How to view the contents of embedded.h2.db file [message #1711838 is a reply to message #1711741]

Tue, 20 October 2015 01:58

Eclipse User

Re: How to view the contents of embedded.h2.db file [message #1711931 is a reply to message #1711831]

Tue, 20 October 2015 06:40

Eclipse User

Sorry, I cannot help you here. We normally do not look at the database directly since the schema is generated by EclipseLink.

To understand how the data is modelled you should take a look at the sources of Jubula. The persistence layer uses JPA annotations on the Java classes. All data classes have names ending ind PO (persistent object). Search the org.eclipse.jubula.client.core bundle for the org.eclipse.jubula.client.core.model package.

Once again: this is not part of a public API and will change between releases!

- Achim

Previous Topic:	Is there a way to modify external DB Tables from within a Jubula test ?
Next Topic:	How to build Jubula using Maven from command promt in unix

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 02:39:00 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter