SQLite Data Source

Hi,
I've used the old Birt 2.5 for years and with an SQL source so understand its fundamentals reasonably.
I now wish to write some reports for an SQLite db and spent all day trying to get it setup as a data source without success.
So have now downloaded and installed Eclipse Mars1 BIRT Designer Version 4.5.0.v201506092134 
Also got sqlite-jdbc-3.8.11.2.jar
Been to Preferences...Driver definition and point to the lib jar file.
 
But have failed totally to connect to my .db file.
Testing the connection I get
java.sql.SQLException: [SQLITE_CANTOPEN] Unable to open the database file (out of memory)
 
 
I feel I am missing some fundamental piece of this puzzle somewhere.
 
Any guidance gratefully received.

Find more posts tagged with

Comments

Clement Wong

On my Windows 7 64-bit environment, I ran a quick test and was able to connect to a very simple SQLite database, and run/view a report.
 
I first downloaded SQLite Tools for Windows (<a data-ipb='nomediaparse' href='https://www.sqlite.org/2016/sqlite-tools-win32-x86-3100200.zip'>sqlite-tools-win32-x86-3100200.zip</a>) and created a database via sqlite3.
 
Then, I downloaded sqlite-jdbc-3.8.11.2.jar from <a data-ipb='nomediaparse' href='https://bitbucket.org/xerial/sqlite-jdbc/downloads'>https://bitbucket.org/xerial/sqlite-jdbc/downloads</a>. 
 
Next, I downloaded the latest BIRT All in One Eclipse 64-bit, and pointed the -vm setting in eclipse.ini to my Java 1.8.0_45's javaw.exe. Opened the directory ...eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_4.5.0.v201506092134\drivers directory and moved sqlite-jdbc-3.8.11.2.jar in.
 
Finally, I launched Eclipse and created a new project/report. In the Data Source, I used:
 
Driver class: org.sqlite.JDBC (v3.8)
Database URL: jdbc:sqlite:C:/sqlite/ex1.db
 
And was able to Test Connection.
 
In the Data Set, I was able to enter a query to select from my table and Preview.
 
 
1. In your environment, what OS are you on? What Java version are you running?
2. Have you tried a very simple SQLite db (1 table, 1 or 2 rows), and does that have any memory issues?
3. Have you tried increasing your Eclipse.ini -Xmx setting? The default is "-Xmx1024m".

nt4boy

Simples...
thank you Clement.
 
the magic trick or missing link was putting the jar file in the plugin folder.
The other instructions I'd followed for adding it via the GUI that also required jni.dll in the jre bin evidently not appropriate.
 
 
This method truly works.
 
I think the memory error was what ever I'd nearly installed complaining, 
 
OS stuff for the record (64 bit W7 jre 7u80)
 
Thanks a million