Ahh, Good thing you brought that up.
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
