I have a circumstance where a JDBC connection places the Oracle session to which it is attached into a particular state (i.e. DBMS_FLASHBACK enabled mode). It's possible for the exit of this mode to fail (at least theoretically) which means that the session is left in the state erroneously. In this case, the connection can be returned to...
I am using connection pooling in my application. My question is: Is it explicitly required to close statement before closing connection in case of connection pooled environment? In connection pooled environment connection is not getting closed, (but returns back to free connection pool). I had checked jdbc 4.0 functional specs. In poin...
I know with some connection pools, you can specify a test query the pool manager can use to validate a connection. Is there anything similar to that for asp.net? I'm having a problem where there's a firewall between the web app and the database, and it's closing idle connections - the result is that the user gets an "ORA-03135: connect...
My application runs on Sun Java Application server v8.1 and it connects to an 0racle(10g) DB using the application server's jdbc connection pool. The datasource class name used in the pool is 'oracle.jdbc.pool.OracleDataSource'. I have enabled connection caching and I want to use the 'TimeToLiveTimeout' property for this DataSource.'Tim...
Is it possible to detect an error in a connection before we get an application "Transport-level error" using Linq? Lets say that I have a SQL server called SQLServer1, and I am running an application that connects to that server using LinQ to get some information. I decide to change the server Name to SQLServer2. The next time my appl...
I'm trying to debug some resource leaks - oracle connections specifically. On my local machine, as I step through the Page_Load(), I can see the connections created in the db by monitoring v$session. As soon as I step out of Page_Load, all the connections are closed. Same code running on the dev server (W3k, IIS6) does NOT release the...
According to the MSDN documentation for the OracleClient.OracleCommand: Public Sub ReadMyData(ByVal connectionString As String) Dim queryString As String = "SELECT EmpNo, DeptNo FROM Scott.Emp" Using connection As New OracleConnection(connectionString) Dim command As New OracleCommand(queryString, connection) con...
In our project, we use the Oracle XA Connection pool. Only a small subset of the queries(transactions) are distributed. Rest are quite straightforward single database modification. I would like to know if there is a performance difference in using XAConnections Vs the normal ones. We use websphere v6.1 as the server. If XAConn, is ...
We have some client code which is using the SqlConnection class in .NET to talk to a SQLServer database. It is intermittently failing with this error: "ExecuteReader requires an open and available Connection. The connection's current state is Closed" The "temporary" solution is to reboot the process, after which everything works - howe...
Specifically, when I return a connection to the pool, does dbcp (and other connection pools) close the statements and resultsets for me? Or should I be closing these myself? ...
I'm running across a problem with Oracle connection pooling via OracleConnectionCacheImpl. When I connect to a connection pool on my database server (Oracle 10g) via the thin driver, everything works fine until after an unspecified time, the db connection gets dropped (possibly due to idle connections?) and I get an error message: C...
I am using Apache DBCP with JNDI in my tomcat container to pool connections to a mysql database. Everything works fine but a problem i am seeing is that once a pconnection is pooled it is never released. So after a load spike connection sit their forever sleeping. Is their a way to shrink the pool through context.xml parameters? here...
An EJB3 stateless session bean exposing CRUD operations for an entity bean will contain read / write methods which go against a single connection pool. If you would like to have your read & write operations go against different databases for scalability purposes, how do you accomplish this at the code level. Any pointers to appropriate d...
I have a client-server app that uses .NET SqlClient Data Provider to connect to sql server - pretty standard stuff. By default how long must connections be idle before the connection pooling manager will close the database connection and remove it from the pool? What setting if any controls this? This MSDN document only says The con...
I am a Java programmer who learns Haskell. I work on a small web-app that uses Happstack and talks to a database via HDBC. I've written select and exec functions and I use them like this: module Main where import Control.Exception (throw) import Database.HDBC import Database.HDBC.Sqlite3 -- just for this example, I use MySQL in produ...
I have a question related to Prepared Steatement pooling (across all connections). Here's the config file <datasources> <local-tx-datasource> <jndi-name>JNDI-NAME</jndi-name> <connection-url>jdbc:mysql://<server_name>/<database_name>?useServerPrepStmts=true</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class...
I understand that if I instantiate a SqlConnection object, I am really grabbing a connection from a connection pool. When I call Open(), it will open the connection. If I call the Close() or Dispose() method on that SqlConnection object, it is returned to the connection pool. However, that doesn't really tell me if it's really closed,...
I am running a webapp inside Webpshere Application Server 6.1. This webapp has a rules kind of engine, where every rule obtains its very own connection from the websphere data source pool. So, I see that when an use case is run, for 100 records of input, about 400-800 connections are obtained from the pool and released back to the pool. ...
Sorry if this is a duplicate, i've read many questions that are either very similar or require roughly the same keywords to describe (but aren't quite the same)... situation: an asp.net application has a connection pool memory leak problem (where connections are not being closed correctly for example)...I need clarity on the following: ...
I have studied the Websphere document "Connection Life Cycle" for Websphere Application Server Express v6.1 and and have searched the web for an answer to the following. Connection Pool State Pretest existing pooled connection is selected - retry interval is zero seconds Pretest new connections is selected - # of retries is zero and r...