Grouper Users - Open Discussion List

[Scott Koranda <>]

Hi Linda,

On my Grouper 2.1.x deployment on CentOS 6.x I am using ojdbc6.jar with Oracle 12.1.0.2, but also previously used it with Oracle 11.2.0.3.

I simply dropped the jar file into $GROUPER_HOME/lib/custom and removed the the other jar distributed with Grouper (your layout may differ depending on how you deploy).

We run it with OpenJDK 1.7.x provided by the RHEL repositories and have had no issues.

Cheers,

Scott K

On Thu, Aug 13, 2015 at 5:21 PM, Linda Toth <> wrote:

Good afternoon,

I tried out grouper installation first by installing in on my desktop (Mac OS/X) and using the hsqldb.  Although it was 100% smooth, I was able to reason out what was needed to completed the installation and had grouper up and running within a day.

The RHEL installation is not going well.  In production, we will be using Oracle rather than the bundled database.  

By reading the documentation and reviewing the tutorial, it is implied that all drivers needed for an installation are included in the installation package.  However, once I have entered the hibernate.connection.url, hibernate.connection.username, and hibernate.connection.password, the program throws the following exception trace (despite adding the ojdbc14.jar driver to a library and including it in the classpath.  The lines indicating issues in finding ojdbc14.jar are in red):

Checking database with query: select 1 from dual

Error: could not connect to the database: 

java.lang.RuntimeException: Error with query: select 1 from dual

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:400)

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:323)

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.select(GiDbUtils.java:334)

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.checkConnection(GiDbUtils.java:474)

at edu.internet2.middleware.grouperInstaller.GrouperInstaller.checkDatabaseConnection(GrouperInstaller.java:7290)

at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainInstallLogic(GrouperInstaller.java:5719)

at edu.internet2.middleware.grouperInstaller.GrouperInstaller.access$300(GrouperInstaller.java:77)

at edu.internet2.middleware.grouperInstaller.GrouperInstaller$GrouperInstallerMainFunction$1.logic(GrouperInstaller.java:967)

at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainLogic(GrouperInstaller.java:1029)

at edu.internet2.middleware.grouperInstaller.GrouperInstaller.main(GrouperInstaller.java:300)

Caused by: java.lang.RuntimeException: Error connecting to: null

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.connection(GiDbUtils.java:310)

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:364)

... 9 more

Caused by: java.lang.RuntimeException: Problem loading class: oracle.jdbc.driver.OracleDriver

at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.forName(GrouperInstallerUtils.java:712)

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.connection(GiDbUtils.java:304)

... 10 more

Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

at java.lang.Class.forNameImpl(Native Method)

at java.lang.Class.forName(Class.java:212)

at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.forName(GrouperInstallerUtils.java:710)

We need to get a replacement for our current role management system prototyped and available for users ASAP, so anything you can suggest would be most appreciated.

Linda

--

Linda Toth
University of Alaska - Office of Information Technology (OIT) - Identity and Access Management

910 Yukon Drive, Suite 103

Fairbanks, Alaska 99775

Tel: 907-450-8320

Fax: 907-450-8381

 | www.alaska.edu/oit/