Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Problems with RTC Jetty based setup - What is c:\testDB?

Questions
Tags
Users
Badges
Marko Tomljenovic
(316●50●109) Apr 30 '18, 3:08 a.m.

Hello,

we are internally using the RTC Jetty based setup to develop and locally test our RTC server side extensions. Till 6.0.4 this was always working more or less fine.
When updating to 6.0.5 I came across some strange behaviour. After running the Workshop-setup script for creating one example project area I can see in the log a reference to a database located at c:\testDB. But in none of the server startup launch configuration system properties this location is referenced. Where is this configuration coming from? The (main) database is defined to be located in another place.

08:53:51,660 [qtp842144996-102 @@ 08:53 TestJazzAdmin1 <Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.117 Safari/537.36@0:0:0:0:0:0:0:1> /jazz/service/com.ibm.team.reports.common.internal.service.IReportRestService/renderQuery]  INFO .repository.service.internal.rdb.ConnectionFactory  - CRJAZ1365I The server is attempting to connect to the following database: "c:\testDB"
08:53:52,142 [qtp842144996-102 @@ 08:53 TestJazzAdmin1 <Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.117 Safari/537.36@0:0:0:0:0:0:0:1> /jazz/service/com.ibm.team.reports.common.internal.service.IReportRestService/renderQuery]  INFO .repository.service.internal.rdb.ConnectionFactory  - CRJAZ1364I The connection to the following database was successful:
08:53:52,147 [qtp842144996-102 @@ 08:53 TestJazzAdmin1 <Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.117 Safari/537.36@0:0:0:0:0:0:0:1> /jazz/service/com.ibm.team.reports.common.internal.service.IReportRestService/renderQuery]  INFO tawarehouse.service.internal.RemoteDatabaseService  - CRRTC8039I The connection to the following data warehouse database was successful:
 DB Product Name: Apache Derby
  DB Product Version: 10.10.2.0 - (1582446)
  DB URL: c:\testDB
  JDBC Driver Name: Apache Derby Embedded JDBC Driver
  JDBC Driver Version: 10.10.2.0 - (1582446)

0 votes

Comments
Marko Tomljenovic
Apr 30 '18, 3:14 a.m.

WHen searching for the text c:\testDB I found out that somehow the Unit tests for creating the data base are using this path somehow. But when running the tests I am already providing a different path for creating the database. And this is working fine, the database is created in my own custom folder.

4 answers
2,145 views
0 votes

4 answers

Permanent link
Marko Tomljenovic
(316●50●109) Apr 30 '18, 8:24 a.m.

The problem seems to be a problem in the SDK where the predefined configuration/setup of the derby data warehouse is not correct, see https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=456295

If I give this system parameter during startup com.ibm.team.datawarehouse.db.jdbc.location=.... and then run the "Custom setup" on the server then the database is properly setup and in addition always this location is used for the data warehouse.

0 votes

Permanent link
Marko Tomljenovic
(316●50●109) Apr 30 '18, 8:25 a.m.

See my comment above.


It would be good to either fix this problem in the SDK or add the above mentioned system property to the RTC extension workshop launch configuration files.

0 votes

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.0k●3●36●48) Aug 13 '18, 6:59 a.m.

I was able to reproduce it. The database gets created when running the setup for the test/debug Jetty RTC server. I am not sure what changed, when this started and what to do that the DB gets created somewhere where it does not cause issues (e.g. in the location where the rest is stored).

0 votes

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.0k●3●36●48) Aug 13 '18, 7:35 a.m.

Marko,

as far as I can tell, the database c:\TestDB only gets created when one runs a setup against the "Jetty RTC Server.launch" launch. I can not find that this should be done in the workshop. You only log in and assign a license. You also create a project area, but that does not trigger creation of the data warehouse. Only running a setup seems to do that.

It can be avoided by adding the following line to the Jetty RTC Server.launch (e.g. as line 51):

<listEntry value="com.ibm.team.datawarehouse.db.jdbc.location|value=${workspace_loc}/../server/conf/jazz/derby/warehouseDB"/>

Please note that the setup fails due to missing lifecycle admin capabilities and you have to use the custom setup.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,951

Question asked: Apr 30 '18, 3:08 a.m.

Question was seen: 2,145 times

Last updated: Aug 13 '18, 7:35 a.m.

Confirmation Cancel Confirm