| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC driver gives error with batched insert
I found the error for those interested. The code had been converted from
using the single transaction method and I had managed to leave a
clearStatement() method call in the code, so it was clearing out the values
each call.
"David" <david.wynter_at_btclick.com> wrote in message
news:TJqZ7.72808$Q66.265878_at_NewsReader...
> I am using classes12.zip connected to 8.15i on W2K under the JRE 1.3.1.
>
> I had code that worked with a executeUpdate call and a following commit,
it
> still works now that I have setup using the
> ((OraclePreparedStatement)ps).sendBatch(); and the
> ((OracleConnection)conn).setDefaultExecuteBatch (1); at the appropriate
> spots as outlined in the Oracle documentation, but only where it is set to
> the default of 1.
>
> If I set it to a higher value then it fails everytime with an 17440
error -
> "DBItem/DBType is null". I have traced through the execution and all seems
> fine with the values and data types in the statement each time the
> ps.executeUpdate() occurs.
>
> Any ideas or experience with this problem?
>
> Thanks,
>
> David
>
>
>
>
>
Received on Sat Jan 05 2002 - 04:48:32 CST
![]() |
![]() |