driver « hsqldb « Java Database Q&A

1. P6spy doesn't spy on hsql jdbc driver

When trying to spy on the jdbc connection to a hsqldb database it doesn't work. It looks like the org.hsqldb.jdbcDriver is not deregistered.

2. SQL on CSV using HSQLDB JDBC Driver

I have a pregenerated CSV file on which I need to run SQL queries on. I've looking at different open source solutions (e.g. CsvJdbc, xlSQL etc) but haven't really found anything ...

3. can't load the driver (hsqldb)

Java Code: import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class TestDemobase { static String database = "/bsp/database"; static String sql = "SELECT * FROM Bookmarks"; static String sql1 = "SELECT url FROM Bookmarks"; static String sql2 = "INSERT INTO Bookmarks VALUES('Pythoni', '');CHECKPOINT"; static Connection connection; public static void main(String[] args) throws Exception { System.out.println("TestDemobase 1\n"); Class.forName("org.hsqldb.jdbcDriver"); connection = DriverManager.getConnection("jdbc:hsqldb:" ...