wood burning stoves 2.0*
The moose likes JDBC and the fly likes callableStatement.registerOutParameter in batch Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "callableStatement.registerOutParameter in batch" Watch "callableStatement.registerOutParameter in batch" New topic
Author

callableStatement.registerOutParameter in batch

mohan govind
Greenhorn

Joined: Aug 24, 2010
Posts: 2
Hi All,

I believe callableStatement.registerOutParameter is not supported in batch (callableStatement.addBatch()). Is this information mentioned in any spec/article and is there any other alternative for this?

Thanks in advance!
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

See chapter 6.1.3 in this specification I managed to google up.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38020
    
  22
Is there anything more recent? That is Java1.3, which was superseded nearly ten years ago.
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

I've found the same description in the JDBC 4.0 specification. It's a PDF document, so I cannot provide direct link. You can download the document here (I've downloaded the first version, intended for JDBC users, not implementors of JDBC standard). See section 14.1.5 thereof.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38020
    
  22
JDBC 4.0 would appear to be the most up to date version. Try here to download it.
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

Campbell Ritchie wrote:JDBC 4.0 would appear to be the most up to date version. Try here to download it.

Yes, that specification contains practically identical information, as I've reposted here a few hours ago.

Anyway, thanks for pointing out that my first link was outdated. I actually didn't realize it, I need to get used to pay closer attentions to version differences
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: callableStatement.registerOutParameter in batch
 
Similar Threads
Using CallableStatement to access an Oracle Proc
Calling a stored procedure for MSSQL 2000?
callablestatement
wrong number or types of arguments in call to 'P_RETRIEVE_OPPTY_ORDER_STATUS'
5 letter scrabble