It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787

question asked: Jun 09 '10, 4:44 p.m.
question was seen: 4,447 times
last updated: Jun 09 '10, 4:44 p.m.

Related questions

FAQ - How this Forum works

Help with moving from Derby to Oracle DB

0
Bill Miner (61●10●3) | 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

Most liked answers ↓|Newest answers|Oldest answers

0
permanent link
Bill Miner (61●10●3) | 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
0
permanent link
Thomas Yu (101●1●19●9) | 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!

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.