At this moment i'm doing some tests with PgSQL and Servoy with the column type JSONB so we can search trough json objects which are stored within our database.
This works like a charm but now i'm running into an issue when I try to save my foundset back to the database containing this information.
I've created an record in pgAdmin with an plain insert statement such as:
- Code: Select all
INSERT INTO json.test_table(id,data) VALUES(1,'{"name":"Rick", "phone":"+31000000000"}');
And that works ofcourse since its just plain SQL, but when I try to update anything using Servoy I get this error:
- Code: Select all
Can't save form data
> com.servoy.j2db.dataprocessing.DataException: ERROR: column "data" is of type jsonb but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
Position: 93
Does anyone have a clue how I (or Servoy) should cast this in the right way?
Thanks in advance!