Re: [BUGS] BUG #14467: Insertion Issue with Hibernate

Hi,

a) Select : Hibernate: select customer0_.CUST_ID as CUST1_0_0_,
customer0_.CUST_NAME as CUST2_0_0_, customer0_.DEVICENUMBER as
DEVICENU3_0_0_, customer0_.EMAIL as EMAIL0_0_, customer0_.dob as dob0_0_
from CUSTOMERS customer0_ where customer0_.CUST_ID=?

b) Update : Hibernate: update CUSTOMERS set CUST_NAME=?, DEVICENUMBER=?,
EMAIL=?, dob=? where CUST_ID=?

c) Delete : Hibernate: delete from CUSTOMERS where CUST_ID=?

Regards,
Rahul Kumar

-----Original Message-----
From: Johannes Lochmann [mailto:johannes.lochmann@topcontrol.it]
Sent: Friday, December 16, 2016 3:14 PM
To: Rahul Kumar; pgsql-bugs@postgresql.org
Subject: AW: [BUGS] BUG #14467: Insertion Issue with Hibernate

Hi,

could you post working queries as generated by hibernate (update, delete,
select...)

Best regards,

Johannes

-----Ursprüngliche Nachricht-----
Von: Rahul Kumar [mailto:rkumar@obopay.com]
Gesendet: Friday, 16 December, 2016 10:45 AM
An: Johannes Lochmann; pgsql-bugs@postgresql.org
Betreff: RE: [BUGS] BUG #14467: Insertion Issue with Hibernate

Hi,

Please find the required inputs below.

a)    Table creation Statement.

create table customers (

CUST_ID numeric(20,0) primary key,
CUST_NAME varchar(25),
DEVICENUMBER varchar(12),
EMAIL varchar(30),
DOB timestamp(6)
);


b)    Hibernate generated query.

Hibernate: insert into CUSTOMERS (CUST_ID, CUST_NAME, DEVICENUMBER, EMAIL,
dob) values (nextval ('seq_test'), ?, ?, ?, ?)


Regards,
Rahul Kumar

-----Original Message-----
From: Johannes Lochmann [mailto:johannes.lochmann@topcontrol.it]
Sent: Friday, December 16, 2016 2:57 PM
To: Rahul Kumar; pgsql-bugs@postgresql.org
Subject: AW: [BUGS] BUG #14467: Insertion Issue with Hibernate

Hi,

could you provide:

a) create table statement
b) the exact queries that hibernate generates?

Best regards,

Johannes

-----Ursprüngliche Nachricht-----
Von: Rahul Kumar [mailto:rkumar@obopay.com]
Gesendet: Friday, 16 December, 2016 10:09 AM
An: Johannes Lochmann; pgsql-bugs@postgresql.org
Betreff: RE: [BUGS] BUG #14467: Insertion Issue with Hibernate

Hi,

I checked. There are no such identifiers.
And this issue exists only for PRIMARY KEY column.

Regards,
Rahul Kumar

-----Original Message-----
From: Johannes Lochmann [mailto:johannes.lochmann@topcontrol.it]
Sent: Thursday, December 15, 2016 7:16 PM
To: rkumar@obopay.com; pgsql-bugs@postgresql.org
Subject: AW: [BUGS] BUG #14467: Insertion Issue with Hibernate

Hi,

could it be that you are using case sensitive identifiers by any chance?

https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

Best regards,

Johannes

----Ursprüngliche Nachricht-----
Von: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] Im Auftrag von rkumar@obopay.com
Gesendet: Thursday, 15 December, 2016 11:28 AM
An: pgsql-bugs@postgresql.org
Betreff: [BUGS] BUG #14467: Insertion Issue with Hibernate

The following bug has been logged on the website:

Bug reference:      14467
Logged by:          Rahul Kumar
Email address:      rkumar@obopay.com
PostgreSQL version: 9.3.11
Operating system:   Windows XP
Description:

I am using PostgreSQL with Hibernate.
In Hibernate Mapping file one table is configured which is present in the
Database. If the name of the Primary Key column is provided in CAPITAL
letters, then while insertion to that table causes issue.
like :
Caused by: org.postgresql.util.PSQLException: ERROR: column "CUST_ID" does
not exist

Other operations e.g. Retrieve, Update are working fine.



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes
to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

--

------------------------------

*Disclaimer : The information and any attachments contained in this message
may be privileged and confidential and protected from disclosure or
unauthorized use. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is prohibited. If you have received this
communication in error, please notify us immediately by replying to this
message and then delete it. All e-mail sent to this address will be received
by Obopay Mobile Technology India Pvt Ltd and may be archived or reviewed.
Obopay Mobile Technology India Pvt Ltd accepts no liability for any loss or
damage arising from this email, any virus transmitted, or its
attachments.*

--

------------------------------

*Disclaimer : The information and any attachments contained in this message
may be privileged and confidential and protected from disclosure or
unauthorized use. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is prohibited. If you have received this
communication in error, please notify us immediately by replying to this
message and then delete it. All e-mail sent to this address will be received
by Obopay Mobile Technology India Pvt Ltd and may be archived or reviewed.
Obopay Mobile Technology India Pvt Ltd accepts no liability for any loss or
damage arising from this email, any virus transmitted, or its
attachments.*

--

------------------------------

*Disclaimer : The information and any attachments contained in this message
may be privileged and confidential and protected from disclosure or
unauthorized use. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is prohibited. If you have received this
communication in error, please notify us immediately by replying to this
message and then delete it. All e-mail sent to this address will be
received by Obopay Mobile Technology India Pvt Ltd and may be archived or
reviewed.  Obopay Mobile Technology India Pvt Ltd accepts no liability for
any loss or damage arising from this email, any virus transmitted, or its
attachments.*


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs