[Building Sakai] Database Connection Pooling

[Mark J. Norton]

Yes, as in IBM's DB2.  I have a client who is keeping their identity 
information in a legacy DB2 database.  They have a custom User Directory 
Provider that queries that database for user information based on an 
EID.  Previously, it used only a single connection.  I have updated the 
code to use a connection pool.

- Mark

On 12/26/2013 5:18 PM, Steve Swinsburg wrote:
>
> Db2 connections? As in the db2 database? FYI support was totally 
> removed a while back.
>
> Cheers
> Steve
>
> sent from mobile
>
> On 25/12/2013 3:43 AM, "Mark J. Norton" <markjnorton at earthlink.net 
> <mailto:markjnorton at earthlink.net>> wrote:
>
>     Just to put this in context, I'm not actually asking to change the
>     Sakai connection pooling (though having it configurable would be a
>     great feature).  Rather, I have a client who wants to pool DB2
>     connections (currently using only one) to improve performance. 
>     This is happening in a custom User Directory Provider.
>
>     - Mark Norton
>
>     On 12/24/2013 11:11 AM, Matthew Jones wrote:
>>     There was a jira I was working on to make it easier to switch
>>     from dbcp to tomcat (and c3p0 if someone wrote the wrapper for
>>     it). I still plan to finish this for Sakai 10 (mostly just some
>>     class reorganization was left I think), but it didn't get to it
>>     for 2.9. I'd tested this back against 2.9 though and you can
>>     manually switch the pooler over to the tomcat one by changing the
>>     values in the db-components.xml re-compiling the kernel
>>
>>     https://jira.sakaiproject.org/browse/KNL-1000
>>
>>
>>     On Tue, Dec 24, 2013 at 10:29 AM, Aaron Zeckoski
>>     <azeckoski at unicon.net <mailto:azeckoski at unicon.net>> wrote:
>>
>>         In short, in the kernel (see the database project). This is
>>         controllable in sakai config. Same as it has been for awhile.
>>         We do
>>         not use tomcat connection polling in 2.9.
>>         -AZ
>>
>>
>>         On Tue, Dec 24, 2013 at 10:22 AM, Mark J. Norton
>>         <markjnorton at earthlink.net
>>         <mailto:markjnorton at earthlink.net>> wrote:
>>         > Where does Sakai initialize database connection pooling?
>>         > Are we using Tomcat connection pooling in 2.9.x?
>>         >
>>         > - Mark Norton
>>         >
>>         > _______________________________________________
>>         > sakai-dev mailing list
>>         > sakai-dev at collab.sakaiproject.org
>>         <mailto:sakai-dev at collab.sakaiproject.org>
>>         > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>         >
>>         > TO UNSUBSCRIBE: send email to
>>         sakai-dev-unsubscribe at collab.sakaiproject.org
>>         <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>>         subject of "unsubscribe"
>>
>>
>>
>>         --
>>         Aaron Zeckoski - Software Architect -
>>         http://tinyurl.com/azprofile
>>         _______________________________________________
>>         sakai-dev mailing list
>>         sakai-dev at collab.sakaiproject.org
>>         <mailto:sakai-dev at collab.sakaiproject.org>
>>         http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>>         TO UNSUBSCRIBE: send email to
>>         sakai-dev-unsubscribe at collab.sakaiproject.org
>>         <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>>         subject of "unsubscribe"
>>
>>
>
>
>     _______________________________________________
>     sakai-dev mailing list
>     sakai-dev at collab.sakaiproject.org
>     <mailto:sakai-dev at collab.sakaiproject.org>
>     http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
>     TO UNSUBSCRIBE: send email to
>     sakai-dev-unsubscribe at collab.sakaiproject.org
>     <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>     subject of "unsubscribe"
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20131227/82d1a5fd/attachment.html