Announce: Database Backed Storage Service

[Wessel, Keith]

I guess we'll see what happens. Would you like to see the SQL files to define the schema, triggers and indexes that our DBA modified for me from the ones that came with the binary distribution just to see what we're using on our side? Don't know if this would be useful for you to compare to the generated ones.

Keith


-----Original Message-----
From: users-bounces at shibboleth.net [mailto:users-bounces at shibboleth.net] On Behalf Of Paul Hethmon
Sent: Wednesday, October 16, 2013 3:04 PM
To: Shib Users
Subject: Re: Announce: Database Backed Storage Service

Keith,

That's correct, just drop the new jar in place and rebuild Shib.

I did just upload yet another version: 1.1.2

Looking a bit more, it seems that I needed to declare the Oracle sequence in the Hibernate files. I tested the SQL generation using the Oracle dialect and it creates a statement to create the actual sequence. What I'm not sure about is how Hibernate makes use of that sequence to populate the actual DB column. I am hoping that Hibernate takes care of all of that for me behind the curtain. If it doesn't we might have to look at using a trigger or some other mechanism to actually push the sequence value into the identity column.

Paul


On 10/16/13 3:42 PM, "Wessel, Keith" <kwessel at illinois.edu> wrote:

>Fabulous, Paul, thanks so much! I'll give this a try today or tomorrow 
>and post back if I have problems. In terms of upgrading from 1.1.0, I 
>only need to replace the precompiled jar with the new version in my 
>IDP, correct? No other changes needed?
>
>Keith
>
>
>-----Original Message-----
>From: users-bounces at shibboleth.net 
>[mailto:users-bounces at shibboleth.net]
>On Behalf Of Paul Hethmon
>Sent: Wednesday, October 16, 2013 2:35 PM
>To: Shib Users
>Subject: Re: Announce: Database Backed Storage Service
>
>Keith,
>
>I believe I've found the solution for this. New code has been committed 
>and a 1.1.1 build uploaded.
>
>Let me know.
>
>cheers,
>
>Paul
>
>On 10/4/13 10:57 AM, "Wessel, Keith" <kwessel at illinois.edu> wrote:
>
>>Thanks, Paul, for being willing to stick with our Oracle craziness. I 
>>know you want to make this code as universal as you can, and it 
>>certainly benefits us that you do!
>>
>>Hoping for an easy fix for you. From my googling for that error 
>>yesterday before posting to the list, it looks like there's some 
>>decent built-in code to Hibernate, assuming I understood what I was reading.
>>
>>Keith
>>
>>
>>-----Original Message-----
>>From: users-bounces at shibboleth.net
>>[mailto:users-bounces at shibboleth.net]
>>On Behalf Of Paul Hethmon
>>Sent: Friday, October 04, 2013 9:54 AM
>>To: Shib Users
>>Subject: Re: Announce: Database Backed Storage Service
>>
>>Yep, pretty obvious what the problem is. I'll have to do some research 
>>on how to tell Hibernate to tell Oracle to create/use an identity/key 
>>column.
>>
>>Paul
>>
>>On 10/3/13 3:02 PM, "Wessel, Keith" <kwessel at illinois.edu> wrote:
>>
>>>Looks like I found another minor glitch with using your storage 
>>>service and Oracle. It's with an item you're using that doesn't seem 
>>>to be supported by the Oracle10gDialect.
>>>
>>>Stack trace follows; doubt you need more than the first line to see 
>>>the issue.
>>
>>--
>>To unsubscribe from this list send an email to 
>>users-unsubscribe at shibboleth.net
>>--
>>To unsubscribe from this list send an email to 
>>users-unsubscribe at shibboleth.net
>
>--
>To unsubscribe from this list send an email to 
>users-unsubscribe at shibboleth.net
>--
>To unsubscribe from this list send an email to 
>users-unsubscribe at shibboleth.net

--
To unsubscribe from this list send an email to users-unsubscribe at shibboleth.net