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

RESOLVED: Cannot config database using Setup Wizard

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

Permanent link
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

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

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


Permanent link
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
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.

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