Skip to Content.
Sympa Menu

grouper-users - [grouper-users] JDBC provider-specific properties?

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] JDBC provider-specific properties?


Chronological Thread 
  • From: Tom Poage <>
  • To: "" <>
  • Subject: [grouper-users] JDBC provider-specific properties?
  • Date: Thu, 8 Dec 2016 00:42:25 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:ZM+NFRL8wLpV8OAoPdmcpTZWNBhigK39O0sv0rFitYgeLv7xwZ3uMQTl6Ol3ixeRBMOAuqkC1rGd6vyocFdDyK7JiGoFfp1IWk1NouQttCtkPvS4D1bmJuXhdS0wEZcKflZk+3amLRodQ56mNBXdrXKo8DEdBAj0OxZrKeTpAI7SiNm82/yv95HJbQhFgDSwbalyIRi4ogndq8YbipZ+J6gszRfEvmFGcPlMy2NyIlKTkRf85sOu85Nm7i9dpfEv+dNeXKvjZ6g3QqBWAzogM2Au+c3krgLDQheV5nsdSWoZjBxFCBXY4R7gX5fxtiz6tvdh2CSfIMb7Q6w4VSik4qx2ThLjlSUJOCMj8GzPisJ+kr9VoA6vqRJ8xIDUYZ2aOvVxca7GYdMVXm9BUtpRVyBdAI6xaZYEAeobPeZfqonwv0UArRy7BQKxHu3vzSVHhnDo0qYn1OkhDQ/G3BQnH90Uv3Tbss74NLoOXu+o1qbI0zTDb+hM1Tjj9YfIbwksrPeRVrx+dsrRzFMgFwLDjliIrozlJSma2fgJs2eF9eZvSeWvi2shpgpsoTav3t8hhpTXio8W0FzI6Dt1zJovKdC2VkJ3e8CoHIZTui2CKod6XMAvT3t1tCok1rEKo4O3cSoQxJg6yBPTdeSLf5WJ7x/nTuqdPzd1iX1/dL+9nRq+70etx+vhXceuyllKtDBKktzUu3ANyRPT7s+HR+Nm/kekxTaPzx3f5vtZIU8oiKXUMYAhwr8rlpYJr0vMAzL2lF33jK+QaEok5vCl5/n5brjlvJOQKpF4hh3kPqkghMCzG/o0PhUNUmSD/OSzzrzj/Un3QLVQif02l7HUsIzUJcQDoa62GQBV3Zg45haiEzipzc4XnWcGLFJeYh6IkZXmO0zWLPDiEfi/m0iskCtsx/3eMb3hGJLNLmXbkLj/Z7Zx8lNcyBEtwtBF/JJZEbUBIPPoWk/tr9zUEAU1Mw2yw+b7Ftp9zIUeVnyTAqOHKq/dr0KH5v98a9WLMcUaojHgM/U/ouP1gGUisV4bYaSz25YLMja1EuksaxGWe33xmtobVHoRsxAlZO3slFCYVzNPPTC/U79qtR8hD4fzMYDGDriqibOMlHOnEIVRb29LIk2HHX72dp7CVvsRPnHBavR9myAJAODyA7Qq0guj4Vf3
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99
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.

Archive powered by MHonArc 2.6.19.

Top of Page