wood burning stoves 2.0*
The moose likes Developer Certification (SCJD/OCMJD) and the fly likes URLyBird's [Version 1.2.3] : create/update/delete 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 » Certification » Developer Certification (SCJD/OCMJD)
Bookmark "URLyBird Watch "URLyBird New topic
Author

URLyBird's [Version 1.2.3] : create/update/delete

Payal Shah
Ranch Hand

Joined: Jul 10, 2006
Posts: 67
One more question on Create and delete method.


For my create method..
- I am not looping through my current records to find delete records, to insert this new record. I just create a new record.
- I also assume that data [input] array for createRecord and updateRecord method does not contain delete flag..when I create record, i add delete flag = 00.and for update method, i just leave delete field alone.

specs says..
// Creates a new record in the database (possibly reusing a
// deleted entry). Inserts the given data, and returns the record
// number of the new record.
public long createRecord(String [] data)
throws DuplicateKeyException;

it says "possibly reusing "..am I gona loose points if i do not reuse the delete field. I did not reuse the delete record b/c what if in the future
they want reuse that record..??

Now delete specs says reuse..I do not see "possibly reusing ".. // Deletes a record, making the record number and associated disk
// storage available for reuse.
// Throws SecurityException if the record is locked with a cookie
// other than lockCookie.
public void deleteRecord(long recNo, long lockCookie)
throws RecordNotFoundException, SecurityException;

Thank you..
christian combarel
Ranch Hand

Joined: Aug 04, 2007
Posts: 47
Hi Payal,
Don't worry about reusing a deleted record. It's not a requirement, just a hint.
For the delete method, it is just said that the record is now available and not it must be used for a new record. It's my interpretation ...
However, implementing that functionality could improve your score (may be !).
Anyway, explain your choice in your choices.txt



-------------
Chris
K. Tsang
Bartender

Joined: Sep 13, 2007
Posts: 2247
    
    7

Also depends on what you do in your delete method. You can simply mark the delete flag to 1 and leave the data intact, or change delete flag and write a empty array to make the row empty. Also you will need to take into consideration of these deleted rows when calculating the number of records. If delete flag=1, is it a record or not?


K. Tsang JavaRanch SCJP5 SCJD/OCM-JD OCPJP7 OCPWCD5
Payal Shah
Ranch Hand

Joined: Jul 10, 2006
Posts: 67
Thank you.
 
Consider Paul's rocket mass heater.
 
subject: URLyBird's [Version 1.2.3] : create/update/delete
 
Similar Threads
Deleted Items
NX: URLyBird questions about database
Implement Data Access Layer
Lock question!
NX (Bodgitt and Scarper, LLC): recNo primitive long on DBAccess Interface methods