Announce: Database Backed Storage Service

[Wessel, Keith]

Paul and others,

Attached is the SQL our DBAs whipped up to set up the tables, triggers, indexes, and clean-up stored procedure to implement the database-backed storage service with an Oracle 11 database. Campus-specific and password info removed, of course. Paul, feel free to add this to the repository as our contribution.

Everything seems to be working great so far. Only thing we have left to test is a load test to ensure that things are sane, but if we run into problems there, it'll probably just mean tweaks to the Comcat container-based connection.

Thanks again, we hope to have this in production in the next few weeks.

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:25 PM
To: Shib Users
Subject: Re: Announce: Database Backed Storage Service

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

--
To unsubscribe from this list send an email to users-unsubscribe at shibboleth.net
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Shibboleth_IDP_DDL_20131022.sql
Type: application/octet-stream
Size: 3210 bytes
Desc: Shibboleth_IDP_DDL_20131022.sql
Url : http://shibboleth.net/pipermail/users/attachments/20131024/e28d0c1d/attachment.obj