Hi,
Hi, after i updated the dotconnect for postgres to the last version (7.20.1782)i have face some exception when i insert or update a json/jsonb column type.
The exception is:
$exception {"invalid input syntax for type json"}
The column type is jsonb
Error insert/update $exception {"invalid input syntax for type json"}
Re: Error insert/update $exception {"invalid input syntax for type json"}
Hello.
I was unable to reproduce the exception with dotConnect for PostgreSQL - 7.20.1782 - I can insert and update jsonb data via dotConnect.
Update example:
(The column "info" in the table "books" has type jsonb).
Can you send us an example of your code witch causes exception?
Besides, the latest version of dotConnect for PostgreSQL is 7.20.1792 and we recommend updating to it.
If the error is still reproduced, we need more information about it and a code example, reproducing it.
I was unable to reproduce the exception with dotConnect for PostgreSQL - 7.20.1782 - I can insert and update jsonb data via dotConnect.
Update example:
Code: Select all
PgSqlCommand cmd = db.CreateCommand();
cmd.CommandText = @"update books set info= '{""price"": 60, ""name"": ""Alice""}' where id=3";
cmd.ExecuteNonQuery();
Can you send us an example of your code witch causes exception?
Besides, the latest version of dotConnect for PostgreSQL is 7.20.1792 and we recommend updating to it.
If the error is still reproduced, we need more information about it and a code example, reproducing it.
Re: Error insert/update $exception {"invalid input syntax for type json"}
We have reproduced the issue with jsonb and will notify you when it is fixed.
Re: Error insert/update $exception {"invalid input syntax for type json"}
The bug with inserting JSONB value via a parameter of PgSqlCommand is fixed in dotConnect for PostgreSQL v7.20.1812: viewtopic.php?f=3&t=44357.