SQLite Error unsupported Savepoint

[womisa]

Hi

I get the following error when I run a SQL command "java.sql.SQLExeption:unsupported by SQLite:savepoints"

I have this with

java version "1.8.0_60"
Java(TM) SE Runtime Environment (build 1.8.0_60-b27)
Java HotSpot(TM) 64-Bit Server VM (build 25.60-b23, mixed mode)

SQLeo Visual Query Builder :: java database frontend
Version : 2015.12.rc1

-sqlite-jdbc-3.8.7.jar and
-sqlite-jdbc-3.7.2.jar

Drivers. The SQL Query are ok with other QueryTools

What am I doing wrong? Can you help me please?

Best regards
Achim

[PAscal]

You are not doing anything wrong ...
We added an Auto-Savepoint feature in version 2015.12 for PostgreSQL and MonetDB ...

Please use version 2015.10, we will add the possibility to disable Auto-Savepoint in next release.

Thanks for reporting this
Regards
PAscal

[PAscal]

See ticket # 337

[womisa]

Hi PAScal,

thanks for the rapid answer. This works for me very well. Thanks!

Another Question(s) im new to SQLeo therefore forgive me if I ask stupid

-how can i delete an entry in the driver.new list?
-why is my old connection entry from the previous config/connection still present....who store this...by a prortable
-i can not select the the driver (class) in the drop down list I have to explicitly enter > org.sqlite.JDBC

Nice to have Feature.

-Browse in the Filesystem to the SQLite Databasefile by new datasource.....

Thanks for your help
Achim

[PAscal]

how can i delete an entry in the driver.new list?
right click / delete

why is my old connection entry from the previous config/connection still present....who store this...by a prortable
see if stored in your home directory ( .sqleo.config )

i can not select the the driver (class) in the drop down list I have to explicitly enter > org.sqlite.JDBC
this is a SQLite specific issue, works fine for other RDBMS

Browse in the Filesystem to the SQLite Databasefile by new datasource.....
I anderstand, but this is made only one time and other RDBMS usually work with remote database serveurs (no need to browse)

[womisa]

Hi

thank for your answer

how can i delete an entry in the driver.new list?

right click / delete

...sure, but no reaction on my right click on the item in the driver.new window......mmmhhhh

[PAscal]

I missunderstood the question ...
driver.new list is read only
its content is stored in your HomeDirectory/.sqleo.config/sqleo.xml
but I would invite you to keep it as it is ...