Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

The grouper db is grouper.hibernate.properties

Are you doing sources.xml or subject.properties?  Either way, put the 
connection information there for the source:

https://spaces.internet2.edu/display/Grouper/Grouper+book+-+Connecting+to+a+subject+source

     <!--
       e.g. mysql:           com.mysql.jdbc.Driver
       e.g. p6spy (log sql): com.p6spy.engine.spy.P6SpyDriver
         for p6spy, put the underlying driver in spy.properties
       e.g. oracle:          oracle.jdbc.driver.OracleDriver
       e.g. hsqldb:          org.hsqldb.jdbcDriver
       e.g. postgres:        org.postgresql.Driver -->
 
     <!-- init-param>
       <param-name>dbDriver</param-name>
       <param-value>org.hsqldb.jdbcDriver</param-value>
     </init-param -->
 
     <!--
       e.g. mysql:           jdbc:mysql://localhost:3306/grouper
       e.g. p6spy (log sql): [use the URL that your DB requires]
       e.g. oracle:          jdbc:oracle:thin:@server.school.edu:1521:sid
       e.g. hsqldb (a):      jdbc:hsqldb:dist/run/grouper;create=true
       e.g. hsqldb (b):      jdbc:hsqldb:hsql://localhost:9001
       e.g. postgres:        jdbc:postgresql:grouper -->
 
     <!-- init-param>
       <param-name>dbUrl</param-name>
       
<param-value>jdbc:hsqldb:C:/projects/GrouperI2MI_1-2/grouper/dist/run/grouper</param-value>
     </init-param>
     <init-param>
       <param-name>dbUser</param-name>
       <param-value>sa</param-value>
     </init-param>
     <init-param>
       <param-name>dbPwd</param-name>
       <param-value></param-value>
     </init-param -->


-----Original Message-----
From: 

 
[mailto:]
 On Behalf Of Gettes, Michael
Sent: Wednesday, April 04, 2018 10:09 PM
To: 

Subject: [grouper-users] Multiple DB hibernate configuration

I would like to configure mysql for the grouper DB repository and Oracle as a 
subject source DB.

I’ve been searching for an hour and it is just not obvious how to configure 
multiple DBs.

It appears there is one hibernate config per file and if that is true, how 
does one specify multiple hibernate configs to grouper?

Many thanks to anyone with a pointer in the right direction.  Sometimes I 
just feel stupid.  (No comments please).  :-)

/mrg