Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

addBatch() for a PreparedStatement

 
Tracey Currier
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
my driver supports batch updates(Sybase jconnect),
I can execute the update with one row inserting
but not multiple rows,
the batching is not working,
does anyone know why?
Thanks
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Tracey Currier:
my driver supports batch updates(Sybase jconnect),
I can execute the update with one row inserting
but not multiple rows,
the batching is not working,
does anyone know why?
Thanks

a small code snippet would help us give you more accurate advice. I've not had any problems with jconnect yet.
Jamie
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
however, my guess is that you do are doing something like the following:

OR

Jamie
[ October 10, 2003: Message edited by: Jamie Robertson ]
 
Tracey Currier
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply, I did make that error you suggested, but
I had corrected with still no pos results.
I found the error, at least to some extent.
I can add 10 lines of my prepared statement w/o problems,
but when I try 50, I run into problems.
Due to time issues, we decided to print tab delimited data files
and "bcp" them to the db.
I am looking forward to reading the book, got lucky, can use the info
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic