| <!DOCTYPE html> |
| <html lang="en"> |
| |
| <head> |
| <meta charset="UTF-8"> |
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> |
| <meta name="viewport" content="width=device-width, initial-scale=1"> |
| <title>Apache TomEE</title> |
| <meta name="description" |
| content="Apache TomEE is a lightweight, yet powerful, JavaEE Application server with feature rich tooling." /> |
| <meta name="keywords" content="tomee,asf,apache,javaee,jee,shade,embedded,test,junit,applicationcomposer,maven,arquillian" /> |
| <meta name="author" content="Luka Cvetinovic for Codrops" /> |
| <link rel="icon" href="../../favicon.ico"> |
| <link rel="icon" type="image/png" href="../../favicon.png"> |
| <meta name="msapplication-TileColor" content="#80287a"> |
| <meta name="theme-color" content="#80287a"> |
| <link rel="stylesheet" type="text/css" href="../../css/normalize.css"> |
| <link rel="stylesheet" type="text/css" href="../../css/bootstrap.css"> |
| <link rel="stylesheet" type="text/css" href="../../css/owl.css"> |
| <link rel="stylesheet" type="text/css" href="../../css/animate.css"> |
| <link rel="stylesheet" type="text/css" href="../../fonts/font-awesome-4.1.0/css/font-awesome.min.css"> |
| <link rel="stylesheet" type="text/css" href="../../fonts/eleganticons/et-icons.css"> |
| <link rel="stylesheet" type="text/css" href="../../css/jqtree.css"> |
| <link rel="stylesheet" type="text/css" href="../../css/idea.css"> |
| <link rel="stylesheet" type="text/css" href="../../css/cardio.css"> |
| |
| <script type="text/javascript"> |
| |
| var _gaq = _gaq || []; |
| _gaq.push(['_setAccount', 'UA-2717626-1']); |
| _gaq.push(['_setDomainName', 'apache.org']); |
| _gaq.push(['_trackPageview']); |
| |
| (function() { |
| var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; |
| ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; |
| var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); |
| })(); |
| |
| </script> |
| </head> |
| |
| <body> |
| <div class="preloader"> |
| <img src="../../img/loader.gif" alt="Preloader image"> |
| </div> |
| <nav class="navbar"> |
| <div class="container"> |
| <div class="row"> <div class="col-md-12"> |
| |
| <!-- Brand and toggle get grouped for better mobile display --> |
| <div class="navbar-header"> |
| <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1"> |
| <span class="sr-only">Toggle navigation</span> |
| <span class="icon-bar"></span> |
| <span class="icon-bar"></span> |
| <span class="icon-bar"></span> |
| </button> |
| <a class="navbar-brand" href="/"> |
| <span> |
| |
| |
| <img src="../../img/logo-active.png"> |
| |
| |
| </span> |
| Apache TomEE |
| </a> |
| </div> |
| <!-- Collect the nav links, forms, and other content for toggling --> |
| <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"> |
| <ul class="nav navbar-nav navbar-right main-nav"> |
| <li><a href="../../docs.html">Documentation</a></li> |
| <li><a href="../../community/index.html">Community</a></li> |
| <li><a href="../../security/security.html">Security</a></li> |
| <li><a href="../../download-ng.html">Downloads</a></li> |
| </ul> |
| </div> |
| <!-- /.navbar-collapse --> |
| </div></div> |
| </div> |
| <!-- /.container-fluid --> |
| </nav> |
| |
| |
| <div id="main-block" class="container main-block"> |
| <div class="row title"> |
| <div class="col-md-12"> |
| <div class='page-header'> |
| |
| <h1>DataSource Creator</h1> |
| </div> |
| </div> |
| </div> |
| <div class="row"> |
| |
| <div class="col-md-12"> |
| <div id="preamble"> |
| <div class="sectionbody"> |
| <div class="paragraph"> |
| <p>TomEE uses <code>creator</code> to create the connection pool factory. In other |
| terms it means you can use any pool you want for DataSource in TomEE.</p> |
| </div> |
| <div class="paragraph"> |
| <p>Default provided pools are DBCP (default in embedded mode) and Tomcat |
| JDBC (default in TomEE to be aligned on Tomcat).</p> |
| </div> |
| <div class="paragraph"> |
| <p>Depending which one you use the accept configuration are not 100% the |
| same even if we try to align the most common entries to the historical |
| configuration (ie DBCP).</p> |
| </div> |
| <div class="paragraph"> |
| <p>Here are a more detailled list of accepted properties by creator.</p> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="_dbcp2_tomee_7_x_and_8_x">DBCP2 (TomEE 7.x and 8.x)</h2> |
| <div class="sectionbody"> |
| <div class="paragraph"> |
| <p>Note: details are at |
| <a href="http://tomee.apache.org/containers-and-resources.html" class="bare">http://tomee.apache.org/containers-and-resources.html</a> (note: |
| <a href="http://commons.apache.org/proper/commons-dbcp/configuration.html" class="bare">http://commons.apache.org/proper/commons-dbcp/configuration.html</a> uses |
| the latest version of DBCP but TomEE 1.7.x is not using this version).</p> |
| </div> |
| <div class="ulist"> |
| <ul> |
| <li> |
| <p>AccessToUnderlyingConnectionAllowed</p> |
| </li> |
| <li> |
| <p>ConnectionInitSqls</p> |
| </li> |
| <li> |
| <p>ConnectionProperties</p> |
| </li> |
| <li> |
| <p>DefaultAutoCommit</p> |
| </li> |
| <li> |
| <p>DefaultCatalog</p> |
| </li> |
| <li> |
| <p>DefaultReadOnly</p> |
| </li> |
| <li> |
| <p>DefaultTransactionIsolation</p> |
| </li> |
| <li> |
| <p>Delegate</p> |
| </li> |
| <li> |
| <p>InitialSize</p> |
| </li> |
| <li> |
| <p>JdbcDriver</p> |
| </li> |
| <li> |
| <p>JdbcUrl</p> |
| </li> |
| <li> |
| <p>LogAbandoned</p> |
| </li> |
| <li> |
| <p>LogWriter</p> |
| </li> |
| <li> |
| <p>LoginTimeout</p> |
| </li> |
| <li> |
| <p>MaxActive</p> |
| </li> |
| <li> |
| <p>MaxIdle</p> |
| </li> |
| <li> |
| <p>MaxOpenPreparedStatements</p> |
| </li> |
| <li> |
| <p>MaxWait</p> |
| </li> |
| <li> |
| <p>MinEvictableIdleTimeMillis</p> |
| </li> |
| <li> |
| <p>MinIdle</p> |
| </li> |
| <li> |
| <p>Name</p> |
| </li> |
| <li> |
| <p>NumTestsPerEvictionRun</p> |
| </li> |
| <li> |
| <p>Password</p> |
| </li> |
| <li> |
| <p>PasswordCipher</p> |
| </li> |
| <li> |
| <p>PoolPreparedStatements</p> |
| </li> |
| <li> |
| <p>RemoveAbandoned</p> |
| </li> |
| <li> |
| <p>RemoveAbandonedTimeout</p> |
| </li> |
| <li> |
| <p>TestOnBorrow</p> |
| </li> |
| <li> |
| <p>TestOnReturn</p> |
| </li> |
| <li> |
| <p>TestWhileIdle</p> |
| </li> |
| <li> |
| <p>TimeBetweenEvictionRunsMillis</p> |
| </li> |
| <li> |
| <p>UserName</p> |
| </li> |
| <li> |
| <p>ValidationQuery</p> |
| </li> |
| <li> |
| <p>ValidationQueryTimeout</p> |
| </li> |
| </ul> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="_tomcat_jdbc">Tomcat JDBC</h2> |
| <div class="sectionbody"> |
| <div class="paragraph"> |
| <p>Note: details are at |
| <a href="https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html" class="bare">https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html</a></p> |
| </div> |
| <div class="ulist"> |
| <ul> |
| <li> |
| <p>AbandonWhenPercentageFull</p> |
| </li> |
| <li> |
| <p>AccessToUnderlyingConnectionAllowed</p> |
| </li> |
| <li> |
| <p>AlternateUsernameAllowed</p> |
| </li> |
| <li> |
| <p>CommitOnReturn</p> |
| </li> |
| <li> |
| <p>ConnectionProperties</p> |
| </li> |
| <li> |
| <p>DataSource</p> |
| </li> |
| <li> |
| <p>DataSourceJNDI</p> |
| </li> |
| <li> |
| <p>DbProperties</p> |
| </li> |
| <li> |
| <p>DefaultAutoCommit</p> |
| </li> |
| <li> |
| <p>DefaultCatalog</p> |
| </li> |
| <li> |
| <p>DefaultReadOnly</p> |
| </li> |
| <li> |
| <p>DefaultTransactionIsolation</p> |
| </li> |
| <li> |
| <p>DriverClassName</p> |
| </li> |
| <li> |
| <p>FairQueue</p> |
| </li> |
| <li> |
| <p>IgnoreExceptionOnPreLoad</p> |
| </li> |
| <li> |
| <p>InitSQL</p> |
| </li> |
| <li> |
| <p>InitialSize</p> |
| </li> |
| <li> |
| <p>JdbcInterceptors</p> |
| </li> |
| <li> |
| <p>JmxEnabled</p> |
| </li> |
| <li> |
| <p>LogAbandoned</p> |
| </li> |
| <li> |
| <p>LogValidationErrors</p> |
| </li> |
| <li> |
| <p>LogWriter</p> |
| </li> |
| <li> |
| <p>LoginTimeout</p> |
| </li> |
| <li> |
| <p>MaxActive</p> |
| </li> |
| <li> |
| <p>MaxAge</p> |
| </li> |
| <li> |
| <p>MaxIdle</p> |
| </li> |
| <li> |
| <p>MaxWait</p> |
| </li> |
| <li> |
| <p>MinEvictableIdleTimeMillis</p> |
| </li> |
| <li> |
| <p>MinIdle</p> |
| </li> |
| <li> |
| <p>Name</p> |
| </li> |
| <li> |
| <p>NumTestsPerEvictionRun</p> |
| </li> |
| <li> |
| <p>Password</p> |
| </li> |
| <li> |
| <p>PasswordCipher</p> |
| </li> |
| <li> |
| <p>PoolProperties</p> |
| </li> |
| <li> |
| <p>PropagateInterruptState</p> |
| </li> |
| <li> |
| <p>RemoveAbandoned</p> |
| </li> |
| <li> |
| <p>RemoveAbandonedTimeout</p> |
| </li> |
| <li> |
| <p>RollbackOnReturn</p> |
| </li> |
| <li> |
| <p>SuspectTimeout</p> |
| </li> |
| <li> |
| <p>TestOnBorrow</p> |
| </li> |
| <li> |
| <p>TestOnConnect</p> |
| </li> |
| <li> |
| <p>TestOnReturn</p> |
| </li> |
| <li> |
| <p>TestWhileIdle</p> |
| </li> |
| <li> |
| <p>TimeBetweenEvictionRunsMillis</p> |
| </li> |
| <li> |
| <p>Url</p> |
| </li> |
| <li> |
| <p>UseDisposableConnectionFacade</p> |
| </li> |
| <li> |
| <p>UseEquals</p> |
| </li> |
| <li> |
| <p>UseLock</p> |
| </li> |
| <li> |
| <p>Username</p> |
| </li> |
| <li> |
| <p>ValidationInterval</p> |
| </li> |
| <li> |
| <p>ValidationQuery</p> |
| </li> |
| <li> |
| <p>ValidationQueryTimeout</p> |
| </li> |
| <li> |
| <p>Validator</p> |
| </li> |
| <li> |
| <p>ValidatorClassName</p> |
| </li> |
| </ul> |
| </div> |
| </div> |
| </div> |
| <div class="sect1"> |
| <h2 id="_dbcp2_tomee_7_x">DBCP2 (TomEE 7.x)</h2> |
| <div class="sectionbody"> |
| <div class="paragraph"> |
| <p>Note: details are at |
| <a href="http://commons.apache.org/proper/commons-dbcp/configuration.html" class="bare">http://commons.apache.org/proper/commons-dbcp/configuration.html</a></p> |
| </div> |
| <div class="ulist"> |
| <ul> |
| <li> |
| <p>AccessToUnderlyingConnectionAllowed</p> |
| </li> |
| <li> |
| <p>ConnectionInitSqls</p> |
| </li> |
| <li> |
| <p>ConnectionProperties</p> |
| </li> |
| <li> |
| <p>DefaultAutoCommit</p> |
| </li> |
| <li> |
| <p>DefaultCatalog</p> |
| </li> |
| <li> |
| <p>DefaultReadOnly</p> |
| </li> |
| <li> |
| <p>DefaultTransactionIsolation</p> |
| </li> |
| <li> |
| <p>Delegate</p> |
| </li> |
| <li> |
| <p>InitialSize</p> |
| </li> |
| <li> |
| <p>JdbcDriver</p> |
| </li> |
| <li> |
| <p>JdbcUrl</p> |
| </li> |
| <li> |
| <p>LogAbandoned</p> |
| </li> |
| <li> |
| <p>LogWriter</p> |
| </li> |
| <li> |
| <p>LoginTimeout</p> |
| </li> |
| <li> |
| <p>MaxTotal</p> |
| </li> |
| <li> |
| <p>MaxIdle</p> |
| </li> |
| <li> |
| <p>MaxOpenPreparedStatements</p> |
| </li> |
| <li> |
| <p>MaxWait</p> |
| </li> |
| <li> |
| <p>MinEvictableIdleTimeMillis</p> |
| </li> |
| <li> |
| <p>MinIdle</p> |
| </li> |
| <li> |
| <p>Name</p> |
| </li> |
| <li> |
| <p>NumTestsPerEvictionRun</p> |
| </li> |
| <li> |
| <p>Password</p> |
| </li> |
| <li> |
| <p>PasswordCipher</p> |
| </li> |
| <li> |
| <p>PoolPreparedStatements</p> |
| </li> |
| <li> |
| <p>RemoveAbandonedOnBorrow</p> |
| </li> |
| <li> |
| <p>RemoveAbandonedOnMaintenance</p> |
| </li> |
| <li> |
| <p>RemoveAbandonedTimeout</p> |
| </li> |
| <li> |
| <p>TestOnBorrow</p> |
| </li> |
| <li> |
| <p>TestOnReturn</p> |
| </li> |
| <li> |
| <p>TestWhileIdle</p> |
| </li> |
| <li> |
| <p>TimeBetweenEvictionRunsMillis</p> |
| </li> |
| <li> |
| <p>UserName</p> |
| </li> |
| <li> |
| <p>ValidationQuery</p> |
| </li> |
| <li> |
| <p>ValidationQueryTimeout</p> |
| </li> |
| </ul> |
| </div> |
| </div> |
| </div> |
| </div> |
| |
| </div> |
| </div> |
| <footer> |
| <div class="container"> |
| <div class="row"> |
| <div class="col-sm-6 text-center-mobile"> |
| <h3 class="white">Be simple. Be certified. Be Tomcat.</h3> |
| <h5 class="light regular light-white">"A good application in a good server"</h5> |
| <ul class="social-footer"> |
| <li><a href="https://www.facebook.com/ApacheTomEE/"><i class="fa fa-facebook"></i></a></li> |
| <li><a href="https://twitter.com/apachetomee"><i class="fa fa-twitter"></i></a></li> |
| <li><a href="https://plus.google.com/communities/105208241852045684449"><i class="fa fa-google-plus"></i></a></li> |
| </ul> |
| </div> |
| <div class="col-sm-6 text-center-mobile"> |
| <div class="row opening-hours"> |
| <div class="col-sm-3 text-center-mobile"> |
| <h5><a href="../../latest/docs/" class="white">Documentation</a></h5> |
| <ul class="list-unstyled"> |
| <li><a href="../../latest/docs/admin/configuration/index.html" class="regular light-white">How to configure</a></li> |
| <li><a href="../../latest/docs/admin/file-layout.html" class="regular light-white">Dir. Structure</a></li> |
| <li><a href="../../latest/docs/developer/testing/index.html" class="regular light-white">Testing</a></li> |
| <li><a href="../../latest/docs/admin/cluster/index.html" class="regular light-white">Clustering</a></li> |
| </ul> |
| </div> |
| <div class="col-sm-3 text-center-mobile"> |
| <h5><a href="../../latest/examples/" class="white">Examples</a></h5> |
| <ul class="list-unstyled"> |
| <li><a href="../../latest/examples/simple-cdi-interceptor.html" class="regular light-white">CDI Interceptor</a></li> |
| <li><a href="../../latest/examples/rest-cdi.html" class="regular light-white">REST with CDI</a></li> |
| <li><a href="../../latest/examples/ejb-examples.html" class="regular light-white">EJB</a></li> |
| <li><a href="../../latest/examples/jsf-managedBean-and-ejb.html" class="regular light-white">JSF</a></li> |
| </ul> |
| </div> |
| <div class="col-sm-3 text-center-mobile"> |
| <h5><a href="../../community/index.html" class="white">Community</a></h5> |
| <ul class="list-unstyled"> |
| <li><a href="../../community/contributors.html" class="regular light-white">Contributors</a></li> |
| <li><a href="../../community/social.html" class="regular light-white">Social</a></li> |
| <li><a href="../../community/sources.html" class="regular light-white">Sources</a></li> |
| </ul> |
| </div> |
| <div class="col-sm-3 text-center-mobile"> |
| <h5><a href="../../security/index.html" class="white">Security</a></h5> |
| <ul class="list-unstyled"> |
| <li><a href="http://apache.org/security" target="_blank" class="regular light-white">Apache Security</a></li> |
| <li><a href="http://apache.org/security/projects.html" target="_blank" class="regular light-white">Security Projects</a></li> |
| <li><a href="http://cve.mitre.org" target="_blank" class="regular light-white">CVE</a></li> |
| </ul> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="row bottom-footer text-center-mobile"> |
| <div class="col-sm-12 light-white"> |
| <p>Copyright © 1999-2016 The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache TomEE, TomEE, Apache, the Apache feather logo, and the Apache TomEE project logo are trademarks of The Apache Software Foundation. All other marks mentioned may be trademarks or registered trademarks of their respective owners.</p> |
| </div> |
| </div> |
| </div> |
| </footer> |
| <!-- Holder for mobile navigation --> |
| <div class="mobile-nav"> |
| <ul> |
| <li><a hef="../../latest/docs/admin/index.html">Administrators</a> |
| <li><a hef="../../latest/docs/developer/index.html">Developers</a> |
| <li><a hef="../../latest/docs/advanced/index.html">Advanced</a> |
| <li><a hef="../../community/index.html">Community</a> |
| </ul> |
| <a href="#" class="close-link"><i class="arrow_up"></i></a> |
| </div> |
| <!-- Scripts --> |
| <script src="../../js/jquery-1.11.1.min.js"></script> |
| <script src="../../js/owl.carousel.min.js"></script> |
| <script src="../../js/bootstrap.min.js"></script> |
| <script src="../../js/wow.min.js"></script> |
| <script src="../../js/typewriter.js"></script> |
| <script src="../../js/jquery.onepagenav.js"></script> |
| <script src="../../js/tree.jquery.js"></script> |
| <script src="../../js/highlight.pack.js"></script> |
| <script src="../../js/main.js"></script> |
| </body> |
| |
| </html> |
| |
