BDM - Text datatype and PostgresSQL

Q&A
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

2

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.

3

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.