No in fact the only thing you have is something called a record store that is only able to record byte array. To be more precise I will need to serialize the Column, Table, etc classes to byte arrays and then record them into this record store (that is inside your device).

My question was: Is there any way to get a textual representation of all the tables and columns and views in the J2SE version, i.e. is their a file created on disk where you store all the tables when you do a commit. And is there and export command that trigger this action.

Second point was: Is it a better idea to have the persistent class implementing an interfage and take care of themself to backup or is it better to have a new package that takes as an input a table an that returns a byte array representing the table?

I hope that it's now clear where I want to go.

CU Jerome

fredt wrote:
Well done!

What do you mean by this question? If there is no file system, where do you intend to save the tables and views?

Do you mean you want to create a database outside the J2ME environment that contains the tables and data, then read it inside the J2ME environment?

Perhaps you should look at the files_readonly property that allows you to package a database in a jar.

Fred

----- Original Message ----- From: "Jérôme Paschoud" <[EMAIL PROTECTED]>
To: <hsqldb-developers@lists.sourceforge.net>
Sent: 13 October 2005 14:29
Subject: [Hsqldb-developers] Persistant storage


Now that I have a micro (in fact even a nano) version of HSQLDB (around
150 Ko) that runs well on J2ME/CLDC. I'm trying to implement  the
persistent storage for this version. As their is no file system on such
device, I will not have a complicate save and restore mecanism. I will
simply save all tables and views on shutdown and restore them on startup.

Could someone tell me if their exists an export like command to (guess
what) export the whole database to a file in the J2ME version.

What do you think would be the best way to achieve save and restore
mecanism:

- All classes needing backup implements an serialize like interface
- A whole new package has the mission to serilialize and save/restore
each permanent class

CU Jérôme



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers

Reply via email to