Results 1 to 2 of 2
  1. #1
    Vedamurthy is offline Member
    Join Date
    Aug 2013
    Posts
    1
    Rep Power
    0

    Default Problems in finding best suitable jdbc driver

    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.

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    19

    Default Re: Problems in finding best suitable jdbc driver

    I'm pretty sure that batching CallableStatements that have OUT/INOUT is not allowed under JDBC.
    It's quite possible SQL Server has fixed this loophole?

    From here.
    "
    The SQL Server JDBC Driver 3.0 is compliant with the JDBC 4.0 recommendation that a call to the CallableStatement.executeBatch method (inherited from PreparedStatement) will throw a BatchUpdateException if the stored procedure accepts OUT or INOUT parameters or returns something other than an update count.
    "
    You could therefore try a lower driver than sqljdbc4 (which is the 4.0 version?)?
    Please do not ask for code as refusal often offends.

Similar Threads

  1. Replies: 5
    Last Post: 07-24-2013, 03:19 PM
  2. Replies: 5
    Last Post: 03-13-2012, 01:51 PM
  3. Replies: 0
    Last Post: 03-03-2012, 01:01 AM
  4. No suitable driver found
    By chinna in forum New To Java
    Replies: 3
    Last Post: 11-30-2011, 01:17 PM
  5. Problem finding SQLite JDBC driver
    By PrinceSendai in forum JDBC
    Replies: 9
    Last Post: 08-09-2010, 01:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •