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
