java - SQL error or missing database (near "(": syntax error)

Question

I have a big problem with SQLite in Java. When I run this query with MariaDB everything works perfectly, but with SQLite not. Does anyone know an answer?

Query:

SELECT *
FROM (SELECT *, RANK() OVER (ORDER BY kills DESC) AS ranking FROM sp_rageffa) AS `*2`
WHERE uuid = 'b71e5129-7216-4d79-b79f-2e3893a6befa';

Error:

SQL error or missing database (near "(": syntax error)

question from:https://stackoverflow.com/questions/65877393/sql-error-or-missing-database-near-syntax-error

Answer 1

I tried it in the database browser, and there's nothing wrong with your command. Support for that syntax was introduced in version 3.25 of sqlite, and jdbc (the java interface with sqlite) using pretty much the same versioning scheme, so you should make sure you're using a version of jdbc numbered 3.25 or higher.