Re: Query on Postgres SQL transaction

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Query on Postgres SQL transaction
Дата
Msg-id 48ea6606-41ad-4094-887a-466c8c827bf2@aklaver.com
обсуждение исходный текст
Ответ на Query on Postgres SQL transaction  ("Bandi, Venkataramana - Dell Team" <Venkataramana.Bandi@dellteam.com>)
Список pgsql-general


On 3/14/24 11:04 PM, Bandi, Venkataramana - Dell Team wrote:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:DengXian; panose-1:2 1 6 0 3 1 1 1 1 1;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face {font-family:"\@DengXian"; panose-1:2 1 6 0 3 1 1 1 1 1;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ligatures:standardcontextual;}span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif;}div.WordSection1 {page:WordSection1;}

Hi Team,

 

We are using JPA entities to persists the records into Postgres SQL DB and its working for all the nodes but one of the node data is not persisting and it’s not giving any DB related errors/exception. We just want to trace out this scenario on transaction level whether transaction is committing or not.


"... its working for all the nodes but one of the node data is not persisting ..." contradict.

Generally when a record does not throw an error, but is not persisted it means the transaction was not committed and the changes did not survive the session they where done in. Without the actual code it hard to say anything more.

 

Could you please let us know how we can trace out this scenario and let us know how transaction logs enabled in Postgres SQL DB.

 

 

Regards,

Venkat

 


Internal Use - Confidential

-- 
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: PostGres ODBC too slow
Следующее
От: vedant patel
Дата:
Сообщение: Re: PostGres ODBC too slow