Uhh, my bad at pasting. That should be CUSTOMER_ID in the table below
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Poole Sent: Friday, March 07, 2008 4:31 PM To: Sequoia general mailing list Subject: [Sequoia] SQL Query 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
