Thanks Emmanuel, I'll double check that the application in question does not do those types of transactions (as they shouldn't be).
As a side question to wrap my head around configuration files, and controllers... Can I define in one controller configuration file, 3 different virtual databases and their backends w/recovery logs? Or can someone suggest perhaps a better way than I have right now. Currently I have 4 databases, (mysql, foobar1, foobar2, foobar3) and 4 controllers. I'd like to have one controller (eventually 2 on different hosts), talking to all of the backends, recovery tables, etc. Furthermore can I define all virtualdatbases within one configuration file? So when I load virtualdatabase configuration /path/to/vdb.xml the command show virtualdatabases will list all databases in question? Regards, Jonathan D. Poole -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Cecchet Sent: Monday, March 10, 2008 10:11 AM To: Sequoia general mailing list Subject: Re: [Sequoia] SQL Query Hi Jonathan, I am not sure I completely got your use case but if you are trying to create a single database db1 and execute things like 'INSERT INTO db2.table VALUES ...' through db1, Sequoia will not be able to find out the db2 tables. With JDBC, you can only fetch tables from the database you are connected to (not the entire RDBMS schema). So Sequoia will not be able to perform the proper locking and ensure consistency on db2 tables in that case. Hope this helps, Emmanuel > I have been using limited resources, so I've had to create a > controller with a virtual database writing to the same sql database > with databases db1_databasename, db2_databasename. If this is the case > I assume I can just take out the second database out of my virtual > database configuration file and have the same database name as my > virtual database name and things should work like a charm? Will I > loose all raidb1 functionality? I'll find another server to have true, > two databases working with sequoia in a proper setup. But as I said, > resources right now are slim. > > ------------------------------------------------------------------------ > > *From:* [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] *On Behalf Of > *Robert Hodges > *Sent:* Friday, March 07, 2008 4:45 PM > *To:* Sequoia general mailing list > *Subject:* Re: [Sequoia] SQL Query > > Hi Jonathan, > > No apology necessary. Is the vdb name the same as your database name? > If you match them I think it should work. > > Thanks, Robert > > > On 3/7/08 1:31 PM, "Jonathan Poole" <[EMAIL PROTECTED]> wrote: > > Hello All, > > I really apologize fro the noise I cause on this list, but anyhow I'm > running into the following now. > > Issuing the following commands via the sql client performs some > behavior that I'm wondering if there is a workaround for or if queries > will have be specially constructed to work with sequoia (My hope is > that it's completely transparent) > > jdbc:sequoia://192.168.61.14:25324/virtualdb (user) > select > CUSTOMER_ID from CUSTOMERS; > +------------+ > | LICENSE_ID | > +------------+ > | 1 | > | 2 | > | 3 | > | 5 | > +------------+ > > Query executed in 0 s 1 ms . > > This is great, however when some queries are constructed with > databasename.customers such as > > > jdbc:sequoia://192.168.61.14:25324/virtualdb (user) > select > CUSTOMER_ID from virtualdb.CUSTOMERS; > An error occured while executing SQL query > (org.continuent.sequoia.common.exceptions.driver.DriverSQLException: > Message of cause: Request select CUSTOMER_ID from virtualdb.cust_... > failed on backend DB1 (Table 'virtualdb.CUSTOMERS' doesn't exist)) > jdbc:sequoia://192.168.61.14:25324/virtualdb (user) > > > Any help would be appreciated. > > Regards, > Jonathan D. Poole > > ------------------------------------------------------------------------ > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia > > > > -- > Robert Hodges, CTO, Continuent, Inc. > Email: [EMAIL PROTECTED] > Mobile: +1-510-501-3728 Skype: hodgesrm > _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
