Re: performInsert() postgres json

2020-01-13 Thread SREEJITH va
ok. Thanks On Mon, Jan 13, 2020 at 4:31 PM Karl Wright wrote: > If you can just put JSON in a string that would work fine. > > Karl > > > On Mon, Jan 13, 2020 at 3:36 AM SREEJITH va wrote: > >> Thanks Karl. >> >> I am trying to use WrappedConnection which I am getting through below API >> and

Re: performInsert() postgres json

2020-01-13 Thread Karl Wright
If you can just put JSON in a string that would work fine. Karl On Mon, Jan 13, 2020 at 3:36 AM SREEJITH va wrote: > Thanks Karl. > > I am trying to use WrappedConnection which I am getting through below API > and using it for database operations in my connector. > > >

Re: performInsert() postgres json

2020-01-13 Thread SREEJITH va
Thanks Karl. I am trying to use WrappedConnection which I am getting through below API and using it for database operations in my connector. *ConnectionFactory.getConnection(jdbcURL, _driver, ManifoldCF.getMasterDatabaseName(), ManifoldCF.getMasterDatabaseUsername(),

Re: performInsert() postgres json

2020-01-02 Thread Karl Wright
The Basetable abstraction doesn't recognize specialty column types like JSON; it's got a limited set of types it knows about, and that is by design so multiple implementations can be written for different databases. Karl On Thu, Jan 2, 2020 at 8:49 AM SREEJITH va wrote: > Hi Karl and Team, >

performInsert() postgres json

2020-01-02 Thread SREEJITH va
Hi Karl and Team, I have a situation where I have to call *performInsert(parameterMap, null)* on a postgres database table with json column. I am getting below error during the insert. *column "X" is of type json but expression is of type character varying Hint: You will need to rewrite