Re: [Hsqldb-developers] Persistant storage

[<jer...@ep...>]

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" <jer...@ep...>
> To: <hsq...@li...>
> 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
> hsq...@li...
> 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
> hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-developers