[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
[dali-dev] case of table and column names
|
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
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.
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
