manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From SREEJITH va <>
Subject Re: performInsert() postgres json
Date Mon, 13 Jan 2020 08:36:27 GMT
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.getMasterDatabaseUsername(), ManifoldCF.getMasterDatabasePassword(),
maxDBConnections, false);*

In this way I can run the query directly and overcome the issue with json
datatype. Is it ok to proceed with this or I should not directly use
wrapper connections ?. Any performance concerns using wrapperconnections
manually for connector instead of extending BaseTable.

On Thu, Jan 2, 2020 at 7:26 PM Karl Wright <> wrote:

> 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,
>> 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 "XXXXX" is of type json but expression is of type character
>> varying  Hint: You will need to rewrite or cast the expression.*
>> Is there any way I can achieve this using Basetable api?
>> --
>> Regards
>> -Sreejith


View raw message