Hello!

You are using an Ignite Thick Client driver. As its name implies, it will
start a local client node and then connect to it, without the option of
doing local queries.

You need to use Ignite Thin JDBC driver: jdbc:ignite:thin://<server ip>
Then you can do local queries.

Regards,
-- 
Ilya Kasnacheev


сб, 24 окт. 2020 г. в 16:04, narges saleh <snarges...@gmail.com>:

> Hello Ilya
> Yes, it happens all the time. It seems ignite forces the "client"
> establishing the jdbc connection into a client mode, even if I set
> client=false.  The sample code and config are attached. The question is how
> do I force JDBC connections from a server node.
> thanks.
>
> On Fri, Oct 23, 2020 at 10:31 AM Ilya Kasnacheev <
> ilya.kasnach...@gmail.com> wrote:
>
>> Hello!
>>
>> Does this happen every time? If so, do you have a reproducer for the
>> issue?
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> пт, 23 окт. 2020 г. в 13:06, narges saleh <snarges...@gmail.com>:
>>
>>> Denis -- Just checked. I do specify my services to be deployed on server
>>> nodes only. Why would ignite think that I am running my code on a client
>>> node?
>>>
>>> On Fri, Oct 23, 2020 at 3:50 AM narges saleh <snarges...@gmail.com>
>>> wrote:
>>>
>>>> Hi Denis
>>>> What would make an ignite node a client node? The code is invoked via
>>>> an ignite service deployed on each node and I am not setting the client
>>>> mode anywhere. The code sets the jdbc connection to local and tries to
>>>> execute a sql code on the node in some interval. By the way, I didn't know
>>>> one could deploy a service on client nodes. Do I need to explicitly mark a
>>>> node as a server node when deploying a service?
>>>> thanks
>>>>
>>>> On Thu, Oct 22, 2020 at 9:42 PM Denis Magda <dma...@apache.org> wrote:
>>>>
>>>>> The error message says you're attempting to run the query on a client
>>>>> node. If that's the case (if the service is deployed on the client node),
>>>>> then the local flag has no effect because client nodes don't keep your 
>>>>> data
>>>>> locally but rather consume it from servers.
>>>>>
>>>>> -
>>>>> Denis
>>>>>
>>>>>
>>>>> On Thu, Oct 22, 2020 at 6:26 PM narges saleh <snarges...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hi All,
>>>>>> I am trying to execute a sql query via a JDBC  connection on the
>>>>>> service node (the query is run via a service), but I am getting 
>>>>>> *Execution
>>>>>> of local SqlFieldsQuery on client node disallowed.*
>>>>>> *The JDBC connection has the option local=true as I want to run the
>>>>>> query on the data on the local node only.*
>>>>>> *Any idea why I am getting this error?*
>>>>>>
>>>>>> *thanks.*
>>>>>>
>>>>>

Reply via email to