Excellent! I will run our models through it. Thank you for all the hard work on this one.
Zissis Trabaris * Chief Technology Officer * INSYSWARE * 3235 West River Road, Grand Island, New York, 14072, USA Mobile (716) 930-5654 * Office (518) 636-4118 * Fax (716) 625-1305 * [email protected] * www.insysware.com CONFIDENTIALITY: This email (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this email in error, please notify the sender and delete this email from your system. Thank you. -----Original Message----- From: Andrus Adamchik [mailto:[email protected]] Sent: Saturday, February 21, 2009 10:31 AM To: [email protected] Cc: [email protected] Subject: Cayenne support for quoting of identifiers Folks, sorry for cross-post, but I figured this feature is critical to many people, and warrants an early announcement. We finally did it - Cayenne now supports optional db-specific quoting of identifiers in the generated SQL (including queries, updates and all DDL). Now you can use spaces and other special chars in the table and column names (not that this is a good idea, but sometimes you have no choice). Turning on quoting is done per DataMap in the Modeler. Current behavior is backwards compatible - no quoting is a default. This works on MySQL, PostgreSQL, HSQLDB and a few other DBs. Oracle, Sybase, SQLServer testing will be performed in a couple of weeks. This feature will go in 3.0M6, but if you want to try it right away, you can build Cayenne from trunk or grab a build from Hudson (rev >= 746523, should become available in a couple of hours) : http://hudson.zones.apache.org/hudson/view/Cayenne/job/Cayenne-trunk/las tBuild/ Andrus
