Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Message-Id: <C06610F1-236F-40D5-B94C-2F81F1E62857@objectstyle.org>
From: Andrus Adamchik <andrus@objectstyle.org>
To: user@cayenne.apache.org
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v930.3)
Subject: Cayenne support for quoting of identifiers
Date: Sat, 21 Feb 2009 10:31:18 -0500
Cc: dev@cayenne.apache.org

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/lastBuild/

Andrus