It's all about the answers!

Ask a question

Help with moving from Derby to Oracle DB


Bill Miner (61103) | asked Jun 09 '10, 4:44 p.m.
Hi All,

Very new to this... I have configured the teamserver.properties in Jazz to contain the following:

com.ibm.team.repository.db.vendor=ORACLE
com.ibm.team.repository.db.jdbc.location=thin:jazzdb/{password}@ussy-qumasdevora:1524/jazzdb
com.ibm.team.repository.db.jdbc.password=
//DCQUEST=
// (DESCRIPTION=
// (ADDRESS=
// (PROTOCOL=TCP)
// (HOST=ussy-qumasdevora)
// (PORT=1524)
// )
// (CONNECT_DATA=
// (SERVER=dedicated)
// (SERVICE_NAME=dcquest)
// )
// )

But I get the following error from Oracle:

Io exception: Invalid connection string format, a valid format is: "host:port:sid"

"ussy-qumasdevora:1524/jazzdb" is there so what is wrong?

2 answers



permanent link
Thomas Yu (101199) | answered Jun 11 '10, 11:14 p.m.
Your connection string is:
thin:jazzdb/{password}@some-server:1524/jazzdb

If I were you, I would use this one:
thin:jazzdbuser/{password}@some-server:1521/jazzdb

regards!

permanent link
Bill Miner (61103) | answered Aug 25 '10, 12:28 p.m.
Thanks for the input... after more very careful reading I fixed the issue with:

com.ibm.team.repository.db.vendor=ORACLE
com.ibm.team.repository.db.jdbc.location=thin:jazzdbuser/{password}@//ussy-qumasdevora:1524/jazzdb
com.ibm.team.repository.db.jdbc.password=

didn't know that jazzdbuser = schema

Your answer


Register or to post your answer.