BDM - Text datatype and PostgresSQL

Submitted by erwan.bodere on Thu, 06/16/2016 - 22:38
1
0
-1

Hi,

I have objects with some fields of "Text" datatype in my BDM.
My BDM is stored in PostgresSQL 9.3.
It works fine with Bonita process and application.

When i want to select data with SQL query, i can't retrieve text fields correctly. Thoses fields contains numeric values (ex : "1367862").

Have you the same problem ?
How can i retrive the real text value ? Is there a mapping table ?

Regards

Erwan

#BDM
#bonita7
2 answers

Submitted by whramirez on Fri, 05/18/2018 - 15:46
1
0
-1

Hello Erwan,
perhaps it's late for response, but in Posgresql the fields type Text have a kind of pointer (long) that point to really content. It's normal. When you do a 'Select ' of this you will see its number, not the content. If you need to see your content you must do something like: 'Select convert_from(loread(lo_open(yourTextField::int, x'40000'::int), x'40000'::int), 'UTF8') from YourTable;'
Regards.

Submitted by erwan.bodere on Fri, 06/17/2016 - 10:51
1
0
-1

Looking into bdm-client-pojo.jar, i can see :

@Column(name = "DESCRIPTION", nullable = true)
@Lob
private String description;

The "Text" datatype is interpreted as Lob by hibernate.

Notifications