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.
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.
3 answers
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
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
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.