Stack Overflow
Stack Overflow

Questions tagged [ucp]

Oracle UCP (Universal Connection Pool) for JDBC provides a connection pool implementation for caching JDBC connections.

A UCP JDBC connection pool can use any JDBC driver to create physical connections that are then maintained by the pool. The pool can be configured and provides a full set of properties that are used to optimize pool behavior based on the performance and availability requirements of an application.

In fact, UCP creates virtual connections that wrap real physical connections. When virtual connections are being returned to the pool, UCP does not close the underlying physical connection so it can be retrieved again.

94 questions
3
votes
1 answer

OCI invalid operation ORA-01010

I am running a batch application that processes huge data files and puts the data into an Oracle 11g database. I am using Java 1.6.20, ojdbc6, and ucp11.2. Intermittently, I get ORA-01010 invalid operation SQLExceptions. When I looked up the…
JavaDev03
  • 141
  • 2
  • 9
2
votes
2 answers

Oracle UCP - FCF Planned Outage Support

I am I am testing the Fast Connection Failover(FCF) support from Oracle Universal Connection Pool (UCP) version 11.2.0.1.0. The scenario being tried out is a planned outage event. Oracle Database 11g Release 11.2.0.2.0 standard edition is the…
Andy Dufresne
  • 6,022
  • 7
  • 63
  • 113
2
votes
0 answers

Universal connection Pool shuts down automatically before application shutdown hook executes

I have my java application running on jetty which uses JDBC (uses UCP) to make database connection. Problem I am facing is during jetty shutdown, before my application shutdown hook executes, UCP goes on auto shutdown which is not desired since I…
Rajat
  • 103
  • 2
  • 12
2
votes
3 answers

Ojdbc8 jars upgrade to 21.1.0.0 throws Nosuchmethod exception UCPservletContextListener init

Ojdbc8, ons, ucp jars are upgraded to 21.1.0.0 version. When trying to start the app on tomcat server, it's throwing Nosuchmethod exception. Logged in the Tomcat's localhost.log file. Application tries to establish DB connection during startup…
Mahi
  • 21
  • 3
2
votes
0 answers

Oracle cursor leak after upgrading oracle driver

I'm facing a pretty intermittent issue related to oracle cursor leak. Our system runs on oracle 12.2.0.1 database. As per the oracle documentation suggested we recently upgraded our oracle connection pool to universal connection pool( also ojdbc7 to…
MaxExplode
  • 1,977
  • 2
  • 17
  • 27
2
votes
0 answers

Connection requesting thread from oracle UCP, stuck in Runnable state

Facing an issue with UCP connection pool, where the request to obtain connection from the pool is stuck in Runnable state by owner thread. Below is the stack trace of for stuck thread. From the error trace this looks to be stuck while borrowing…
tarunk
  • 549
  • 2
  • 7
  • 17
2
votes
0 answers

UCP Connection pool cannot create connection after a database network error

I have a problem with the Oracle Universal Connection Pool (UCP) implemented in a Scala application, for an Oracle Database. It works perfectly while there's a connection to the database, but when the network has some problem for a limited period…
Massimiliano
  • 615
  • 4
  • 15
2
votes
2 answers

Comparison of Oracle UCP, C3P0 and HikariCP

I am trying to compare Some of the java connection pool libraries, but so far I've not found any satisfactory answer. Right now C3P0 is being used in my application but I want to suggest other Connection Pool libraries but I don't have any solid…
Pranay Munshi
  • 71
  • 1
  • 5
2
votes
1 answer

Too many UCP Timer threads

I am using Oracle UCP 12.1.0.2.0. Overtime, it is starting too many Timer threads and eventually causing Out Of Memory error in JVM. Is there any fix or configuration change that I am missing.
Amit
  • 290
  • 2
  • 10
2
votes
1 answer

Oracle UCP Pool leaking cursor?

Our application has been using OracleDataSource successfully for several years and we are now evaluating switching to the new Oracle Universal Connection Pool (UCP). With the new UCP Pool, our application runs into ORA-0100: Maximum open cursors…
ewernli
  • 38,045
  • 5
  • 92
  • 123
2
votes
0 answers

Oracle UCP sql exception Cannot get Connection to Datasource

I am trying to integrate UCP and tomcat and i have made the configuration correct as given in the oracle docs but still something is missing and while connecting I am getting the following exception java.sql.SQLException: Unable to start the…
Mitul Karnik
  • 135
  • 1
  • 4
  • 11
2
votes
1 answer

Oracle UCP reconnect option

We have the following spring bean config for Oracle UCP. For some reason if DB is bounced then pool should automatically re-establish the connection back without restarting my webserver. It looks like the below bean config didn't work. I mean,…
Raghu
  • 41
  • 1
  • 7
2
votes
1 answer

Java DAL that recovers from database outage?

My DAL consists of Spring Data Access connecting to Oracle via Oracle's UCP. This means I am predominatly working with JdbcTemplate. A requirement for my server is to recover from a database outage, more specifically, if we have an outage our…
Mark
  • 75
  • 10
1
vote
1 answer

Universal Connection Pool Memory Management

I have been trying to upgrade my ojdbc code from ojdbc14-10.2.0.1.0 to ojdbc6-11.1.0.7.0. We have been using OracleConnectionCacheImpl for datasource connections and then moved to the Universal Connection Pool using OracleDataSource at the heart. …
JavaDev03
  • 141
  • 2
  • 9
1
vote
1 answer

Using Oracle queues with UCP

Is it possible to use UCP to create an OracleConnection to use enqueue method? Nowadays, which is the best way to enqueue a message into Oracle AQ queue from a java client using a Connection Pool? Javadoc from OracleDatasource advice about cache…
OscarRP
  • 85
  • 2
  • 10
1
2
3 4 5 6 7