Databases
StackOverflow2013
Postsdbo
PODoes MySql support connection pooling for Java SE applications?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODoes MySql support connection pooling for Java SE applications?
    primarykey
    data
    text
    <p>From the examples that I have read and from the documentation on MysqlConnectionPoolDataSource at <a href="http://www.control.auc.dk/~04gr733/filer/javadoc-DB-driver/com/mysql/jdbc/jdbc2/optional/MysqlConnectionPoolDataSource.html" rel="nofollow noreferrer">http://www.control.auc.dk/~04gr733/filer/javadoc-DB-driver/com/mysql/jdbc/jdbc2/optional/MysqlConnectionPoolDataSource.html</a> it seems that Java SE applications cannot use connection pooling. Is this true? Can I get connection pooling to work for MySql?</p> <p>Does the same go for PreparedStatement pooling?</p> <p>UPDATE: I came across the following from the MySQL website with regards to their connection pooling.</p> <pre><code> /* * Create a JNDI Initial context to be able to * lookup the DataSource * * In production-level code, this should be cached as * an instance or static variable, as it can * be quite expensive to create a JNDI context. * * Note: This code only works when you are using servlets * or EJBs in a J2EE application server. If you are * using connection pooling in standalone Java code, you * will have to create/configure datasources using whatever * mechanisms your particular connection pooling library * provides. */ </code></pre> <p>This is what has made me look at a way to get this right for a Java SE application. But re-re-reading it, it seems to me that they are making reference to the manner in which you obtain a reference to the datasource. Could I not use a dependency injection framework or manual insert a dependency on the datasource for my DAO object? I am going to give that a try.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuriDium
    1. USuriDium
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODoes MySql support connection pooling for Java SE applications?
      1. USBarranka
      1. VTFavorite
    2. VO
      singulars
      1. PODoes MySql support connection pooling for Java SE applications?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload