Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 05:33 Go to next message
pyntamil selvi is currently offline pyntamil selviFriend
Messages: 21
Registered: September 2015
Junior Member
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 13:28 Go to previous messageGo to next message
Achim Loerke is currently offline Achim LoerkeFriend
Messages: 376
Registered: July 2009
Location: Braunschweig, Germany
Senior Member

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 05:49 Go to previous messageGo to next message
pyntamil selvi is currently offline pyntamil selviFriend
Messages: 21
Registered: September 2015
Junior Member
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 186 times)
Re: How to view the contents of embedded.h2.db file [message #1711832 is a reply to message #1711741] Tue, 20 October 2015 05:50 Go to previous messageGo to next message
pyntamil selvi is currently offline pyntamil selviFriend
Messages: 21
Registered: September 2015
Junior Member
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 176 times)
Re: How to view the contents of embedded.h2.db file [message #1711833 is a reply to message #1711653] Tue, 20 October 2015 05:53 Go to previous messageGo to next message
pyntamil selvi is currently offline pyntamil selviFriend
Messages: 21
Registered: September 2015
Junior Member
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 182 times)
Re: How to view the contents of embedded.h2.db file [message #1711834 is a reply to message #1711741] Tue, 20 October 2015 05:53 Go to previous messageGo to next message
pyntamil selvi is currently offline pyntamil selviFriend
Messages: 21
Registered: September 2015
Junior Member
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
Re: How to view the contents of embedded.h2.db file [message #1711835 is a reply to message #1711741] Tue, 20 October 2015 05:53 Go to previous messageGo to next message
pyntamil selvi is currently offline pyntamil selviFriend
Messages: 21
Registered: September 2015
Junior Member
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
Re: How to view the contents of embedded.h2.db file [message #1711836 is a reply to message #1711741] Tue, 20 October 2015 05:54 Go to previous messageGo to next message
pyntamil selvi is currently offline pyntamil selviFriend
Messages: 21
Registered: September 2015
Junior Member
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
Re: How to view the contents of embedded.h2.db file [message #1711838 is a reply to message #1711741] Tue, 20 October 2015 05:58 Go to previous messageGo to next message
pyntamil selvi is currently offline pyntamil selviFriend
Messages: 21
Registered: September 2015
Junior Member
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
Re: How to view the contents of embedded.h2.db file [message #1711931 is a reply to message #1711831] Tue, 20 October 2015 10:40 Go to previous message
Achim Loerke is currently offline Achim LoerkeFriend
Messages: 376
Registered: July 2009
Location: Braunschweig, Germany
Senior Member

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:
  


Current Time: Wed Feb 28 07:40:45 GMT 2024

Powered by FUDForum. Page generated in 0.02522 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top