File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Developer Certification (SCJD/OCMJD) and the fly likes Data file Format question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Certification » Developer Certification (SCJD/OCMJD)
Bookmark "Data file Format question" Watch "Data file Format question" New topic

Data file Format question

Matt Pavlovich
Ranch Hand

Joined: Aug 14, 2010
Posts: 98
Hello everyone...

I am reading the directions for my test, and have encountered some areas that are not clear. There are some periods missing as well which does not help. In the directions it states:

The format of data in the database file is as follows:
Start of file 4 byte numeric, magic cookie value. Identifies this as a data file 4 byte numeric, total overall length in bytes of each record 2 byte numeric, number of fields in each record

Schema description section. Repeated for each field in a record: 2 byte numeric, length in bytes of field name n bytes (defined by previous entry), field name 2 byte numeric, field length in bytes end of repeating block

Data section. Repeat to end of file: 1 byte "deleted" flag. 0 implies valid record, 1 implies deleted record Record containing fields in order specified in schema section, no separators between fields, each field fixed length at maximum specified in schema information
End of file

All numeric values (that?) are stored in the header information use the formats of the DataInputStream and DataOutputStream classes. All text values, and all fields (which are text only), contain only 8 bit characters, null terminated if less than the maximum length for the field. The character encoding is 8 bit US ASCII.

Can anyone perhaps translate this? Better yet, maybe a picture example? Sorry for my incredible green-ness in this matter, but this bit of the instructions are really, really unclear to me. I understand they are trying to tell me how the data is formatted in the file, but after that I am lost.

As always, many thanks.

Rahim Nathwani

Joined: Sep 19, 2005
Posts: 19
Take a look at the FAQ - There is an app that you can run on your DB file. This will help break down the requirements
Roel De Nijs

Joined: Jul 19, 2004
Posts: 8395

Indeed, Roberto's Database File Reader will be a great help (link can be found in ScjdFaq).

To understand how data is stored in the database file, I wrote myself a little program which just prints all contents from the file in a readable format. To give you a start: the first value is the magic cookie value, it's 4 byte numeric. So this will print your magic cookie:

Good luck!

SCJA, SCJP (1.4 | 5.0 | 6.0), SCJD
Roberto Perillo

Joined: Dec 28, 2007
Posts: 2271

There you go: here!

Cheers, Bob "John Lennon" Perillo
SCJP, SCWCD, SCJD, SCBCD - Daileon: A Tool for Enabling Domain Annotations
Matt Pavlovich
Ranch Hand

Joined: Aug 14, 2010
Posts: 98
Brilliant! Thanks very much, everyone - and especially to Roberto for making this program.
I agree. Here's the link:
subject: Data file Format question
It's not a secret anymore!