Question: Is the problem that Sequoia is parsing the query and it doesn't recognize the syntax? Is there any way to ignore the SQL and pass it straight through to the native JDBC? I know that Sequoia parses queries to replace timestamp macros, but we don't need to use those. How much overhead is involved with that parsing? My manager seems to think it's inefficient, and I'd like to have something to go back to him with.
Thanks, Jon From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Stockho Sent: Friday, July 18, 2008 11:36 AM To: [email protected] Subject: [Sequoia] Question about unknown table error 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. 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
