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

RESOLVED: Cannot config database using Setup Wizard

Questions
Tags
Users
Badges
Thomas Loeber
JAZZ DEVELOPER (622●3●79●50) Sep 29 '11, 7:32 a.m.
Running the setup wizard for 3.0.1 I get this error on the Configure Database step ...
Invalid database URL syntax: jdbc:db2://thlrational.rtp.raleigh.ibm.com:50000/JTS:user=db2admin;password={password}. ERRORCODE=-4461, SQLSTATE=42815

I'm using this syntax for the JDBC Location
//thlrational.rtp.raleigh.ibm.com:50000/JTS:user=db2admin;password={password}

I'm running the setup wizard from a different host then the server and db2 is installed on the same host (thlrational.rtp.raleigh.ibm.com) as the JTS server.
Whats wrong with the JDBC Location syntax I'm using.

0 votes

3 answers
15,187 views
0 votes

3 answers

Permanent link
Thomas Loeber
JAZZ DEVELOPER (622●3●79●50) Sep 29 '11, 7:37 a.m.
Running the setup wizard for 3.0.1 I get this error on the Configure Database step ...
Invalid database URL syntax: jdbc:db2://thlrational.rtp.raleigh.ibm.com:50000/JTS:user=db2admin;password={password}. ERRORCODE=-4461, SQLSTATE=42815

I'm using this syntax for the JDBC Location
//thlrational.rtp.raleigh.ibm.com:50000/JTS:user=db2admin;password={password}

I'm running the setup wizard from a different host then the server and db2 is installed on the same host (thlrational.rtp.raleigh.ibm.com) as the JTS server.
Whats wrong with the JDBC Location syntax I'm using.


I left off the ending ";". This now works just fine

1 vote

Comments
Bo Chulindra
JAZZ DEVELOPER Nov 05 '12, 11:15 a.m.

I assume you meant that the problem is that you left off the trailing semi-colon and after adding it, the problem is fixed.

Thomas Loeber
JAZZ DEVELOPER Nov 05 '12, 5:56 p.m.

That's right Bo. Once I attached the semi-colon all was well. Thanks for asking.

Permanent link
Anthony Kesterton
JAZZ DEVELOPER (7.5k●9●180●136) Oct 01 '11, 5:15 a.m.
Running the setup wizard for 3.0.1 I get this error on the Configure Database step ...
Invalid database URL syntax: jdbc:db2://thlrational.rtp.raleigh.ibm.com:50000/JTS:user=db2admin;password={password}. ERRORCODE=-4461, SQLSTATE=42815

I'm using this syntax for the JDBC Location
//thlrational.rtp.raleigh.ibm.com:50000/JTS:user=db2admin;password={password}

I'm running the setup wizard from a different host then the server and db2 is installed on the same host (thlrational.rtp.raleigh.ibm.com) as the JTS server.
Whats wrong with the JDBC Location syntax I'm using.


I left off the ending ";". This now works just fine

Hi Thomas

Interesting, I also had the same problems but fixed it by ADDING a ";"

anthony

0 votes

Permanent link
Ravikanth Chavali
(40●18●24) edited
Feb 04 '15, 2:51 p.m.
Tried to rule out a wrong password senario; And tried a different user and it worked. Later realized the password itself has } closing bracket. And because the connection string has {password} looks like it is took the wrong bracket }. In another scenario, password had ; semicolon that conflicts with the delimiter and took the wrong semicolon as a the delimiter.

0 votes

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

Question asked: Sep 29 '11, 7:32 a.m.

Question was seen: 15,187 times

Last updated: Feb 04 '15, 2:51 p.m.

Confirmation Cancel Confirm