JDBC SQLiteException - REGEX Function not found

Asked Jan 24 '17 at 04:58

Active Jan 24 '17 at 07:47

Viewed 291 times

query = "SELECT * FROM table_name WHERE (SUBSTR (column_name, 18, 23) REGEXP '^some_text_[0-9]')";
Connection connection = SQLiteJDBCDriverConnection.getConnection();
 ResultSet currentResult = connection.createStatement().executeQuery(query);

I am using REGEX in my query . But the query is not executed . Throws exception

org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such function: REGEXP)

But I'm able execute the query using other softwares like SQLitespy and in php. Also I'm able to use other functions like "LIKE","SUB STRING". But when I use regex function in java , it's throwing error. Is that regex not supported by jdbc ?

edited Jan 24 '17 at 07:47

asked Jan 24 '17 at 04:58

prithivraj

What version of SQLite are you using? If you're using a version earlier than 3 you might have to load your own user defined function. – Tim Biegeleisen Jan 24 '17 at 05:04
See here: http://stackoverflow.com/questions/5071601/how-do-i-use-regex-in-a-sqlite-query – Tim Biegeleisen Jan 24 '17 at 05:06

JDBC SQLiteException - REGEX Function not found

0 Answers0