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

RTC 2.0.0.1 (I20090914-1300) with 11g R2 (11.2.0.1.0)

Questions
Tags
Users
Badges
William Kennedy
(6●1) Oct 20 '09, 3:19 p.m.
Hitting some snags connecting RTC 2.0.0.1 to Oracle 11g R2.

We're using the bundled 1.5 JRE, and the ojdcb5.jar from the Oracle installation, moved over to the 'JazzServerDir/server/oracle/' directory.

I have the OJDBC driver from the 11g installation on the RTC server - however - on startup we get the following error when launching the Setup app:

CRJAZ0808I The driver "oracle.jdbc.OracleDriver" could not be loaded and registered. Support for some database vendors requires that the JDBC driver JAR be provided in a path configured by the server scripts. If you are experiencing problems changing the database vendor, refer to the product setup instructions for more information.


'sh repotool.sh -verify' gives the same CRJAZ0808I error.

The JRE is 'J2RE 1.5.0 IBM J9 2.3'.

I have tried with the 11g R2 OJDBC drivers for 1.5 from Oracle, as well as the 1.4 driver as suggested in the Jazz installation docs.

Are we treading in unsupported waters here? Maybe milestone release territory?

Thanks

0 votes

7 answers
10,651 views
0 votes

7 answers

Permanent link
Anthony Kesterton
JAZZ DEVELOPER (7.5k●9●180●136) Oct 20 '09, 3:57 p.m.
Hitting some snags connecting RTC 2.0.0.1 to Oracle 11g R2.

We're using the bundled 1.5 JRE, and the ojdcb5.jar from the Oracle installation, moved over to the 'JazzServerDir/server/oracle/' directory.

I have the OJDBC driver from the 11g installation on the RTC server - however - on startup we get the following error when launching the Setup app:

CRJAZ0808I The driver "oracle.jdbc.OracleDriver" could not be loaded and registered. Support for some database vendors requires that the JDBC driver JAR be provided in a path configured by the server scripts. If you are experiencing problems changing the database vendor, refer to the product setup instructions for more information.


'sh repotool.sh -verify' gives the same CRJAZ0808I error.

The JRE is 'J2RE 1.5.0 IBM J9 2.3'.

I have tried with the 11g R2 OJDBC drivers for 1.5 from Oracle, as well as the 1.4 driver as suggested in the Jazz installation docs.

Are we treading in unsupported waters here? Maybe milestone release territory?

Thanks

Your guess is correct - 11g not currently supported.

http://www-01.ibm.com/support/docview.wss?rs=3488&uid=swg27015746#DB

gives you the list of supported databases and other bits.

I am not sure if any of the 2.0.0.2 or 3.0 milestones support 11g - perhaps someone from development can comment on this

regards

anthony

0 votes

Permanent link
William Kennedy
(6●1) Oct 21 '09, 11:44 a.m.
RTC is up on 11g.

- Include ojdbc14.jar. This is what eventually provided connectivity, even though the JRE is 1.5, and ojdbc5.jar is present in JazzServerDir/server/oracle/. The createTables.log shows "Jdbc Driver Version: 10.2.0.4.0", and warnings about version checking being disabled.

- Set 'DB version checking' to 'false'

- Shutdown the server

- Run 'repotools.sh -createTables'

Restart the server, and verify everything else!

0 votes

Permanent link
Anthony Kesterton
JAZZ DEVELOPER (7.5k●9●180●136) Oct 22 '09, 12:21 p.m.
RTC is up on 11g.


- Include ojdbc14.jar. This is what eventually provided connectivity, even though the JRE is 1.5, and ojdbc5.jar is present in JazzServerDir/server/oracle/. The createTables.log shows "Jdbc Driver Version: 10.2.0.4.0", and warnings about version checking being disabled.

- Set 'DB version checking' to 'false'

- Shutdown the server

- Run 'repotools.sh -createTables'

Restart the server, and verify everything else!

Well done - and thanks for letting us know how you got it running. This is helpful to other people who might want to try this.

anthony

0 votes

Permanent link
Adrian Cho
JAZZ DEVELOPER (821●1●33●22) Nov 07 '09, 10:30 p.m.
Support for 11g is not on the plan for 2.0.0.2. It's quite likely it will be there for 3.0 however.

0 votes

Permanent link
Ivan Bula
(58●10●6) Nov 12 '09, 12:51 a.m.
RTC is up on 11g.


- Include ojdbc14.jar. This is what eventually provided connectivity, even though the JRE is 1.5, and ojdbc5.jar is present in JazzServerDir/server/oracle/. The createTables.log shows "Jdbc Driver Version: 10.2.0.4.0", and warnings about version checking being disabled.

- Set 'DB version checking' to 'false'

- Shutdown the server

- Run 'repotools.sh -createTables'

Restart the server, and verify everything else!

Hi, wjkneon how do yoy this?, sorry im really principiant with this. Where change the option for the db version??, thanks in advance

0 votes

Permanent link
Jorge Iglesias
(81●7●6) Jan 29 '10, 4:33 p.m.
In the teamserver.properties add

com.ibm.team.repository.db.override.versioncheck=true

Cheers

0 votes

Permanent link
Sally-Anne Prout
(110●2●23●16) Apr 08 '10, 9:18 a.m.
Support for 11g is not on the plan for 2.0.0.2. It's quite likely it will be there for 3.0 however.


Please can someone from Development confirm if 11g will be supported in version 3 and will it be supported in an Oracle Real Application Clusters (RAC) configuration?

Thanks :D

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: Oct 20 '09, 3:19 p.m.

Question was seen: 10,651 times

Last updated: Oct 20 '09, 3:19 p.m.

Confirmation Cancel Confirm