Enable ODP.Net performance counters
How can I enable the ODP.Net Performance Counters for my web app??? I'm Using: .Net 2.0 Oracle 11g Windows 2008 R2 ...
connection-pooling
java.lang.NoSuchMethodException: com.mchange.v2.c3p0.PoolBackedDataSource.setUserOverridesAsString(java.lang.String)
Hi all. I'm using C3P0 0.9.1.2 to configure data sources for my connection pool. When context is loading an error is raised. Here is the trace: java.lang.NoSuchMethodException: com.mchange.v2.c3p0.PoolBackedDataSource.setUserOverridesAsString(java.lang.String) at java.lang.Class.getMethod(Class.java:1605) at com.mchange.v2.c3p0...
Hibernate, C3P0, Mysql Connection Pooling
Hi all, I recently switched from Apache DBCP connection pooling to C3P0 and have gone through my logs to see that there are connection timeout issues. I haven't had this in the past with DBCP and Tomcat, so I'm wondering if it is a configuration issue or driver issue. Whenever I load a page after the server has been idle for a while, ...
PHP and mod_dbd
Does anyone know a PHP extension to use mod_dbd for database connections? Our application needs to access a remote database. It used to be an Apache module using mod_dbd for database connections and the transaction takes about 200ms. Now we changed the application to PHP and the same transaction takes over 600ms now. We hope some kind o...
JDBC Connection pool not reopening Connections in tomcat
Hi, I have set up tomcat to use a connection pool yet after the mysql timeout on connections the connections previously open in the pool are not opened.Here is what my context.xml file looks like: <Resource name="jdbc/hpsgDB" auth="Container" type="javax.sql.DataSource" maxActive="5" maxIdle="3" maxWait="10000" u...
Get number of free connections in connection pool
In my project Spring manages connection pool with org.apache.commons.dbcp.BasicDataSource class. Is possible to get how many connections are free or used in current time? Thanks. ...
Connection Pool in the context of ADO.NET
Like in ThreadPool Is connection pool is a waiting threads for establishing ADO.NET connection controlled by CLR ?. I mean "Pooling" mechanism is same in both ADO.NET and MultiThread ? ...
Connection pooling in .Net Sql Provider - when connection is closed
Hi, I just wonder after what duration .Net Sql Provider will close connection which is in pool? Thanks, Pawel ...
does connections count matter?
We have an application that uses NHibernate to connect to our database on SQL Server.We use connection pooling and session per request approach to execute our queries over SQL Server. We used SQL Server Activity Monitor to monitor connections count and noticed there was 25-30 connections involved whenever a user logged in to system. So h...
Externalizing tomcat jdbc connection pool information for different environments
Greetings, I'm looking for a good solution for externalizing the JNDI connection pool information in context.xml of a war so that as the application moves from dev to QA to prod, the war file won't need to be recompiled. Ideally the url, driver, username and password would be variablized and then populated by means of a properties file...
Keep connection open for multiple web service requests
Hello, I would have question regarding web services. Let's say I have webservice client that has to perform under high load. And I cannot use another technology. Is it possible somehow to keep the connection open for all requests, to avoid overhead when establishing new tcp/ip connections? And in case of managed environment, is it possi...
Switching users on a JDBC Connection
I am writing a Java JDBC database application that connects to an Oracle 11g database and am using a c3p0 connection pool. For the purposes of an example, I have 3 database users DEFAULT, TOM, and BILL. c3p0 opens all of the pooled Connections with the DEFAULT database user. I would like to retrieve one of the pooled Connections from c3p...
.NET webservice call pooling?
I am writing acceptance tests to validate a system and it's data access is all done through web service calls. Unfortunately, because I make so many calls, so quickly, I run into the following error System.Net.Sockets.SocketException: Only one usage of each socket address (protocol/network address/port) is normally permitted ...
hibernate connection pool
I can't seem to get hibernate to use c3p0 for connection pooling, it says 12:30:35,038 INFO DriverManagerConnectionProvider:64 - Using Hibernate built-in connection pool (not for production use!) 12:30:35,038 INFO DriverManagerConnectionProvider:65 - Hibernate connection pool size: 20 Hibernate Config: <hibernate-configuration> <...
c3p0 Connection Checkin
I'm trying to implement a solution with c3p0 for the first time. I understand how to initialize the connection pool and "checkout" a Connection from the pool as follows: ComboPooledDataSource cpds = new ComboPooledDataSource(); cpds.setDriverClass(driverClass); cpds.setJdbcUrl(url); cpds.setUser(username); cpds.setPassword(password); Co...
getting request timeout exceptions from a asp.net application using the Oracle client with multiple schemas
We have an asp.net application that uses the Oracle client. In the connection string, we specify the 3 basic attributes: data source, User Id, and Password. We are using connection pooling. Our data resides in 2 different Oracle schemas. Most of the requests are for data from Schema1. The timeouts are coming from calls for data from...
Manage database connection using connection pool or session. How?
I have a simple task to accomplish, but I am not sure what is the best way to go by. Each user has their own username and password to connect to a database with different privilege. Once the user connect, he will do multiple query base on what action he want to perform. Therefore I want to retain the connection with the database. So h...
How do you efficiently connect to mysql in php without reconnecting on every query.
I'm pretty sick of having to rewrite my code every time I learn something new about php (like the fact that mysql connections cannot be passed around in a session as a handle). How do you implement mysql connection in your projects? A lot of people have proposed "connection pooling", but after reading the manual i'm still lost. It's lik...
Jetty mysql connection-pool configuration error: javax.naming.NameNotFoundException; remaining name 'env/jdbc/---(mysql 5.0+jetty 7.0.1)
My configuration files project/WEB-INF/web.xml: <resource-ref> <description>ConnectionPool DataSource Reference</description> <res-ref-name>jdbc/mysql</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> project/WEB-INF/jetty-env.xml: <New id="mysql" class="org.eclip...
SQL Server connection pool doesn't detect closed connections?
For years, I've experienced very weird problems on all my web applications that connect to a SQL server. The problem is that if something happens to the database server (server restart or other problem), de web app stops working from that point on, even if the database server is alive and well afterwards. What happens is that every ADO...