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 11:25:40 GMT
ok. Thanks

On Mon, Jan 13, 2020 at 4:31 PM Karl Wright <daddywri@gmail.com> 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 <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
>>
>

-- 
Regards
-Sreejith

Mime
View raw message