JDBC Jar

classic Classic list List threaded Threaded
4 messages Options
Deepak Nigam Deepak Nigam
Reply | Threaded
Open this post in threaded view
|

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
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: JDBC Jar

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 <[hidden email]>:
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
Deepak Nigam Deepak Nigam
Reply | Threaded
Open this post in threaded view
|

Re: JDBC Jar

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 <[hidden email]> 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 <[hidden email]>:
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
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: JDBC Jar

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 <[hidden email]>:
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 <[hidden email]> 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 <[hidden email]>:
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