aspose file tools*
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
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: 3610
    
  60

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

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

Joined: Aug 22, 2010
Posts: 3610
    
  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: 38859
    
  23
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: 3610
    
  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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: callableStatement.registerOutParameter in batch