Not sure if this is a limitation in SQLite/virtual tables or DomSQL.
If I try to fetch data (SELECT * FROM tablename) in an application from another application on the same server using createConnectionFromUrl, I get this error:
SQL logic error or missing database
I can list the tables in the database using this command:
SELECT * FROM sqlite_master
From this, I think that the connection is ok.
The reason I would like to connect to another database/domsql is that I want to have a standalone reporting application that connects to a range of databases. The target databases for reporting inherit from a template. This means that I can maintain one configuration for all current and future applications in one place.
With the current limitation, I will need to create separate configurations per target database in the reporting application.
Not sure if this is related, but I found a thread regarding Java/SQLite and virtual tables:
https://community.oracle.com/thread/1774849