Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC driver gives error with batched insert

Re: JDBC driver gives error with batched insert

From: David <david.wynter_at_btclick.com>
Date: Sat, 5 Jan 2002 10:48:32 -0000
Message-ID: <_SAZ7.507$ru2.3027@NewsReader>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US