I recently got Sequoia for my project at work and have a problem that I can't seem to figure out.
In my Java code, the queries to my database use schema name as part of the table name. In other words, if my database had a schema named "SCHEMA" and a table named "TABLE", I might have a query such as: SELECT * FROM SCHEMA.TABLE; This works with my existing JDBC driver. When using Sequoia I get the following error: Error during command execution (Unknown table 'SCHEMA.TABLE' in this SELECT statement: 'SELECT * FROM SCHEMA.TABLE'). If I try to use "SELECT * FROM TABLE;" that works, but if I happen to have more than one schema (which happens during testing) I can't ensure which TABLE is being queried. I am using a Derby database. In my experience, I have always been able to attach the schema name to the table name for queries, and I thought this was standard SQL. Any idea why this won't work with Sequoia? I can remove the schema part from the name, but would prefer to leave it as it is used to ensure the query comes from the right table. Any help would be greatly appreciated. Jonathan Stockho Software Developer Swisslog Healthcare Solutions 10825 E. 47th Avenue Denver, CO 80239 Phone: 303-373-7814 FAX: 303-373-7872 e-mail: [EMAIL PROTECTED] Internet: www.swisslog.com ------------------------------------------------------------------------ ------------ About Swisslog Swisslog designs solutions in logistics automation that greatly reduce the manual flow of materials and associated information within healthcare facilities. This message may contain legally privileged or confidential information and is therefore addressed to the named persons only. The recipient should inform the sender and delete this message, if he/she is not named as addressee. The sender disclaims any and all liability for the integrity and punctuality of this message. The sender has activated an automatic virus scanning, but does not guarantee the virus free transmission of this message.
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
