Announce: Database Backed Storage Service

[Paul Hethmon]

Sure. We could add them to them code repository as examples.

Paul

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

>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
>--
>To unsubscribe from this list send an email to
>users-unsubscribe at shibboleth.net