OraFAQ Forum: JDeveloper, Java & XML » Statements fail after reusing with addBatch

Home » Developer & Programmer » JDeveloper, Java & XML » Statements fail after reusing with addBatch

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 19 11:43:53 CDT 2026