You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Brenda Reyes <br...@yahoo.com> on 2005/03/24 20:34:51 UTC

[doc] updatable ResultSets

Hello all, 

Since Derby now supports updatable ResultSets, I
updated the DITA docs accordingly.  However, I added
them to the files and sent them to Jeff before he
contributed them. So the changes are ALREADY
committed.  So I suggest people check my changes to
make sure they are OK.  

This web page gives the command for checking the dita
files out of the derby subversion repository: 

   
http://incubator.apache.org/derby/manuals/dita.html

The files I mention below are all located under
derby/docs/trunk/src . 

Or you can easily view these files using the ViewCVS
web interface:

  
https://svn.apache.org/viewcvs.cgi/incubator/derby/docs/trunk/src/

Here are the files I have updated: 

Derby Reference Manual 

ref/rrefjdbc77156.dita 

In the java.sql.ResultSet section, under "JDBC 2.0
ResultSet Methods Supported" I made the following
changes: 

 - added info. for updatable ResultSets to
getConcurrency() function 
 - added deleteRow() function to the table 
 - added information about updatable ResultSets and
the auto-commit feature to the Note at the end of the
document. 
 - emphasized that insertRow() and updateRow()
functions are not supported for updatable ResultSets. 
 

ref/rrefjdbc80004.dita 

In the java.sql.Connection section, under "JDBC 3.0
Connection Methods Supported" I made the following
changes: 

 -changed Implementation Notes for the
createStatement(), prepareStatement(), and  
prepareCall() functions.  These now include info about
updatable ResultSets. 

ref/rrefsqlj41360.dita 

In the SELECT statement section, under "Requirements
for updatable cursors", I edited the section (and
changed its title to "Requirements for updatable
cursors and updatable ResultSets") to reflect the new
support for updatable ResultSets. 

I emphasized that the SELECT sql statement has to have
a FOR UPDATE in order to get an updatable resultset. 

Derby Developer's Guide 

devguide/cdevconcepts23987.dita 

In the Controlling Cloudscape Application Behavior
section, under "ResultSets and auto-commit" I added
info. about using auto-commit with updatable
ResultSets. 

devguide/devconcepts29416.dita 

In the Using auto-commit, under "Table: Summary of
Application Behavior with Auto-commit On or off" I
added info. on updatable ResultSets to the table. 


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

Re: [doc] updatable ResultSets

Posted by Mamta Satoor <ms...@gmail.com>.
> ref/rrefjdbc77156.dita
> 
> In the java.sql.ResultSet section, under "JDBC 2.0
> ResultSet Methods Supported" I made the following
> changes:
> 
> - added info. for updatable ResultSets to
> getConcurrency() function
> - added deleteRow() function to the table
> - added information about updatable ResultSets and
> the auto-commit feature to the Note at the end of the
> document.
> - emphasized that insertRow() and updateRow()
> functions are not supported for updatable ResultSets.
> 


Hi Brenda,

Thanks for taking the time to work on the documentation. 

Derby now does support updateRow() and so ref/rrefjdbc77156.dita needs
to be modified to reflect so. Also, if there is any other place in the
documentation, where we mention that the support is only for deleteRow
will need to changed too.

thanks again,
Mamta