Does anyone know the best (or any) way to flush a JDBC connection pool? I can't find anything obvious in the documentation. It appears connection pools aren't meant to ... |
We notice something strange in our struts web application which was hosted on sun app server enterprise edition 8.1.
The NumConnUsed for Monitoring of JDBC resources stays at 100 over connections even ... |
I'm working with open esb on a glassfish server.
We have a connection pool that works with an as400 Database.
Every couple of days we get this error:
Error in allocating a connection. Cause: ... |
Does anyone have any information comparing performance characteristics of different ConnectionPool implementations?
Background: I have an application that runs db updates in background threads to a mysql instance on the same ... |
Following is the source code:
//public class ConnectionPool implements Runnable
public class ConnectionPool {
private static Logger loger_error = Logger.getLogger("error");
// JDBC Driver name
...
|
We've found a bug in old code where connections aren't being closed. It's an easy fix, but I'm wondering how we go about proving that it's fixed. There is a ... |
I want to use a JDBC connection pool. The most important factor is that it's easy-to-use and bug-free. What is suitable for me?
|
|
Which of these approaches is better: connection pooling or per-thread JDBC connections?
|
As per my understanding, JDBC Connection Pooling (at a basic level) works this way:
- create connections during app initialization and put in a cache
- provide these cached connections on demand to the app
- a ...
|
I have a short script opening datasource and then closing it. This script is using BasicDataSource.
BasicDataSource bds = new BasicDataSource();
bds.setDriverClassName("com.mysql.jdbc.Driver");
bds.setUrl("jdbc:mysql://10.1.1.186:3306/logs");
bds.setUsername("root");
bds.setPassword("");
Connection connection = bds.getConnection();
System.err.println(connection);
bds.close();
After the close() command works, when I look in ... |
I've been looking at a number of JDBC connection pools, but I have the specific requirement that the pool needs to be JTA aware, which leaves me with a short list ... |
We have set a JDBC Connection Pooling in our service. THe problem is that, We are getting the connection in 15 to 20 secs only in non-peak times. At the other ... |
I am using an API to connect to some hardware terminals and networks. The API allows me to connect to the servers, disconnect and interrogate for data, pretty similar to what ... |
Suppose I have the following code
DataSource source = (DataSource) (new InitialContext()).lookup("jdbc/myName");
Connection connnection = source.getConnection()
//use the connection to do some database operations...
at the end, should I still call
connection.close() ... |
I am writing a ETL project in JAVA. I will connect to the source database, get the data only once, do some transformations and Load the data to a target database.
The ... |
While running through a piece of code for performance tuning, i noticed that the pooled database connection is not used immediately, it follows some pre-processing before the connection used to delegate ... |
I'm using AS400JDBCConnectionPoolDataSource and AS400JDBCConnectionPool in order to create a connection pool inside my project.
this is my code for creating it:
AS400JDBCConnectionPoolDataSource dataSource ...
|
I have wriiten my connection pooling by extending connection and driver class. It is working fine but the problem is I want to now impose a upper limit and if te ... |
I'm reading Java Data Access—JDBC, JNDI, and JAXP about Connection, PooledConnection interfaces. As I understand Connection returned by PooledConnection represents a "logical" connection. PooledConnection - itself represents "physical". What's the difference ... |
We are evaluating a JTA transaction manager for a legacy Oracle JDBC project and have looked at Bitronix and Atomikos so far.
The java.sql.DataSource implementations of both the Bitronix and Atomikos connection ... |
First off, I am developing my own implementation of DBCP (database connection pooling), as such,
I won't accept any suggestions to use 3rd party DBCP like c3p0.
I'm using the producer-consumer design ... |
I have some c3p0 pool encapsulated in a class that I use to execute SQL statements.
It's initialized this way:
public PooledQueryExecutor(String url, Properties connectionProperties) throws DALException {
...
|
|