Project

General

Profile

Actions

Defect #717

closed

Cannot save 0x00 to Postgres column

Added by Vít Švanda over 6 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Vít Švanda
Category:
Dto mapping
Target version:
Start date:
09/25/2017
Due date:
% Done:

100%

Estimated time:
Affected versions:
Owner:

Description

org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00


Related issues

Related to IdStory Identity Manager - Defect #2684: Some messages are missing in the Logging eventsClosedVít Švanda02/12/2021

Actions
Actions #1

Updated by Vít Švanda over 6 years ago

  • Subject changed from Cannot save 0x00 to Postgress column to Cannot save 0x00 to Postgres column
  • Assignee changed from Vít Švanda to Ondřej Kopr
  • % Done changed from 0 to 90

Fixed:

  • Problem was in character 0x00. This "null" char cannot be save in Postgres DB.
  • I created StringToStringConverter, when string contains this char, then is replaced with "".
  • I created Test for this situation in DefaultSynchronizationTest (this test have good sence only via Postgres DB not via H2 DB).
Actions #2

Updated by Vít Švanda over 6 years ago

  • Status changed from In Progress to Needs feedback
Actions #3

Updated by Ondřej Kopr over 6 years ago

  • Status changed from Needs feedback to Resolved
  • Assignee changed from Ondřej Kopr to Vít Švanda
  • % Done changed from 90 to 100

I was tested via your test (start trough postgresql database), works thank you

Actions #4

Updated by Vít Švanda over 6 years ago

  • Status changed from Resolved to Closed
Actions #5

Updated by Radek Tomiška about 3 years ago

  • Related to Defect #2684: Some messages are missing in the Logging events added
Actions

Also available in: Atom PDF