pool « oracle « Java Database Q&A

  1. Java Database Q&A
  2. oracle
  3. pool




1. How to auto reconnect Oracle connection pool after connection interruption?    stackoverflow.com

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 ...

2. Oracle JDBC connection pooling with databae link    stackoverflow.com

I'm building a J2EE web apps with Oracle database. The app server uses JDBC connection pooling to Oracle database A (e.g. 20 connections max), and some of the queries performed ...

3. How good is Oracle Universal Connection Pool (UCP)    stackoverflow.com

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?

4. jdbc connection pooling    stackoverflow.com

Can anybody provide examples or links on how to establish a JDBC connection pool? From searching google I see many different ways of doing this and it is rather confusing. Ultimately I need ...

5. Java Oracle connection pooling - Closed Connection exception    stackoverflow.com

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 ...

6. what is the criteria to adjust the propertires of pooling conenction    stackoverflow.com

how can i adjust the properties of connection pooling like 

setMaxPoolSize();
setMaxIdleTime();
setMaxPoolSize();
setMinPoolSize();
setInitialPoolSize();
setPropertyCycle();
setMaxStatements();

7. Problem Setting Pooling Property on oracle.jdbc.pool.OracleDataSource    stackoverflow.com

I use the oracle.jdbc.pool.OracleDataSource for connection pooling. I would like the pool to check whether the connection was not closed properly and to catch it up. I tried the following: 

ods = ...

8. My Java program freezes on call to oracle.jdbc.pool.OracleOCIConnectionPool.getConnection for a couple of minutes    stackoverflow.com

I have a Java app which connects to oracle 11g. The process freezes for 2 to 3 minutes at the oracle.jdbc.pool.OracleOCIConnectionPool.getConnection method. It does manage to get the connection and continues ...

9. How to set Oracle DB connection pool size to infinite?    stackoverflow.com

My client needs infinite number of Connections. I know this is a wrong approach but just for the knowledge can we set the connection pool size to infinite?





10. How to use connection pool in jdbc with oracle database?    stackoverflow.com

I am using jdbc to write a java desktop application, and this application will connect to oracle database.
is the DBCP library still work ? How can I configure a datasource in ...

11. How to create connection pooling in Glashfish server using oracle    forums.netbeans.org

Hi All, I am new to glashfish server.So I just want to a way to make connection pooling in glashfish server.Can you help me out ? If you have any screenshot ...

12. Connection Pool and Oracle    coderanch.com

13. Using connection pool on Oracle 8i temporary tables    coderanch.com

Hi all, In ORACLE 8i, for temporary tables and cursors, after creation if we are incrementally trying to query the temporary table or cursor (in profile reports), there is no guarantee that we will get the same connection as the one we got for the first time because we are using pooled connections from the middle tier. This could lead to ...

14. oracle.jdbc.pool    coderanch.com

15. urgent help (on oracle connection pool)    coderanch.com

Hi, I am using oracle connection pool ...I am getting new connection each time when i run jsp page ...... It is not getting the connection from pool ............. When i try to print connection object it is giving different object each time ....................... What is the wrong in my code .............. Is any one using oracle connection pool ................ Please ...

16. oracle statement caching in connection pool    coderanch.com

I've downloaded the latest version of Oracle JDBC Driver v9.2 and tried the new statement caching feature and see how it works within connection pooling. I wrote this class that basically would get a connection from pool and loop throught a query 10 times (without statement caching) and return the elapsed time, then the do the same with statement caching. How ...





17. Setting Pool Size in Oracle Connection Pool    coderanch.com

18. Oracle Connection Pooling    coderanch.com

I have a need for some simple Oracle connection pooling in a jsp. I found this example but it seems to defeat the purpose of reusing connections if new ones are created each time the page is refreshed. <%@ page import="java.sql.*" %> <%@ page import="oracle.jdbc.pool.*" %> <%@ page import="oracle.jdbc.driver.*" %> <%@ page import="oracle.jdbc.oci8.*" %> <%@ page import="javax.sql.*" %> <% PooledConnection conn ...

19. Oracle JDBC Pool example    coderanch.com

