<span id="result_box" class="short_text" lang="en"><span class="hps">Under normal circumstances I properly go with no 2. But I kinda have the feeling you want to keep this simple and lightweight.<br><br>I will stick to solution no 3. </span><span class="hps alt-edited">Thanks for the advice both. </span></span><br>
<br><div class="gmail_quote">2012/7/18 Jason Greene <span dir="ltr"><<a href="mailto:jgreene@redhat.com" target="_blank">jgreene@redhat.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF"><div><span>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.</span></div>
<div><div class="h5"><div><br>On Jul 17, 2012, at 2:34 PM, Flemming Harms <<a href="mailto:flemming.harms@gmail.com" target="_blank">flemming.harms@gmail.com</a>> wrote:<br><br></div><div></div><blockquote type="cite">
<div>Hi everybody<br><br>I'm currently working on "Domain Management - Add support for database authentication" <a href="https://issues.jboss.org/browse/AS7-1370" target="_blank">https://issues.jboss.org/browse/AS7-1370</a> and <a href="https://issues.jboss.org/browse/AS7-1371" target="_blank">https://issues.jboss.org/browse/AS7-1371</a> 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.<br>
<br>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<br><br>1. Reuse some existing code in the project, I don't if it possible to take <span lang="en"><span>advantage</span></span> of existing code for maintaining a database connection pool?<br>
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?.<br>3. Write my own simple connection pool manager. <br><br>I was started on no. 3 and don't think it will be a huge task.<br>
<br>What do you think, does it make sense?<br><br>br<br>Flemming<br><br>
</div></blockquote></div></div><div class="im"><blockquote type="cite"><div><span>_______________________________________________</span><br><span>jboss-as7-dev mailing list</span><br><span><a href="mailto:jboss-as7-dev@lists.jboss.org" target="_blank">jboss-as7-dev@lists.jboss.org</a></span><br>
<span><a href="https://lists.jboss.org/mailman/listinfo/jboss-as7-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/jboss-as7-dev</a></span><br></div></blockquote></div></div></blockquote></div><br>