[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [dali-dev] case of table and column names
|
This is one of the extension point I mentioned at the 'dali
extension-point' talk a few months(?) back.
Being able to override the validation/treatment of column names. Besides
it being different on various db's
it is also possible that the underlying JPA provider has customization
hooks for handling column/table naming.
/max
Hi Dali-Dev Team,
in SAP JPA, we are facing an issue with the case of table and column
names
in conjunction with Dali, which I would like to hear your opinion on.
The issue is the following:
SAP JPA always generates SQL with delimited identifiers, e.g.
SELECT "E"."ID", "E"."NAME" FROM "EMPLOYEE" "E"
Therefore the case of table and column names is relevant for us.
Unfortunately, the JPA specification is not specific with respect to the
case of column and table names. We handle the case in SAP JPA as follows:
1) if a default rule applies: upper case
e.g.
@Basic
String name; -> "NAME"
2) if a table or column name is specified explicitly: mixed case
e.g.
@Column(name="theName")
String name; -> "theName"
Dali on the other hand, when applying default rules, seems to assume that
either the case does not matter or that it is preserved (mixed case).
To fix the issue, I could imagine to have a property either in our (SAP)
JPA
runtime (specified in persistence.xml), in the SAP JPA Platform or in
Dali
that would allow to align the differing behaviours.
I would be interested to know which assumptions Dali makes with respect
to
the case of table and column names. What if the names are specified
explicitly using annotations or XML? What if default rules apply?
Are the other JPA vendors on this loop facing a similar issue?
Best regards,
Adrian
Dr. Adrian Görler
SAP AG
Dietmar-Hopp-Alee 16, 69190 Walldorf Germany
www.sap.com <BLOCKED::http://www.sap.com/>
Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo
Apotheker (stellvertretender Sprecher/Deputy CEO), Werner Brandt, Claus
Heinrich, Gerhard Oswald, Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board:
Hasso Plattner
Registergericht/Commercial Register Mannheim No HRB 350269
Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich
erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine
Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte
benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen
Dank.
This e-mail may contain trade secrets or privileged, undisclosed, or
otherwise confidential information. If you have received this e-mail in
error, you are hereby notified that any review, copying, or distribution
of
it is strictly prohibited. Please inform us immediately and destroy the
original transmittal. Thank you for your cooperation.
--
--
Max Rydahl Andersen
callto://max.rydahl.andersen
Hibernate
max@xxxxxxxxxxxxx
http://hibernate.org
JBoss a division of Red Hat
max.andersen@xxxxxxxxx
