Hello!
I'm not sure but it doesn't look right to me. Does it compile?
Note that you also need to SET STREAMING OFF after data load is complete.
--
Ilya Kasnacheev
чт, 6 сент. 2018 г. в 14:42, Sriveena Mattaparthi <
sriveena.mattapar...@ekaplus.com>:
> Thanks Ilya. Will try using together.
>
>
>
> Please correct if the below statement work.
>
> getConnection().createStatement().execute("SET STREAMING ON");
>
>
>
> Regards,
>
> Sriveena
>
>
>
> *From:* Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com]
> *Sent:* Thursday, September 06, 2018 3:28 PM
> *To:* user@ignite.apache.org
> *Subject:* Re: Batch insert into ignite using jdbc thin driver taking
> long time
>
>
>
> Hello!
>
>
>
> I don't see why not. Have you tried? Any difference in run time?
>
>
>
> Regards,
>
> --
>
> Ilya Kasnacheev
>
>
>
>
>
> чт, 6 сент. 2018 г. в 6:20, Sriveena Mattaparthi <
> sriveena.mattapar...@ekaplus.com>:
>
> Hi Ilya,
>
>
>
> Can we cobimbe both of them together I mean
>
> 1. SET STREAMING ON;
>
> 2. JDBC thin driver batch insert (pstmt.executeBatch())
>
>
>
> Thanks & Regards,
> Sriveena
>
>
>
> *From:* Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com]
> *Sent:* Wednesday, September 05, 2018 7:02 PM
> *To:* user@ignite.apache.org
> *Subject:* Re: Batch insert into ignite using jdbc thin driver taking
> long time
>
>
>
> Hello!
>
>
>
> Have you tried streaming mode?
>
>
>
> https://apacheignite-sql.readme.io/docs/set
> <https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fset&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C7d329f7496a845c707bb08d61333fb1d%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636717511328312021&sdata=WfZ7m34afylAJv0PZ0GRo2o7mIQVxR6f%2BCb2MuQUj3M%3D&reserved=0>
>
>
>
> Regards,
>
> --
>
> Ilya Kasnacheev
>
>
>
>
>
> ср, 5 сент. 2018 г. в 15:44, Sriveena Mattaparthi <
> sriveena.mattapar...@ekaplus.com>:
>
> Hi,
>
>
>
> I am trying to batch insert 300000 records into ignite cache(on remote
> server) using jdbc thin driver.
>
> It is taking nearly 4mins to complete this operation. Please advise.
>
>
>
> Thanks & Regards,
>
> Sriveena
>
>
>
> “Confidentiality Notice: The contents of this email message and any
> attachments are intended solely for the addressee(s) and may contain
> confidential and/or privileged information and may be legally protected
> from disclosure. If you are not the intended recipient of this message or
> their agent, or if this message has been addressed to you in error, please
> immediately alert the sender by reply email and then delete this message
> and any attachments. If you are not the intended recipient, you are hereby
> notified that any use, dissemination, copying, or storage of this message
> or its attachments is strictly prohibited.”
>
> “Confidentiality Notice: The contents of this email message and any
> attachments are intended solely for the addressee(s) and may contain
> confidential and/or privileged information and may be legally protected
> from disclosure. If you are not the intended recipient of this message or
> their agent, or if this message has been addressed to you in error, please
> immediately alert the sender by reply email and then delete this message
> and any attachments. If you are not the intended recipient, you are hereby
> notified that any use, dissemination, copying, or storage of this message
> or its attachments is strictly prohibited.”
>
> “Confidentiality Notice: The contents of this email message and any
> attachments are intended solely for the addressee(s) and may contain
> confidential and/or privileged information and may be legally protected
> from disclosure. If you are not the intended recipient of this message or
> their agent, or if this message has been addressed to you in error, please
> immediately alert the sender by reply email and then delete this message
> and any attachments. If you are not the intended recipient, you are hereby
> notified that any use, dissemination, copying, or storage of this message
> or its attachments is strictly prohibited.”
>
