File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases 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 Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 3717
    
  61

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

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

Joined: Aug 22, 2010
Posts: 3717
    
  61

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: 43346
    
  32
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: 3717
    
  61

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
 
It's not a secret anymore!