[jboss-as7-dev] Domain Management - Add support for database authentication. Need advice

[Flemming Harms]

Under normal circumstances I properly go with no 2. But I kinda have the
feeling you want to keep this simple and lightweight.

I will stick to solution no 3. Thanks for the advice both.

2012/7/18 Jason Greene <jgreene at redhat.com>

> I would just go with 3 since all it does is execute two queries at most
> which are always read operations. A simple semapahore can be used to block
> callers when the pool is full It should also be optional since most jdbc
> drivers support pooling on their own.
>
> On Jul 17, 2012, at 2:34 PM, Flemming Harms <flemming.harms at gmail.com>
> wrote:
>
> Hi everybody
>
> I'm currently working on "Domain Management - Add support for database
> authentication" https://issues.jboss.org/browse/AS7-1370 and
> https://issues.jboss.org/browse/AS7-1371 and struggling with a design
> issue. What I need to solve is that you are able to setup a connection pool
> for database authentication, and I was told that I could not depend on the
> JBOSS subsystem when running in domain mode.
>
> So I basic need some functionality to handle a database connection pool, I
> can see 3 options but I don't know what is the best approach and what the
> guidelines are
>
> 1. Reuse some existing code in the project, I don't if it possible to take
> advantage of existing code for maintaining a database connection pool?
> 2. Use an existing 3 party lib, that will provide this functionality. I
> don't what are the common guidelines for adding new 3 party libs to the
> project?.
> 3. Write my own simple connection pool manager.
>
> I was started on no. 3 and don't think it will be a huge task.
>
> What do you think, does it make sense?
>
> br
> Flemming
>
> _______________________________________________
> jboss-as7-dev mailing list
> jboss-as7-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-as7-dev/attachments/20120718/85840e09/attachment.html