manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <daddy...@gmail.com>
Subject Re: performInsert() postgres json
Date Mon, 13 Jan 2020 11:01:15 GMT
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 <va.sreejith@gmail.com> 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.
>
>
> *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