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

Problems in finding best suitable jdbc driver

 
Vedamurthy Prasanna
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

We have recently planned to migrate from 2005 to 2008, on doing the same on test environment everything seems to be working fine except on some scenarios where batch execution was used with registerOutParameter it started giving "java.sql.BatchUpdateException: The OUT and INOUT parameters are not permitted in a batch ". We have upgraded the jdbc driver with the latest sqljdbc4 & also used jTDS drivers still didn't work.


Please anyone suggest me to resolve this issue.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's not all that surprising that batch execution doesn't support OUT parameters. I have no idea how that worked in the previous version, since JDBC never supported it. Perhaps you're using the IN OUT parameters instead of IN ones? If this is the case, replacing IN OUT parameters with IN ones might work. If you are simply ignoring the return values of OUT parameters, perhaps it won't be possible with the 2008 version at all and you'll have to do some refactoring.

If you're actually using return values of the OUT parameters in the batch execution mode, I'd say your 2005 version had a bug that was not spotted, and was uncovered by switching to 2008 version. It is obviously not possible to read values of OUT parameters before the relevant statements were executed.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic