Re: Why is columnNames in Connection.prepareStatement(sql, columnNames[]) automatically quoted

Hi Dave,

I am not sure. I checked other JDBC drivers. I guess I did not meet the
same problem due to the reason that other databases either use upper-case
letters by default or they do not even care about the columnNames
parameter. E.g.: MySQL JDBC driver simply does not care about that
parameter, it is the same as calling with the
*Statement.RETURN_GENERATED_KEYS* integer parameter.

I am not sure if this is documented in any JDBC documentation. I would
guess that if I want to use camel-case field names, I should quote the
column names by myself like in the SQL statement. E.g.:
Connection.executeUpdate("insert into \"myTable\"...", "\"myIdField\"");.

I am not sure that would be the right solution. If you do not want to
change this, I can understand as both can be an acceptable behavior. In
that case I will try asking the developers of the technology I use
(Querydsl) to handle this on their side.

Kind regards,
Balazs

On Fri, Jul 31, 2015 at 2:49 AM, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:

> Actually I think I understand your issue. How would you propose this would
> work for people who actually have mixed case column names ??
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
> On 30 July 2015 at 20:47, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>
>> Hi,
>>
>> Yes there is a chance to change the driver, but I need more info. What
>> do you mean they are automatically quoted ???
>>
>> Dave Cramer
>>
>> dave.cramer(at)credativ(dot)ca
>> http://www.credativ.ca
>>
>> On 30 July 2015 at 20:32, Balázs Zsoldos <balazs(dot)zsoldos(at)everit(dot)biz>
>> wrote:
>>
>>> Hi,
>>>
>>> I would like to write database independent SQL statements. Everything
>>> works well, until I call *Connection.prepareStatement(sql,
>>> columnNames[])*.
>>>
>>> In the SQL statement nothing is quoted and it works well. I am
>>> wondering, why the values in the columnNames are automatically quoted? Is
>>> it a bug or a feature?
>>>
>>> More info:
>>>
>>> I create the fields and tables in DDL without quoting them. Table and
>>> field names become upper or lower case based on the engine. E.g.: In case
>>> of Oracle, they will have upper-case names, in PostgreSQL they will have
>>> lower-case names.
>>>
>>> If I use Oracle, I must provide the *columnNames* parameter for the
>>> mentioned function with upper-case letters otherwise it does not work (I
>>> think that is a bug, too, but I guess it is harder to send a patch for
>>> Oracle than PostgreSQL :-) ). If I use any other database engines (Derby,
>>> SQLServer, Hsqldb) everything works well.
>>>
>>> If I use PostgreSQL, however, I must provide lower-case letters for the
>>> parameter as it is quoted inside. I do not think it should be quoted. If
>>> someone wants to quote those column names, it would be possible by
>>> providing the Strings with quotes like *Connection.prepareStatement(sql,
>>> "\"myCamelCaseColumnName\"");*
>>>
>>> Do you think there is any chance to change this in PostgreSQL JDBC
>>> driver or shall I write separate code for Postgres?
>>>
>>> Regards,
>>> *Balázs **Zsoldos*
>>>
>>>
>>
>