Is it possible to access a Apache::DBI database handle from a perl script (that isn't running under mod_perl). What I am looking for is database pooling for my perl scripts, I have a fair number of database sources (oracle/mysql) and a growing number of scripts. Some ideas like SQLRelay, using Oracle10XE with database links and pooling...
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 separate thread maintains the Connection Pool, performing activities like: discard connections that have been used (closed) create ...
We've recently moved our company website to a new host. It is an ASP.NET site with C# code behind, connecting to MS SQL server. Since moving the site to the new server, the site is exceeding the connection pool limit (which is not set explicitly, so I believe is at the default size of 100). Inspection of the open processes via SQL Serv...
We've been seeing this problem for a while now and I'm really trying to wrap my head around what's causing it. A couple of times a day we'll see periods where web pages start throwing "[Microsoft][ODBC SQL Server Driver]Timeout expired" then shortly afterward pages start throwing "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server ...
Is it safe to run a database connection pool (like Commons DBCP or c3p0) as part of an application deployed to an application server like Glassfish or Websphere? Are there any additional steps over a standalone application that should be taken to ensure safety or performance? Update, clarification of reason - the use case I have in mi...
I am having a near critical issue with my app using SqlClient against a MS SQL server. The problem is that the SQL server is clustered in a Failover Cluster. If one of the nodes fails or the other node is made active, it seems like the connectionpool is still connected to the old server. The result is that I get exceptions as that nod...
I'm trying to send a JMS message from one JBoss AS 5.1 instance to the other. For my test I have them both running on localhost, the client JBoss AS instance with the normal port settings and the server JBoss AS with the setting where all ports are offset by 100. In an EAR project on the client, I've defined a JMS provider loader in a f...
Hi In our project user using NHibernate 2.1.1 with SQL Server 2008 with .net 3.5. I am facing strange problem with SQL Server. We developed windows service, installed it and it was running fine for sometime. Unfortunately by mistake when I stopped SQL Server, NHibernate throw exception System.Data.SqlClient.SqlException: A netwo...
I have an application that I use BoneCP for connection pooling and when I deploy the war to tomcat, it works perfectly. But when I create another war (almost identical, just different skin and DB connection) ans deploy them both the I get the following error when tomcat starts up: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnect...
Hello, This post is intended to be less of a question and more a confirmation that I'm doing things correctly. I've seen many similar posts but I'm not sure I fully understand everything that's been said. The problem is that, after a certain amount of time, I get an exception when trying to establish a connection to my oracle database....
Further to my recent questions, I've now closed most of the connections that our web application was leaving open. However, the connection created by the function below remains open. Can anyone identify why it is not closing? public DataTable GetSubDepartment(int deptId) { DataTable dt = new DataTable(); using (SqlConnection ...
I am using connection pool from an external vender. I want to expose the properties a set to the pool for management using JMX so these can be changed from JConsole. I was considering DynamicMbean or MXBean. I am very new to using JMX. Can someone give me advantages and disadvantages of both in the scenario which i am using. ...
Folks I am implementing a file based queue (see my earlier question) using sqlite. I have the following threads running in background: thread-1 to empty out a memory structure into the "queue" table (an insert into "queue" table). thread-1 to read and "process" the "queue" table runs every 5 to 10 seconds thread-3 - runs very infrequen...
From the examples that I have read and from the documentation on MysqlConnectionPoolDataSource at http://www.control.auc.dk/~04gr733/filer/javadoc-DB-driver/com/mysql/jdbc/jdbc2/optional/MysqlConnectionPoolDataSource.html it seems that Java SE applications cannot use connection pooling. Is this true? Can I get connection pooling to work ...
Hi, I have a multithread server that uses one MSSQL which each client should have access to. I wanted to use connection pooling also I am using this: public static void DBconn() { SqlConnection pripojeni = new SqlConnection(); pripojeni.ConnectionString = "Data Source=localhost\\SQLEXPRESS;Initial...
seen question about that today but I not sure whether I understand it well. Also using the same connection string causes that they will "share" connections (if free), right? So is it OK to have class like that, pass it as a reference to each client in multithread app and just call its methods. Anyway, would not there be a short lag in th...
Does Connector J really not support connection pooling. Looking at their documentation I have to download a 3rd party library such as DBCP or c3p0 to get this right. What is the motivation for not introducing it in the Connector J driver itself? Is this something that the J2EE spec dictates? ...
Regarding best practice for managing database connections in a .NET application -- I know that, in general, it's bad to pass around a connection object. However, I have some specific curiosities: 1. I have two instances of business objects, of different classes, in a parent-child relationship (the child is private.) Whic...
Hi The title pretty much says it all, but here's some background. We have a database configured in glassfish accessed by a website deployed on glassfish, we also access the database from an external java application, it occurred to me that this could be somewhat inefficient since we open quite a few connections to the database from our...
Is it possible to create a command line application (without an application server) That uses a connection pool in order to access the database?. And how to do it? I've tried it using an InitialContext object and look up for the datasource in the context but since i don't have an application server i don't know how to access the resou...