Home » Developer & Programmer » JDeveloper, Java & XML » Statements fail after reusing with addBatch
Statements fail after reusing with addBatch [message #139999] Fri, 30 September 2005 08:04
exal
Messages: 1
Registered: September 2005
Junior Member
Hi

We are trying to reuse a statement used as prepareStatement (we have tried casting to oracle)

We add the statement to addBatch and then reuse to make another insert. When we have an insert with a clob field and try to insert an empty string '' it will fail in the execute after a random number of rows.

Can anyone tell us how to resolve this issue?

Pseuso code

While (Hashmap not empty and less than 10000 rows fetched)
{
Statement s = prepareStatement()
s.addBatch
}
s.executeBatch

Thanks
Joachim

Report message to a moderator

Previous Topic: Built-in Alert in 6i
Next Topic: ORDDoc Using JSP
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 27 15:05:10 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.