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
7
votes
1 answer

Oracle UCP driver and tomcat: threads failing to stop

We are using Oracle the UCP driver (Oracle Universal Connection Pool) in tomcat 6. It is more or less configured like in Oracles Howto. The problem is that the driver starts a lot of threads (Thread-0 to 57, UCP-worker-thread-1 to 24) which aren't…
Dr. Hans-Peter Störr
  • 25,298
  • 30
  • 102
  • 139
7
votes
1 answer

Should I use Oracle's UCP or HikariCP for a modern application?

Which one should I use for a modern backend Java application using Oracle OLTP database as a datasource? To me HikariCP looks like a de-facto standard pool for a modern Java application. But now I need to maintain some project from the past, which…
Kirill
  • 6,762
  • 4
  • 51
  • 81
7
votes
4 answers

"java.lang.ClassNotFoundException: oracle.jdbc.pooling.Factory"

I'm having some sort of problem with ucp.jar If I use ucp.jar for oracle 12.1.0.1 it works. If I use the version for oracle 12.1.0.2 then I get the following exception: java.lang.ClassNotFoundException: oracle.jdbc.pooling.Factory Is there anyone…
Mauro Scire'
  • 71
  • 1
  • 2
5
votes
1 answer

Getting ORA-01882: timezone region not found with Oracle UCP, on aws ec2 instance?

I am running a springboot application (which is running fine on local machine), and getting ORA-01882: timezone region not found error on ec2 instance. Its looks like a config problem but not sure how to fix it. Stack trace is below Caused by:…
Shubham Pandey
  • 1,788
  • 2
  • 18
  • 24
5
votes
1 answer

Cannot find oracle.ucp.jdbc.PoolDataSourceFactory in Oracle ucp

I want to create Oracle UCP using this code: import oracle.ucp.jdbc.PoolDataSource; import oracle.ucp.jdbc.PoolDataSourceFactory; System.out.println("***** OracleDS_UCP -> start init of PoolDataSource"); PoolDataSource pool =…
Peter Penzov
  • 1,126
  • 134
  • 430
  • 808
4
votes
2 answers

Connection closed issue in UCP and Oracle 12 c

While migrating from Oracle 11g to Oracle 12 c, we are getting below error using UCP(12.1.0.2.0) java.sql.SQLException: The connection is closed: The connection is closed at…
Jay Sangoi
  • 41
  • 1
  • 2
4
votes
2 answers

JDBC: Oracle Universal Connection Pool Error UCP-45060 Invalid life cycle state

I am using Oracle UCP (Universal Connection Pool). I am getting the following error after processing around 100K records. oracle.ucp.UniversalConnectionPoolException: Invalid life cycle state. Check the status of the Universal Connection Pool …
Amr Eladawy
  • 4,193
  • 7
  • 34
  • 52
4
votes
1 answer

The connection is closed when using Oracle UCP

I'm getting random " The connection is closed: The connection is closed" errors when using Oracle UCP, v 12.1.0.2.0. It looks like connection is marked as closed in oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory#invoke…
user656449
  • 2,950
  • 2
  • 30
  • 43
3
votes
5 answers

Java 11 migration - createConnectionBuilder() from PoolDataSourceImpl clashes with createConnectionBuilder() from javax.sql.DataSource

I am trying to migrate a project from Java 8 to Java 11, which uses ojdbc. I am using a class which extends PoolDataSourceImpl, which implements PooLDataSource, which extends javax.sql.DataSource and while trying to built it with maven it gives this…
Dragos
  • 41
  • 1
  • 3
3
votes
0 answers

Exception oracle.ucp.UniversalConnectionPoolException Invalid life cycle state. Check the status of the Universal Connection Pool

I am getting below exception in one of Spring Batch Unit run while getting connection from pool. I have diagnosed and also tried by changing the properties of pool but still same error in only one specific test. All other tests are running…
vishal
  • 71
  • 2
  • 7
3
votes
1 answer

Oracle OCI Connection Pooling vs Oracle UCP

Oracle offers 4 different JDBC connection pooling mechanisms when the OCI driver is used for JDBC connections: Oracle DataSource Oracle OCI Connection Pooling Oracle UCP (Universal connection pooling -recommended over OracleDataSource) Oracle…
Andy Dufresne
  • 6,022
  • 7
  • 63
  • 113
3
votes
1 answer

Oracle UCP performance issue during binding variables

Recently we change our connection pool to migrate for Oracle UCP. Before the migration, we used the pool embeded with the oracle jdbc driver (ojdbc6.jar). Our problem is the elapsed time during the phase of the bind variables. With UCP, the time to…
3
votes
1 answer

JPA Hibernate + UCP Oracle. Query executed from save method does not use the index of the table

I'm using the interface CRUDRepository in order to use the save method in other class where Repository is injected. This method does an insert and a select for retrieve this object inserted from database, I mean. The query executed is quite…
Iván
  • 173
  • 1
  • 1
  • 8
3
votes
1 answer

Using TNS Alias with ojdbc 12.1

I am delevoping a java application that needs to access an Oracle Database. So far I have used the ojdbc6 driver without any problems. Now we are switching the databases to Oracle 12c so I wanted to use the newer JDBC driver. This is the code public…
3
votes
1 answer

Oracle UCP high CPU usage on Java 1.7 + TC Server

Some time ago we've moved one of our web apps from Resin and Java 6 to VMware vFabric tc Server and Java 7. This also included moving all JNDI datasources from Resin implementation to Oracle UCP. I've noticed that my CPU usage is extremely high,…
madhead
  • 31,729
  • 16
  • 153
  • 201
1
2 3 4 5 6 7