Grouper Users - Open Discussion List

[Chris Hyzer <>]

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...

Thanks,
Chris

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

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

Hello,

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
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
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
Implementation-Version: 11.2.0.3.0
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,
Dominique
--
Mr Dominique Petitpierre, user=Dominique.Petitpierre domain=unige.ch
IT Division, University of Geneva, Switzerland