Grouper Users - Open Discussion List

["Gettes, Michael" <>]

Can’t thank you enough.  I looked at that file (I will be doing 
subject.properties) but I just didn’t see this and now I look at this morning 
and it is as plain as day.  Sorry to waste your precious time.

/mrg

> On Apr 5, 2018, at 9:13 AM, Hyzer, Chris 
> <>
>  wrote:
> 
> 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://urldefense.proofpoint.com/v2/url?u=https-3A__spaces.internet2.edu_display_Grouper_Grouper-2Bbook-2B-2D-2BConnecting-2Bto-2Ba-2Bsubject-2Bsource&d=DwIGaQ&c=pZJPUDQ3SB9JplYbifm4nt2lEVG5pWx2KikqINpWlZM&r=EUBHI54mtQDlbcqo5rUTdQ&m=RWQ-f8uqnO74AlWfiV2bl_GJeb3JIAYPRcLUwC5Uemc&s=g184f9XNlNbrxUjOq1iNF9hSYDuVd2VzxPb0s3Gk-0Y&e=
> 
>     <!--
>       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
>