ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kvipin <vipinkuma...@yahoo.com>
Subject Re: Stored Procedure
Date Sun, 07 Aug 2016 15:57:21 GMT
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.

Mime
View raw message