Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » Jubula » Providing custom location for Jubula H2 Database(How can we provide custom location for Jubula H2 Database on command line)
Providing custom location for Jubula H2 Database [message #1720237] Fri, 15 January 2016 13:49 Go to next message
Irfan Khaliq is currently offline Irfan KhaliqFriend
Messages: 20
Registered: August 2014
Junior Member
By default Jubula uses H2 database at ~/.jubula/database/embedded location. How can we choose a different location for the database.

I know we can do it from ITE preferences. But I am more interested in command line case. How can we provide a custom location of database to dbtool and testexec tools? I want to keep more than one H2 databases on SAME machine and choose the required whenever needed.

Is this possible to achieve that?

Thanks.
Irfan

[Updated on: Fri, 15 January 2016 15:11]

Report message to a moderator

Re: Providing custom location for Jubula H2 Database [message #1720260 is a reply to message #1720237] Fri, 15 January 2016 15:32 Go to previous messageGo to next message
Irfan Khaliq is currently offline Irfan KhaliqFriend
Messages: 20
Registered: August 2014
Junior Member
The dburl option might work. I was able to establish a connection but I need to confirm its working using testexec tool.

C:\Program Files\jubula_8.0.00170\jubula>dbtool.exe -dburl jdbc:h2:C:\jubula\database;MVCC=True;AUTO_SERVER=TRUEDB_CLOSE_ON_EXIT=FALSE -dbpw "" -dbuser sa
Fri Jan 15 20:29:33 PKT 2016    Commandline parsing finished - performing actions...
Fri Jan 15 20:29:33 PKT 2016    Database:       Connecting as "sa" to "jdbc:h2:C:\jubula\database;MVCC=True;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE"...
Fri Jan 15 20:29:36 PKT 2016    Database:       Connection established.
Fri Jan 15 20:29:36 PKT 2016    Exit:           Code 0

Report message to a moderator

Re: Providing custom location for Jubula H2 Database [message #1720362 is a reply to message #1720260] Mon, 18 January 2016 08:26 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra SchladebeckFriend
Messages: 1613
Registered: July 2009
Senior Member
The dburl will let you identify a database location, yes.

Report message to a moderator

Re: Providing custom location for Jubula H2 Database [message #1720363 is a reply to message #1720362] Mon, 18 January 2016 08:33 Go to previous messageGo to next message
Irfan Khaliq is currently offline Irfan KhaliqFriend
Messages: 20
Registered: August 2014
Junior Member
Alex,

I have a couple of questions:
1. Should dburl work for both dbtool and testexec?
2. Do you see any problems in using more than one H2 databases for Jubula on same host machine?

Report message to a moderator

Re: Providing custom location for Jubula H2 Database [message #1720396 is a reply to message #1720363] Mon, 18 January 2016 11:38 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra SchladebeckFriend
Messages: 1613
Registered: July 2009
Senior Member
Hello,

Yes, the dburl parameter is available in the dbtool as well:
http://help.eclipse.org/mars/topic/org.eclipse.jubula.client.ua.help/content/html/userManual/tasks/useDBToolClient/parameters-for-the-dbtool.html?cp=44_2_25_2

We don't recommend using the H2 database for productive use, as it simply doesn't scale. We test with Oracle, and there are users that use MySQL / Postgres.
As for having two databases - what are your reasons for doing this? We use two databases, for example, to be able to "push" productive tests once they are complete (i.e. so we're not working in the productive database instance). If that's your aim, then it should be fine, however, I've never tried out the situation using H2 databases.

Best regards,
Alex

Report message to a moderator

Re: Providing custom location for Jubula H2 Database [message #1720400 is a reply to message #1720396] Mon, 18 January 2016 11:58 Go to previous messageGo to next message
Irfan Khaliq is currently offline Irfan KhaliqFriend
Messages: 20
Registered: August 2014
Junior Member
Alex,

Is there any documentation available which can be used as a reference to move my tests from H2 database to any other database, i.e Oracle, MySQL?

And regarding using two instances of database, I need to test a product which supports eclipse4 as well as eclipse3. So, I have two different copies of Jubula tests due to mapping changes in product. Instead of importing tests into single common instance of database, I want to use two different instances.

Report message to a moderator

Re: Providing custom location for Jubula H2 Database [message #1720402 is a reply to message #1720400] Mon, 18 January 2016 12:52 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra SchladebeckFriend
Messages: 1613
Registered: July 2009
Senior Member
Hi Irfan,

you can migrate a project to another database simply by exporting it from one and importing it into another.

I don't think you need two databases in your case. You can create one project in one database, and define two AUTs. Each AUT has a different object mapping, but can use the same test specification.

Hope that helps,
Alex

Report message to a moderator

Re: Providing custom location for Jubula H2 Database [message #1721543 is a reply to message #1720402] Thu, 28 January 2016 08:45 Go to previous message
Irfan Khaliq is currently offline Irfan KhaliqFriend
Messages: 20
Registered: August 2014
Junior Member
I have confirmed that dburl option works with both dbtool and testexec tools. Hence, we can use it to provide custom location of the database during testing.

Report message to a moderator

Previous Topic:Problem of import
Next Topic:RCP AUT is started but the AUT progress is still running
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 18:16:54 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly