Announce: Database Backed Storage Service

[Paul Hethmon]

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