Problem During Update -addTable CLM6.0.4 to ELM7.0.2 Invalid database URL syntax com.ibm.db2.jcc.am.SqlSyntaxErrorException:
Greetings,
i am upgrading from clm 6.0.4 to elm 7.0.2
i have installed the product and i am launching the upgrade of the jts
upgrade / jts / jts_upgrade.sh -oldJTSHome / server / conf
point to the old
configuration of the CLM version 6
during the
addTable I get this error:
2022-06-16 16: 15: 18,604 Repo Tools
2022-06-16 16: 15: 18,604 java.version = 1.8.0_261
2022-06-16 16:15: 18,604 java.runtime.version = 8.0.6.15 - pxa6480sr6fp15-20200724_01 (SR6 FP15)
2022-06-16 16: 15: 18,608 Provisioning using "./conf/jts/provision_profiles".
2022-06-16 16: 15: 18,626 repotools-jts -addTables
2022-06-16 16: 15: 18,648
To submit questions about issues, go to the Jazz.net forum at https://jazz.net/forum.
To find more information about a message, see the online product documentation.
2022-06-16 16: 15: 18,648 CRJAZ1363I Loading the configuration from "file: conf / jts / teamserver.properties".
2022-06-16 16: 15: 22,634 CRJAZ1779I This server is configured as a JTS.
2022-06-16 16: 15: 22,809 CRJAZ1365I The server is attempting to connect to the following database: "//db.sviluppo.pico.trn:60008/JTS:user=xxxxxxxx;password=xxxxxxxx"
2022-06-16 16: 15: 22,893 CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 42815, SQLCODE: -4461). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information.
com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc] [10165] [10051] [4.26.14] Invalid database URL syntax: jdbc: db2: //db.sviluppo: 60008 / JTS: user = xxxxxx; password = {xxxxxxx}. ERRORCODE = -4461, SQLSTATE = 42815
it is the same configuration of the old version where it connects and the process goes up correctly, while in the new version 7.0.2 it fails to connect to the same db with the same configurations, I also tried to change the syntax of the string but it changes nothing, I don't understand because in the old version 6.0.4 the connection happens correctly with the db while in the version 7.0.2 it gives me this error
example of some original syntax working on the old version and testing on the new one with negative result
com.ibm.team.repository.db.jdbc.location=//sviluppo.trn\:60008/JTS\:user\=xxxxxx;password\=xxxxxxx
com.ibm.team.repository.db.jdbc.location=//sviluppo.trn:60008/JTS:user=xxxxxx;password={xxxxxxx}
can you provide me with information on this?
thanks
Accepted answer
Not sure if this is the reason for your problem in 7.0.2, but it would be normal for teamserver.properties to use two lines to specify the connection string and the password separately, details below. Maybe the syntax checking of the connection string has been tightened up.