Skip to Content
0
Former Member
Apr 22, 2010 at 09:39 AM

PI JDBC receiver on Oracle

68 Views

Hi,

I'm getting one error on inserting records into Oracle DB. Error is:

Error while parsing or executing XML-SQL document: Error processing

> request in sax parser: Error during batched statement execution:

> java.sql.BatchUpdateException: ORA-01000: maximum open cursors exceeded

I marked Batch Mode because number of INSERTS into DB is huge and with batch processing I'm getting on performance.

So what to do to avoid this errors? Will "Disconnect from Database After Processing Each Message" help or can I somehow specify how many entries can be in on batch? Oracle DB is seted up for 5000 open cursors max which is sure far more than 50 what is default value....

kr

Mario