<html><head></head><body bgcolor="#FFFFFF"><div><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); ">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><br>On Jul 17, 2012, at 2:34 PM, Flemming Harms <<a href="mailto:flemming.harms@gmail.com">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">https://issues.jboss.org/browse/AS7-1370</a> and <a href="https://issues.jboss.org/browse/AS7-1371">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 id="result_box" class="short_text" lang="en"><span class="hps">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><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">jboss-as7-dev@lists.jboss.org</a></span><br><span><a href="https://lists.jboss.org/mailman/listinfo/jboss-as7-dev">https://lists.jboss.org/mailman/listinfo/jboss-as7-dev</a></span><br></div></blockquote></body></html>