David, The ways for creating connection pools for most of the different databases are the same or similar. If you are using Oracle as back end for a web application, your best bet is to use the connection pools provided by the application server you are using. All major servers including Tomcat provide some kind of database connection pooling mechanism. Otherwise, ...

20. Oracle connection pool thru app server?    coderanch.com

I will be writing a web app that hits an oracle db. I plan to use the oracle oci drivers so that I can use proxy authentication. My web server is the Sun Java System Web Server 6.1, and we use it's internal app server capabilities for our app server. I had planned on manipulating the oracle connection pool directly from ...

21. XA Connection Pool and Oracle on a WebLogic Server    coderanch.com

This exception happen ever so often and I can not explain why. Does anyone have any suggestions? The code works fine in WebSphere Application Server (WAS), but not WebLogic. We are going to Oracle database using ojdbc1.4 drivers. java.sql.SQLException: User: , failed to be authenticated. at weblogic.jdbc.common.internal.RmiDataSource.getSubject(RmiDataSource.java:264) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:195) at com.company.sws.pi.dao.factory.OracleDAOFactory.getJdbcConnection(OracleDAOFactory.java:263) at com.company.sws.pi.ejb.workflow.WorkFlowEJBBean.authenticateUser(WorkFlowEJBBean.java:674) at com.company.sws.pi.ejb.workflow.WorkFlowEJBBean.logon(WorkFlowEJBBean.java:3400) at com.company.sws.pi.ejb.workflow.WorkFlowEJB_ftcxrk_EOImpl.logon(WorkFlowEJB_ftcxrk_EOImpl.java:4307) at com.company.sws.pi.web.delegate.login.LoginBusinessDelegateImpl.logon(LoginBusinessDelegateImpl.java:63) at com.company.sws.pi.web.login.actions.LoginAction.execute(LoginAction.java:52) ...

22. Oracle Connection Pooling    coderanch.com

Hello guys, I am trying to setup Oracle Connection Pooling for a webapp I am working on. I am using the following code: ... import java.sql.Connection; import java.sql.SQLException; import java.util.ArrayList; import java.util.Iterator; import java.util.Properties; import javax.sql.PooledConnection; import oracle.jdbc.pool.OracleConnectionCacheManager; import oracle.jdbc.pool.OracleConnectionPoolDataSource; import oracle.jdbc.pool.OracleDataSource; import oracle.jdbc.pool.OracleOCIConnectionPool; import org.apache.log4j.Logger ... /** * Test the Oracle pool connections and how many logical can ride on ...

23. RogueWave connection pooling inactive session Oracle V$session    coderanch.com

We are using roguewave connection pool in our application. Lot of inactive session is getting created in Oracle V$session table. Once count increases to 500 inactive session, we need to delete all rows from the v$session table in order to get our application working. What can be done in order to stop creation of inactive session in Oracle v$session ? Is ...

24. Oracle Aps Server - Connection Pooling    coderanch.com

Hi Friends, Could you please help me to create a JDBC connection polling in Oracle application server. I can able to create a connection pooling for oracle database. But my requirement is DB2 database conncection pooling and data source configuration in Oracle Aps server. When I tried to configure, I'm getting an error like "Unable to create : com.ibm.db2.jcc.DB2Driver Missing class: ...

25. A question about creating a Connection pool that uses Oracle JDBC    coderanch.com

Dear all, I have an issue with creating a connection pool within a web application in order to be used by several servlets. I appreciate if you could kindly give me a hand. I'm using: Web server: Apache-tomcat: 6.0.18 Oracle Database 11g Enterprise: 11.1.0.6.0 - Production Operating system: Linux (ubuntu 8.10) IDE: Sun Netbeans Oralce JDBC Drivers: 11.1.0.7.0-Production (ojdbc6.jar and orai18n.jar) ...

26. Oracle Connection pooling    forums.oracle.com

I have created a distributed desktop application not a web application and used oracle 10g database server with Java. 1000 of users may use the system and if every one try to access database at same time there may be overhead. How i optimize the number of connections. I have asked about connection pooling with web servers. web servers are controlling ...