Hi Val,
I added ignite-core.jar to classpath but it didn't work. So I combined both
sqlline jar and ignite-core jar into one
sqlline-1.1.10-SNAPSHOT-jar-with-ignitejdbcdriver.jar file. This time it did
seem to work but landed into another error: Transactions not supported.
# java -jar sqlline-1.1.10-SNAPSHOT-jar-with-ignitejdbcdriver.jar -u
jdbc:ignite://192.168.25.235/TestTable -d org.apache.ignite.IgniteJdbcDriver
Error: Transactions are not supported. (state=,code=0)
java.sql.SQLFeatureNotSupportedException: Transactions are not supported.
at
org.apache.ignite.internal.jdbc.JdbcConnection.setTransactionIsolation(JdbcConnection.java:249)
at sqlline.Commands.isolation(Commands.java:679)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:186)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
at sqlline.Commands.connect(Commands.java:1064)
at sqlline.Commands.connect(Commands.java:996)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
at sqlline.SqlLine.dispatch(SqlLine.java:809)
at sqlline.SqlLine.initArgs(SqlLine.java:588)
at sqlline.SqlLine.begin(SqlLine.java:661)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
sqlline version ???
0: jdbc:ignite://192.168.25.235/TestTable>
looks like sqlline tool is questioning the capabilities of ignite. It seems
sqlline can't be used until transactions are not supported.
Another thing I would like to know whether Insert, Update, Delete sql
statements are supported or not? If not, when these statements will be
supported?
thanks & regards,
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Stored-Procedure-tp6548p6836.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
