Mapping the postgresql type bytea in the ServiceBuilder

[Barbalace Daniela, geändert vor 12 Jahren.]

Hi all,

I'm trying to use Liferay with an existing schema (using postgresql as database). As explained in the documentation, I used ServiceBuilder in order to interface Liferay with the existing tables.
One of the column types of one table is an array of bytes. I read that Service Builder does not implement this type but in these cases you must use a string to map the field. So for example, if x is the name of the column whose type is bytea, then I'll have in the Service Builder:

<column name="X" db-name="x" type="String" />

However, in this way the issue is that when I try to do an update, or insert a new row in the table I get this Exception:

[JDBCExceptionReporter:101] ERROR: column "x" is of type bytea but expression is of type character varying

Any help will be appreciated.
Thanks in advance

Regards

[Barbalace Daniela, geändert vor 12 Jahren.]

Anybody?