You can stream the definitions and the data into a couple of byte arrays. Instead of serializing the classes, you modify the org.hsqldb.persist classes to read and write from byte arrays instead of files.
It should be pretty straitforward to do this. The textual representation of all the tables etc, is provided by the org.hsqldb.DatabaseScript class. Fred ----- Original Message ----- From: "Jérôme Paschoud" <[EMAIL PROTECTED]> To: <hsqldb-developers@lists.sourceforge.net> Sent: 13 October 2005 16:27 Subject: Re: [Hsqldb-developers] Persistant storage 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 ------------------------------------------------------- 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
