Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] Grouper compatible with Oracle 11g/UTF8?

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] Grouper compatible with Oracle 11g/UTF8?

Chronological Thread 
  • From: Chris Hyzer <>
  • To: Gagné Sébastien <>, Dominique Petitpierre <>
  • Cc: "" <>
  • Subject: RE: [grouper-users] Grouper compatible with Oracle 11g/UTF8?
  • Date: Mon, 13 Aug 2012 19:43:42 +0000
  • Accept-language: en-US

Sure, we can do that for 2.2...


-----Original Message-----
From: Gagné Sébastien

Sent: Monday, August 13, 2012 2:02 PM
To: Chris Hyzer; Dominique Petitpierre

Subject: RE: [grouper-users] Grouper compatible with Oracle 11g/UTF8?

I would like to point out that the current jdbc jar in Grouper is made to run
on JDK 1.4, isn't 1.6 recommended for Grouper ? If the tests are Ok with the
newer drivers, would you consider replacing the old library ?

unzip -p $GROUPER_HOME/api/lib/jdbcSamples/ojdbc14.jar META-INF/MANIFEST.MF |
egrep 'Specification|Implementation'
Specification-Title: Oracle JDBC driver classes for use with JDK14
Implementation-Title: ojdbc14_g.jar
Specification-Vendor: Oracle Corporation
Specification-Version: Oracle JDBC Driver version - ""
Implementation-Version: Oracle JDBC Driver version - ""
Implementation-Vendor: Oracle Corporation
Implementation-Time: Sat Feb 2 11:53:00 2008

-----Message d'origine-----
De :

De la part de Chris Hyzer
Envoyé : 13 août 2012 13:39
À : Dominique Petitpierre
Cc :

Objet : RE: [grouper-users] Grouper compatible with Oracle 11g/UTF8?

I would just like to mention, that the driver should match the primary
registry DB and tests should pass, and the tests do not really need to pass
if the older DB is for the loader since that is just running a SELECT
statement against the DB and that’s it...

i.e. if the Grouper registry is 11g, and the driver is ojdbc6, and the junit
tests pass, then if you have a loader job going against 10g, you don’t really
need to need to test the junit tests from ojdbc6 to 10g...


-----Original Message-----
From: Dominique Petitpierre
Sent: Monday, August 13, 2012 12:55 PM
To: Chris Hyzer

Subject: Re: [grouper-users] Grouper compatible with Oracle 11g/UTF8?


Thanks for your answer:

On 08/09/2012 09:18 PM, Chris Hyzer wrote:

> I don’t know that I have tried the configuration you ask about, but I think
> it should work. About hibernate dialects, we don’t do much that would
> change from dialect to dialect, either should work. About drivers, the
> newer driver is probably better to use since it has failover differences
> and maybe other improvements, and it should be able to connect to older
> oracle envs...
> If you want to know for sure, replace driver, set dialect to what you want,
> and run:
> gsh -test -all
> If you get no errors, its fine. :)

I did this to test the latest ojdbc6.jar found on
connecting to an Oracle 10g DB:

unzip -p $GROUPER_HOME/lib/jdbcSamples/ojdbc6.jar META-INF/MANIFEST.MF\
| egrep 'Specification|Implementation'
Implementation-Vendor: Oracle Corporation
Implementation-Title: JDBC
Specification-Vendor: Sun Microsystems Inc.
Specification-Title: JDBC
Specification-Version: 4.0

The test ran without errors or failures. So the compatibility of the new
driver with the "old" 10g DB is confirmed in the context of Grouper.

The same test will be done with an Oracle 11g DB and I'll report the result
in this list (in a few weeks).

Best regards,
Mr Dominique Petitpierre, user=Dominique.Petitpierre IT
Division, University of Geneva, Switzerland

Archive powered by MHonArc 2.6.16.

Top of Page