Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC & MS SQL : ps.executeBatch() function problem

 
Kalpesh Gupta
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello
When i run the ps.executeBatch() function against MSSql server
I get a following error :
Kindly help me out at the earliest.
com.microsoft.jdbc.base.BaseBatchUpdateException: [Microsoft][SQLServer JDBC Driver]Invalid parameter binding(s).
at com.microsoft.jdbc.base.BasePreparedStatement.executeBatchEmulation(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
I tried to search for it on the internet but didn't get any help.
Thanks for help in advance
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
make sure you are setting all your ? properly and that they correspond/map correctly with the database datatype.
Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic