It's all about the answers!

Ask a question

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


Marko Tomljenovic (31648109) | asked 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)


Comments
Marko Tomljenovic commented 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



permanent link
Marko Tomljenovic (31648109) | answered 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.


permanent link
Marko Tomljenovic (31648109) | answered 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.


permanent link
Ralph Schoon (63.2k33646) | answered Aug 13 '18, 6:59 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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).


permanent link
Ralph Schoon (63.2k33646) | answered Aug 13 '18, 7:35 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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.

Your answer


Register or 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.