It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,952

question asked: May 14 '09, 10:35 a.m.
question was seen: 5,145 times
last updated: May 14 '09, 10:35 a.m.

Related questions

Unable to create tables (DB2) in RQM 2.0 beta 1

0
Larry Menard (31●2●1) | asked May 14 '09, 10:35 a.m.
I've installed RQM 2.0 beta 1 on SLES10 SP1. DB2 is also installed and configured correctly (I can connect to the RQM database using CLP, and the TCPIP connectivity seems to be configured correctly).

But when I run repotools.sh to create the tables I get:

2009-05-14 10:18:34,999 CRJAZ0503I Failed to connect to the database: " java.util.Properties object passed to java.sql.Driver.connect() cannot be overridden by URL: jdbc:db2://localhost:50001/RQM:fullyMaterializeLobData=false;user=db2inst1;password=db2passwd;."


I'm fairly new to RQM, but I have recently successfully installed & configured RQM 1.0.1 on a different SLES10 system, and I am pretty experienced with configuring DB2, so I think I'm doing everything right.

Am I missing something? Any suggestions?

Thanks.

5 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Larry Menard (31●2●1) | answered May 14 '09, 11:40 a.m.
More info:

I am able to establish a T4 JDBC connection to the RQM database using the DB2-supplied sample java program "DbConn.java".

db2inst1@lf-rqm2:~> /opt/ibm/db2/V9.5/java/jdk32/bin/java DbConn RQM localhost 50001 db2inst1 db2passwd

THIS SAMPLE SHOWS HOW TO CONNECT TO/DISCONNECT FROM DATABASES.

----------------------------------------------------------
USE JAVA 2 CLASSES:
Connection
DriverManager
TO CONNECT TO/DISCONNECT FROM A DATABASE.
Connect to 'RQM' database using JDBC Universal type 4 driver.

Disconnect from 'RQM' database.


So I'm confident that the DB2 side of things is fine. Which points the finger at RQM.

Any suggestions are greatly appreciated.
0
permanent link
Larry Menard (31●2●1) | answered May 14 '09, 11:56 a.m.
And more info...

The sample JDBC program can also connect from a remote system, so the networking and firewall seem to be fine too.
0
permanent link
Justin Kutticherry (161) | answered May 14 '09, 3:04 p.m.
JAZZ DEVELOPER
Hey Larry,

Try editing your teamserver.properties file from:

com.ibm.team.repository.db.vendor = DB2
com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=db2admin;password={password};
com.ibm.team.repository.db.jdbc.password=db2admin

to:

com.ibm.team.repository.db.vendor = DB2
com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password};
com.ibm.team.repository.db.jdbc.password=db2admin

Basically remove the "fullyMaterializeLobData=false;" part.
0
permanent link
Larry Menard (31●2●1) | answered May 14 '09, 3:11 p.m.
Solution found.

I did a google search for "cannot be overridden by URL". Found this:

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=76379

Table creation using "repotools" is now successful.
0
permanent link
Larry Menard (31●2●1) | answered May 14 '09, 3:13 p.m.
Thanks Justin, I also found that in google. :-)

Hey Larry,

Try editing your teamserver.properties file from:

com.ibm.team.repository.db.vendor = DB2
com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=db2admin;password={password};
com.ibm.team.repository.db.jdbc.password=db2admin

to:

com.ibm.team.repository.db.vendor = DB2
com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password};
com.ibm.team.repository.db.jdbc.password=db2admin

Basically remove the "fullyMaterializeLobData=false;" part.

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.