You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by Deepak Nigam <de...@gmail.com> on 2019/07/11 16:17:07 UTC

JDBC Jar

Hello all,

I need to download the jar file for connecting apache ignite with one of my
web application written in Java. I tried to search it on the internet but
unable to find it. Please let me know where I can find it.


Regards
--
Deepak Nigam

Re: JDBC Jar

Posted by Ilya Kasnacheev <il...@gmail.com>.

Hello!

There's no such command I guess. Maybe there's !tables? Notice the
exclamation mark.

Regards,
-- 
Ilya Kasnacheev


чт, 11 июл. 2019 г. в 20:11, Deepak Nigam <de...@gmail.com>:

> Thanks, IIya.
>
> I am trying to see the data tables that my web application has created
> using the sqlline utility. I ran the following command:
>
> ./sqlline.sh --verbose=true -u "jdbc:ignite:thin://127.0.0.1/"
>
> The connection was successful but when I ran 'tables' command, I got the
> following error:
>
>
> Error: Failed to parse query. Syntax error in SQL statement "TABLES[*] ";
> expected "TRUNCATE, {"; SQL statement:
> tables [42001-197] (state=42000,code=1001)
> java.sql.SQLException: Failed to parse query. Syntax error in SQL
> statement "TABLES[*] "; expected "TRUNCATE, {"; SQL statement:
> tables [42001-197]
> at
> org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750)
> at
> org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)
> at
> org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)
> at sqlline.Commands.execute(Commands.java:823)
> at sqlline.Commands.sql(Commands.java:733)
> at sqlline.SqlLine.dispatch(SqlLine.java:795)
> at sqlline.SqlLine.begin(SqlLine.java:668)
> at sqlline.SqlLine.start(SqlLine.java:373)
> at sqlline.SqlLine.main(SqlLine.java:265)
>
> Please let me know if I am missing something.
>
> Thanks in advance!
>
> Regards
> --
> Deepak Nigam
>
>
>
>
>
>
>
> On Thu, Jul 11, 2019 at 10:08 PM Ilya Kasnacheev <
> ilya.kasnacheev@gmail.com> wrote:
>
>> Hello!
>>
>> It's ignite-core-2.7.5.jar from libs/ - providing jdbc:ignite:thin://
>> driver
>>
>> Please note that it needs the common Java 9+ args to function.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> чт, 11 июл. 2019 г. в 19:17, Deepak Nigam <de...@gmail.com>:
>>
>>> Hello all,
>>>
>>> I need to download the jar file for connecting apache ignite with one of
>>> my web application written in Java. I tried to search it on the internet
>>> but unable to find it. Please let me know where I can find it.
>>>
>>>
>>> Regards
>>> --
>>> Deepak Nigam
>>>
>>

Re: JDBC Jar

Posted by Deepak Nigam <de...@gmail.com>.

Thanks, IIya.

I am trying to see the data tables that my web application has created
using the sqlline utility. I ran the following command:

./sqlline.sh --verbose=true -u "jdbc:ignite:thin://127.0.0.1/"

The connection was successful but when I ran 'tables' command, I got the
following error:

Error: Failed to parse query. Syntax error in SQL statement "TABLES[*] ";
expected "TRUNCATE, {"; SQL statement:
tables [42001-197] (state=42000,code=1001)
java.sql.SQLException: Failed to parse query. Syntax error in SQL statement
"TABLES[*] "; expected "TRUNCATE, {"; SQL statement:
tables [42001-197]
at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)
at sqlline.Commands.execute(Commands.java:823)
at sqlline.Commands.sql(Commands.java:733)
at sqlline.SqlLine.dispatch(SqlLine.java:795)
at sqlline.SqlLine.begin(SqlLine.java:668)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)

Please let me know if I am missing something.

Thanks in advance!

Regards
--
Deepak Nigam

On Thu, Jul 11, 2019 at 10:08 PM Ilya Kasnacheev <il...@gmail.com>
wrote:

> Hello!
>
> It's ignite-core-2.7.5.jar from libs/ - providing jdbc:ignite:thin://
> driver
>
> Please note that it needs the common Java 9+ args to function.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> чт, 11 июл. 2019 г. в 19:17, Deepak Nigam <de...@gmail.com>:
>
>> Hello all,
>>
>> I need to download the jar file for connecting apache ignite with one of
>> my web application written in Java. I tried to search it on the internet
>> but unable to find it. Please let me know where I can find it.
>>
>>
>> Regards
>> --
>> Deepak Nigam
>>
>

Re: JDBC Jar

Posted by Ilya Kasnacheev <il...@gmail.com>.

Hello!

It's ignite-core-2.7.5.jar from libs/ - providing jdbc:ignite:thin:// driver

Please note that it needs the common Java 9+ args to function.

Regards,
-- 
Ilya Kasnacheev


чт, 11 июл. 2019 г. в 19:17, Deepak Nigam <de...@gmail.com>:

> Hello all,
>
> I need to download the jar file for connecting apache ignite with one of
> my web application written in Java. I tried to search it on the internet
> but unable to find it. Please let me know where I can find it.
>
>
> Regards
> --
> Deepak Nigam
>