• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

addBatch() for a PreparedStatement

 
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
reply
    Bookmark Topic Watch Topic
  • New Topic