Stack Overflow
Stack Overflow

Questions tagged [ora-01000]

An ORA-01000 error is displayed when the maximum number of cursors is exceeded.

15 questions
5
votes
2 answers

Spring 5.0.1 namedJdbcTemplate batchUpdate ORA-01000: maximum open cursors exceeded

I have recently upgraded my project from Spring Framework 4.3.10 to 5.0.1. After the upgrade the namedParameterJdbcTemplate.batchUpdate started to fail with this error ORA-01000: maximum open cursors exceeded. The batch updates 250 records a time…
Adam Sojka
  • 331
  • 2
  • 9
5
votes
2 answers

Tridion CMS & Oracle: ORA-01000: maximum open cursors exceeded

hopefully someone can help me here. We use Tridon CMS to manage a website hosted on jBoss and Apache. We've been using SDL Tridion 5.3 for 5 years now and suddenly we have encountered an error with the Oracle database behind it. Most of our content…
ThatITBloke
  • 191
  • 4
3
votes
1 answer

Spring-jdbc 5.0.5 NamedParameterJdbcTemplate.batchUpdate ORA-01000

After migrating from Spring 4.1.7 to Spring 5.0.5 we have ORA-01000: maximum open cursors exceeded when using with Oracle 12c and ojdbc7 driver Exception raised after following code @SuppressWarnings("unchecked") private void…
yanefedor
  • 2,132
  • 1
  • 21
  • 37
3
votes
1 answer

ORA-01000: maximum open cursors exceeded for batch update PreparedStatement

I was using batch update prepared statement over millions of record but eventually encountered the following error in runtime after execution of >400k of records. java.sql.SQLException: ORA-01000: maximum open cursors exceeded I don't know if this…
Tsubasa
  • 137
  • 4
  • 9
2
votes
0 answers

Maximum open cursors exceeded in Node.js

I'm working on some code to process a csv in Node.js and store it in an Oracle database. So far, things are going well, but with large amounts of rows in the csv, I get "ORA-01000: maximum open cursors exceeded." I am connecting to Oracle once at…
Bri Veillette
  • 323
  • 1
  • 3
  • 11
2
votes
3 answers

ORA-01000: maximum open cursors exceeded - java code fails

I use loops in my java code to insert rows into my database. Then, I got the error - ORA-01000: maximum open cursors exceeded I searched a little and saw that closing my prepared statements or statements after adding each row helps to get rid of…
bread butter
  • 617
  • 3
  • 10
  • 18
1
vote
1 answer

Debugging ORA-01000

I'm altering a legacy Spring application to make use of dynamically configured connection pools. All queries in the entire system are using JdbcTemplate, or else are connecting through Jms to Oracle AQ -- I have checked and every single time a…
billmill
  • 331
  • 1
  • 3
  • 14
1
vote
0 answers

Implicit ref-cursors not being closed in ODP.net 12c release 2

I'm porting a .net application from SqlServer to Oracle 12c. I'm using the unmanaged 64-bit ODAC 12c Release 2 (12.1.0.1.2) client to access the database. Oracle 12c introduced the DBMS_SQL.RETURN_RESULT(cur) function that allows me to reuse the…
Marco Zecca
  • 57
  • 5
0
votes
1 answer

MuleSoft 4: ORA-01000: maximum open cursors exceeded

Getting an error ORA-01000: maximum open cursors exceeded after processing few records from file inside try-catch scope. I've 3 select statements and 5 stored procedure calls(have insert statement inside stored procedure) in side try-catch…
Kiran
  • 29
  • 1
  • 8
0
votes
1 answer

Unable to understand the SQL Exception- Ora Err Code :ORA-01000:

I have a Java Class that's calling an SQL procedure to perform some DB operations. Here's my Java method: public static void buildContent(String id) throws Exception{ Connection conn = ExtractDB.getConnection(); CallableStatement cs =…
Richa Sharma
  • 75
  • 1
  • 9
0
votes
2 answers

This topic ASP.Net mvc is struggeling me

I am trying to run my ASP.NET MVC application but it is not running would you be kind to let me understand what I did wrong, thanks. Model namespace Mytest.Models { public class ProductsListViewMode { public IEnumerable…
journa
  • 1
0
votes
0 answers

Oracle does not close the cursors opened by JPA query even after EntityManager.close() is called

I am using JPA, hibernate and Oracle DB. While calling method findAll(..) multiple times (say 1000), each time Oracle opens a new cursor. The opened cursor is not closed after entity manager transaction is committed or entityManager is closed…
user2128672
  • 191
  • 1
  • 5
0
votes
1 answer

Connection pool and ORA-01000

I created an asynchronous ExecuteQuery function that is able to execute query asynchronously so that if ever it's called inside a loop, the next query waits for the former one to finish before being executed. The doCreatePool function is called…
BlackMatrix
  • 43
  • 1
  • 5
0
votes
0 answers

node oracledb [Error: ORA-01000: maximum open cursors exceeded]

I'm facing an error on executing a select query in a loop. I got this error : [Error: ORA-01000: maximum open cursors exceeded] This is the query that is executed : Oracle_POOL.getConnection( function(err, connection) { if (err){ …
BlackMatrix
  • 43
  • 1
  • 5
0
votes
1 answer

Unable to resolve error - java.sql.SQLException: ORA-01000: maximum open cursors exceeded

I made a java method to add a row to a database. I am calling this method about 1000 plus times for testing purposes. I called the close() method on my prepared statement and i am still getting the oracle error whenever this method is called to…
bread butter
  • 617
  • 3
  • 10
  • 18