Problems with RTC Jetty based setup - What is c:\testDB?
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)
|
4 answers
|
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.
|
|
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.
|
Ralph Schoon (61.8k●3●36●43)
| 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).
|
|
Ralph Schoon (61.8k●3●36●43)
| answered Aug 13 '18, 7:35 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Marko,
|
Comments
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.