Grouper Users - Open Discussion List

[Chris Hyzer <>]

Sure, we can do that for 2.2...

https://bugs.internet2.edu/jira/browse/GRP-836

Thanks,
Chris

-----Original Message-----
From: Gagné Sébastien 
[mailto:]
 
Sent: Monday, August 13, 2012 2:02 PM
To: Chris Hyzer; Dominique Petitpierre
Cc: 

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 - "10.2.0.4.0"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.4.0"
Implementation-Vendor:  Oracle Corporation
Implementation-Time:    Sat Feb  2 11:53:00 2008


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

 
[mailto:]
 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...

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