Denis,
I am setting streaming on in my JDBC connection URL, and I try to insert
data.
Here is the sequence:
Connection conn = DriverManager.getConnection("jdbc:ignite:cfg://
*streaming=true*@file:///opt/ignite/config/config.xml");
PreparedStatement stmt = conn.prepareStatement(
"INSERT INTO PERSON.PERSON(orgName,firstName, lastName, resume, salary)
VALUES(?,?, ?, ?, ?)");
Isn't this sufficient? Am I supposed to set streaming on explicitly in the
code, not in the connection?
thanks.
On Mon, Apr 20, 2020 at 11:25 PM Denis Magda <[email protected]> wrote:
> You need to issues SET STREAMING ON/OFF commands after opening a
> connection with the driver:
> https://apacheignite-sql.readme.io/docs/set
>
> -
> Denis
>
>
> On Sun, Apr 19, 2020 at 7:55 AM narges saleh <[email protected]> wrote:
>
>> Actually, I still have issue with this.
>> It seems I am not able to specify a JDBC connection with streaming
>> enabled, if the cache is not specified.
>> I get the following error:
>> SQLException: Cache cannot be null when streaming is enabled.
>>
>> Anyway, out of this, i.e., specifying a JDBC connection with streaming
>> enabled, and leaving the cache out? The cache will be specified in the SQL.
>>
>> thanks.
>>
>> On Fri, Apr 10, 2020 at 6:47 AM narges saleh <[email protected]>
>> wrote:
>>
>>> Hi All,
>>> I think I have figured it out. I just need to specify the schema.
>>> thanks.
>>>
>>> On Thu, Apr 9, 2020 at 9:30 PM narges saleh <[email protected]>
>>> wrote:
>>>
>>>> Hi All,
>>>> 1) How would one use ignite's JDBC connection to query multiple tables,
>>>> both in case of joins and separately? I.e., Can one get a JDBC connection,
>>>> and use it to query multiple caches? Another use case, is where a JDBC
>>>> connection is used to query caches whose name is known at runtime. The
>>>> client can be think or thick.
>>>>
>>>> 2)The same for inserts. Can one uses the same JDBC connection with
>>>> different jdbc statements to load data into different caches?
>>>>
>>>> I'd appreciate link and/or examples.
>>>>
>>>> thanks.
>>>>
>>>
