Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

You can specify the Oracle connect URL, and any other hibernate properties.  Not sure if hibernate has settings for those things.  Doesnt the server require security and the client just does it?  Or maybe the oci client has more options without having to pass properties to the driver?

Thanks

Chris 

---

From: <> on behalf of Tom Poage <>
Sent: Wednesday, December 7, 2016 7:42 PM
To:
Subject: [grouper-users] JDBC provider-specific properties?

 

Grouper Newbie. Knowledge of Hibernate ancient.

I’ve poked around the Grouper and Hibernate source, a bit of Googling and come up short. Can one (and where) wire in properties specific to a JDBC provider?

Specifically, Oracle thin driver encryption/integrity, cf.

https://docs.oracle.com/database/121/JJDBC/clntsec.htm#JJDBC28313

With the connection pool would be a plus!

Bits of analogous Java:

OracleDriver dr = new OracleDriver();
String url = ""jdbc:oracle:thin:@ldap://....ucdavis.edu:389/...,cn=OracleContext,dc=ucdavis,dc=edu”; Properties props = new Properties();
...
props.setProperty("oracle.net.encryption_client", "REQUIRED");
props.setProperty("oracle.net.encryption_types_client", "(AES256,AES192,AES128,3DES168)");
props.setProperty("oracle.net.crypto_checksum_client","REQUIRED");
props.setProperty("oracle.net.crypto_checksum_types_client","(SHA1)");
...
OracleConnection conn = (OracleConnection) dr.connect(url,props);

Would these have to be set as system/container properties?

Thanks!
Tom.