Unable to create tables (DB2) in RQM 2.0 beta 1
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:
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.
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
More info:
I am able to establish a T4 JDBC connection to the RQM database using the DB2-supplied sample java program "DbConn.java".
So I'm confident that the DB2 side of things is fine. Which points the finger at RQM.
Any suggestions are greatly appreciated.
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.
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.
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.
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.