How to escape case sensitive identifiers? [DATAJDBC-334]

[spring-projects-issues]

Valeriia Hrankina opened DATAJDBC-334 and commented

I have a table and columns in postgresql that have uppercase letters in names. So the generated sql should be escaped with double quotes to work correctly. Currently the sql generated does not escape identifiers with double quotes. When I have tries adding double quotes to the Table & Column annotations like so '@Column(""Column"")'  the parameter in PreparedStatement is also escaped, which causes an error, e.g. 'INSERT INTO "Table" ("Column1", "Column2") VALUES (:"Column1", :"Column2")'

---

Affects: 1.0.5 (Lovelace SR5)

Issue Links:

• DATAJDBC-381 Using backticks in column names leads to failure during INSERT with MySQL

Referenced from: pull request #120

Backported to: 1.0.6 (Lovelace SR6)

[spring-projects-issues]

Jens Schauder commented

Good find! The way you describe is the way it is supposed to work.

parameter names should be stripped of all characters except upper and lower case ASCII characters, digits and underscore

[spring-projects-issues]

Bastian Wilhelm commented

What characters should the generator cutaway on start and end. Only the characters ", ', and `, or there are more characters from other sql dialects?

[spring-projects-issues]

Bastian Wilhelm commented

sorry ignore my comment

[spring-projects-issues]

Bastian Wilhelm commented

For information, I am working on this issue