manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From SREEJITH va <va.sreej...@gmail.com>
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.getMasterDatabaseName(),
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 <daddywri@gmail.com> 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 <va.sreejith@gmail.com> 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
>>
>

-- 
Regards
-Sreejith

Mime
View raw message