There we go. I found what I was looking for (example "Create table" statements) in the DTD:
http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd =) Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Jordan Michaels wrote: > Hey Robert, > > Hmm... That XML file looks almost exactly like the one I've been looking > at. I guess I'm just confused as to how the XML file explains what > fields I need to create in order to build proper recovery tables. > > So no one has any working examples of tables that they're using? I'm > just looking for example structures to point me in the right direction. > > Thanks in advance! > > Warm regards, > Jordan Michaels > Vivio Technologies > http://www.viviotech.net/ > BlueDragon Alliance Member > [EMAIL PROTECTED] > > > Robert Hodges wrote: >> Hi Jordan, >> >> Look in the example XML files under doc/example, such >> as RAIDb1-postgresl-cluster.xml. They show the tags to define recovery >> log tables. >> >> Thanks, Robert >> >> Robert Hodges, CTO, Continuent, Inc. >> Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> Mobile: +1-510-501-3728 Skype: hodgesrm >> >> >> On Oct 1, 2007, at 3:32 PM, Jordan Michaels wrote: >> >>> Hey all, >>> >>> I'm in the process of setting up a proof-of-concept cluster using >>> Sequoia. If I can get it up and working, I will be demonstrating it to a >>> board of directors in the next couple weeks who are pretty anxious to >>> see a functional example. >>> >>> Right now, I'm at the part where you set up the recovery tables in your >>> recovery database, but I'm concerned that I'm not seeing all the columns >>> that I will be needing in my databases. I'm looking at this page: >>> >>> http://sequoia.continuent.org/doc/infocenter/topic/org.continuent.sequoia.doc/html/Write_the_RequestManager_element_definition.html >>> >>> And it implicitly gives SQL code on how to set up the first table, but >>> there are three more that it doesn't give example SQL code for. I could >>> attempt to guess at the table structure based on the parameters of the >>> example XML virtual database config file, but I noticed that the example >>> recovery log table does have an actual table row that is not specified >>> in the attributes of the XML file (the "sqlColumnName_param" column - >>> it's not mentioned in the "hsqldb-raidb1-distribution-1.xml" file). >>> >>> Would someone be willing to share the SQL table structure code for these >>> other 3 tables they have set up and working? If someone wouldn't mind >>> posting that, I would be very appreciative. >>> >>> Thanks in advance! >>> -- >>> Warm regards, >>> Jordan Michaels >>> Vivio Technologies >>> http://www.viviotech.net/ >>> BlueDragon Alliance Member >>> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >>> _______________________________________________ >>> Sequoia mailing list >>> [email protected] >>> <mailto:[email protected]> >>> https://forge.continuent.org/mailman/listinfo/sequoia >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Sequoia mailing list >> [email protected] >> https://forge.continuent.org/mailman/listinfo/sequoia > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia > > _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
