Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

What is the correct format for the Oracle JDBC connection string?

Questions
Tags
Users
Badges
Sudheer Rugbeer
(115●2●18●32) Jun 03 '13, 4:20 a.m.
Good Day

I am attempting to setup CLM 4.0.1 to connect to an Oracle Database (Oracle 11.2.0.3).
I have downloaded the Oracle JDBC driver v6 (ojdbc6.jar) and have configured the appropriate Environment Variable in WAS 8.0.0.3:
ORACLE_JDBC_DRIVER_FILE = /opt/IBM/Jazz/JazzTeamServer/server/ojdbc6.jar

When running jts/setup, I enter the following URL for the JDBC string:
thin:<jtsdbuser>/{password}@//<server>:1521/<servicename>

However, I am getting the following error when testing the connection to the Database:
The configuration test resulted in errors. Resolve the errors to continue. For more details, open the help system and search for CRJAZ1579E.ID CRJAZ1579E
hide details
IO Error: Invalid connection string format, a valid format is: "//host[:port][/service_name]"
IO Error: Invalid connection string format, a valid format is: "//host[:port][/service_name]"
The Connection String used is based on the example in the jts/setup:
Example: thin:jazzDBuser/{password}@//localhost:1521/ORCL

So, if this is invalid, then what is the correct format of the string?
Or could the issue be somewhere else?

Thanks in advance!
Sudheer

0 votes

3 answers
15,815 views
0 votes

Accepted answer

Permanent link
Xuan Jiang
(378●5●8) Jun 03 '13, 4:29 a.m.
Sudheer - your connection string looks correct to me, I believe that the message is 'incorrect' which confuse you, please try to connect to Oracle Service in system console to confirm your Oracle works as expected.

Here is my settings while set DW on Oracle.
data.warehouse.page\:db.jdbc.location=thin\:jazzu01/{password}@//localhost\:1521/DW
Sudheer Rugbeer selected this answer as the correct answer

1 vote

2 other answers

Permanent link
Georg Kellner
(840●5●82●110) Jun 03 '13, 6:31 a.m.
Hi Sudheer,

sometimes the documented string isn't the correct one.
It took some time to get the correct one for our site, it looks like:

thin:jts_db/{password}@db_server:1521:jazz_instance

greetings georg.

0 votes

Permanent link
Sudheer Rugbeer
(115●2●18●32) Jun 07 '13, 8:57 a.m.
Hi,

Thanks to Xuan Jiang and Georg Kellner for responding to my question.

I managed to figure out why I was getting the invalid connection string error.
Turns out this was due to the fact that the DB user password had an @ sign in it and so the JDBC connection string had two @s and this is why it complained.
We resolved this by changing the password.

The question now though is, does this mean that Oracle DB passwords cannot have the @ sign in it? Or is there a way to 'escape' this @ sign (like \@)?

Regards,
Sudheer

0 votes

Comments
SEC Servizi
May 07 '19, 11:37 a.m.
Or is there a way to 'escape' this @ sign (like \@)? 

You have to wrap the password in quotes (e.g., "p@ssw0rd").

Cheers.

1 vote

Sudheer Rugbeer
May 09 '19, 1:40 a.m.

Thank you, this is quite useful to know!

Your answer

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

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,579
× 42
× 12

Question asked: Jun 03 '13, 4:20 a.m.

Question was seen: 15,815 times

Last updated: May 09 '19, 1:40 a.m.

Confirmation Cancel Confirm