How to use Java JDBC connection pool?
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? ...
connection-pooling
What SQL-Server lock level is suitable for insert?
I want to make almost 1000 inserts in a table in each second. And also each day I want to query all inserted rows just once at altogether. And I want to improve efficiency by multi-threading and connection-pooling. But i want to know which level of concurrency control is more suitable for me. The list of options for SQL-Server are in MSD...
Tips about Connection pooling [Sql Server 2005]
Many of the users of Stackoverflow might have very well known connection pooling... As i am a newbie i am interested in knowing, Connection pooling tips and tricks [sql server 2005] ...
WebSphere 5.1: Setting JDBC datasource connection as "unshareable"
L.S. Our DB provider has suggested that we use "unshareable" connections when connecting to their DB. I have a reasonable understanding about the pros/cons of using "unshareable" connections, and our programming model will not cause any issues mentioned in various blog posts. Can anyone give me an idea of how to make our JDBC datasourc...
.NET best practices for MongoDB connections?
I've been playing with MongoDB recently (It's AMAZINGLY FAST) using the C# driver on GitHub. Everything is working just find in my little single threaded console app I'm testing with. I'm able to add 1,000,000 documents (yes, million) in under 8 seconds running single threaded. I only get this performance if I use the connection outsi...
Can I set the password of a JDBC connection from the Connection Pool? (Tomcat 5.5.17)
Hi, I have a connection pool set in the tomcat server context.xml (connection used by several webapps so seems the best place for it). However, I don't like having passwords hard-coded in the file. Is there any way for me to retrieve the password from elsewhere (secure password store) and set it pragmatically at the time the pooled co...
TransactionScope helper that exhausts connection pool without fail - help?
A while back I asked a question about TransactionScope escalating to MSDTC when I wasn't expecting it to. (Previous question) What it boiled down to was, in SQL2005, in order to use a TransactionScope, you can only instance and open a single SqlConnection within the life of the TransactionScope. With SQL2008, you can instance multiple ...
Scope of Connection Object for a Website using Connection Pooling (Local or Instance)
For a web application with connection polling enabled, is it better to work with a locally scoped connection object or instance scoped connection object. I know there is probably not a big performance improvement between the two (because of the pooling) but would you say that one follows a better pattern than the other. Thanks ;) public...
What are some good ways to do connection management in C?
In C, when making a networking client / server setup, I usually have to do some standard BSD socket setup. Then on the server side, I'll have to manage multiple threads, usually a main thread, an a io thread. Each connection is managed by a connection manager so that you can have connections being processed while new requests are coming ...
JDBC MySql Connection Pooling practices
I have a Java-JSF Web Application on GlassFish, in which I want to use connection pooling. Therefore I created an application scoped bean that serves with Connection instances for other beans: import java.sql.Connection; import java.sql.SQLException; import javax.sql.DataSource; import javax.naming.Context; import javax.naming.InitialCo...
mixing basic DataSource with connection pooling DataSource: when to call close()?
I'm in the process of adding connection pooling to our java app. The app can work with different rdbmses, and both as a desktop app and as a headless webservice. The basic implementation works fine in desktop mode (rdbms = derby). When running as a webservice (rdbms = mysql), we see that connection pooling is needed to get good concurr...
What's the difference between Tomcat JNDI based and Spring/Hibernate DS based connection pooling
I have been looking into connection pool options and it is somewhat unclear to me what the differences in Tomcat JNDI connection pool approach is, compared to the Spring/Hibernate solution to the same. Whilst it's possible to achieve the pooling using either 1, 2, the specific application we have would lend itself better to us using To...
What really is connection pooling?
I have heard the term connection pooling and looked for some references by googling it... But can't get the idea when to use it.... When should i consider using connection pooling? What are the advantages and disadvantagesof connection pooling? Any suggestion.... ...
Design for ConnectionPool
When some one asks you to write (do / depict) design for Connection Pool in a Java interview what would you typically write. Do you write code for connection pool or do you depict the Class diagrams. Can somebody please explain the design of Connection pool. ...
ASP.NET websites under IIS 7.5 (Windows 7) running extremely slow
I've just installed Windows 7 x64 Ultimate on my desktop PC. I installed IIS, Visual Studio 2008, registered ASP.NET, etc. I have this ASP.NET 3.5 website I'm working on running EXTREMELY slow on this new IIS. On STA and PROD servers (Windows 2003 Server) and on my old XP/IIS 5.1 everything runs smoothly. A page which usually takes 1-2...
How does Connection pool work in Ado.net?
I am connecting to a legacy rdbms system using System.Data.OdbcClient. I would like to know if the connection pool is supported by the legacy rdbms system? Suppose I use Connection as shown below using (OdbcConnection con = new OdbcConnection("ConnStr")) { con.Open(); //perform db operation } Does it establishes a connection...
Connection Pooling in J2SE?
It is hard to find a resource on this without finding J2EE, but here is what I am looking for: All I have is a standard J2SE app, it makes a lot of DB connections. I simply need to make use of a connection pool. Any suggestions? ...
Java: Sharing a connection pool accross other J2SE Apps...?
So I have a connection pool setup. Which is great and all since I have an application that really needs it. However what I would like to know is if it is possible to share this connection pool with other J2SE apps? Would this even be worth it, as opposed to creating a connection pool based on each apps needs? If it would be prudent, how ...
How good is Oracle Universal Connection Pool (UCP)
Does anybody have experience with using Oracle UCP under real production load? Does it handle database reconnects well? Are there any multi-threading issues? Has anybody compared it with C3P0 or Apache DBCP? ...
TransactionScope and Connection Pooling
Hi, I'm trying to get a handle on whether we have a problem in our application with database connections using incorrect IsolationLevels. Our application is a .Net 3.5 database app using SQL Server 2005. I've discovered that the IsolationLevel of connections are not reset when they are returned to the connection pool (see here) and ...