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: Dominique Petitpierre <>
  • Cc: "" <>
  • Subject: RE: [grouper-users] Grouper compatible with Oracle 11g/UTF8?
  • Date: Mon, 13 Aug 2012 17:39:28 +0000
  • Accept-language: en-US

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

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