Re: Batch insert discrepancies in database

Well, something is different. I honestly have no idea what you should be considering, but now comes the point when you need to treat this in a logical manner.
What I'd suggest first is to set up a clean test environment, as close as possible to how you believe the current state is on both environments. How does that behave? Next I'd look at tracing, how is the decision to perform batch or not instrumented (either or both on JDBC side on Database). Knowing Oracle this decision should be instrumented somewhere, although finding out how might be a little challenging. Patrick

On Tue, Dec 10, 2024 at 4:23 AM yudhi s <dmarc-noreply_at_freelists.org> wrote:

> Hello Listers,
>
> I see one of the past discussions here below about the reason behind why
> the batch insert is not working suddenly(mainly from Oracle 12C).
>
>
> https://www.freelists.org/post/oracle-l/Batch-inserts-changed-to-row-by-row,2
>
>
> https://docs.oracle.com/en/database/oracle/oracle-database/19/jjdbc/release-changes.html#GUID-9FF337B3-CC0D-40FF-A5C5-EFB998D0BC16
>
> We are seeing a similar issue in one of our applications, but here in our
> case, we see batch insert is happening fine in one database(say DB1) but
> not getting reproduced in another database(say DB2). All the database
> parameters are the same in both the databases and we have Oracle 19C in
> both of the databases and also the driver is OJDBC-6 and the application
> code is exactly the same in both environments. So what else should we
> compare between these two environments, to understand the reason behind
> this discrepancies in the behaviour between these two environments?
>
> Regards
> Yudhi
>

--
http://www.freelists.org/webpage/oracle-l