Re: [BUGS] BUG #14467: Insertion Issue with Hibernate
От | Johannes Lochmann |
---|---|
Тема | Re: [BUGS] BUG #14467: Insertion Issue with Hibernate |
Дата | |
Msg-id | B0587F4C289A9E4AA474087E2B7E1579793BC2AC3A@srv01.topcontrol.local обсуждение исходный текст |
Ответ на | [BUGS] BUG #14467: Insertion Issue with Hibernate (rkumar@obopay.com) |
Ответы |
Re: [BUGS] BUG #14467: Insertion Issue with Hibernate
|
Список | pgsql-bugs |
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 columnis 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 protectedfrom disclosure or unauthorized use. If the reader of this message is not the intended recipient, you are herebynotified that any dissemination, distribution or copying of this communication is prohibited. If you have receivedthis communication in error, please notify us immediately by replying to this message and then delete it. All e-mailsent 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 protectedfrom disclosure or unauthorized use. If the reader of this message is not the intended recipient, you are herebynotified that any dissemination, distribution or copying of this communication is prohibited. If you have receivedthis communication in error, please notify us immediately by replying to this message and then delete it. All e-mailsent to this address will be received by Obopay Mobile Technology India Pvt Ltd and may be archived or reviewed. ObopayMobile 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
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Johannes LochmannДата:
Сообщение: Re: [BUGS] BUG #14467: Insertion Issue with Hibernate