[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.birt] Re: SQLite as Data Source - No items available 
This should work.

"Test Connection" always succeeds with SQLite because the driver will just create a new database based on the Driver URL. 

Check that the Driver URL and Driver Class fields are correct.

SHOW TABLES isn't used here, I imagine it's using JDBC metadata.

Anthony

Mark L. wrote:

Hey guys.

I want to add a Data Set from a Data Source (SQLite via corresponding JDBC driver). It fails, because no tables can be found in the field 'Available Items' in the 'New Data Set' wizard. 

Can you point me to the piece of code determining these available items?
SQLite does not support the SHOW TABLES command.
May that be the reason for the above problem?


Cheers,
Mark

PS. Testing the connection in the 'Edit Data Source' dialog succeeds.