Accessing Sqllite with another tool

Databases
1

I posted this question a while ago and have yet to find an adequate solution.
I want to use Eclipse/Birt for reporting against my SQLLITE db that I created with XOJO. I downloaded the driver, set up a connection successfully (ie I tested it)
But when I go to use it, I get Java errors and don’t see a table list

Has anyone successfully accessed a SQLLITE database that was created by XOJO in other client tools?

2

I use OpenRPT (Opensource reporting tool) for reporting. No problem with accessing SQLite.

3

as long as your DB it is unencrypted… NaviCat

4

Valentina Studio has a free version you can try.
https://www.valentina-db.com/en/get-free-valentina-studio

5

Xojo creates standard SQLite 3.9.2 databases. As long as your DB file is unencrypted, any SQLite tool can open it.

6

Thanks for the quick responses. Let me clear up a few things

  1. I want to use BIRT, so I’m not interested in any other solutions
  2. Is encrypton the default for new DB’s in SQllite, if it isn’t then my db is not encrypted
  3. What is the userid/password for a default sqlite db?

Thanks all

7

Encryption is not the default.

A SQLite DB does not have a userid/password.

8

Then I’m back to where I started :slight_smile:

9

Perhaps if you detailed WHAT the Java errors are… it might help someone here point you in a good direction…

Have you done any research on the Net. I found thousands of articles discussing BIRT and SQLite…
some discussing problems, some indicating that certain ODBC drivers were required… etc.

10

It’s not an error per se. It’s just that birt shows no tables in the new datasource after I create it.

As per your suggestion , I will now search BIRT and sql lite

If it helps any, the db name is .rdb not db

11

Url is:

jdbc:sqlite:E:/XOJO/SEEDMANAGER.rdb

Jar file is in the xojo directory, same as db

12

Have you tried opening this DB in another SQLite DB tool to make sure it is OK there?

13

Yes and it’s there and fine

Eclipse is not showing any tables in the db

Here is error

SQL error #1:[SQLITE_ERROR] SQL error or missing database (no such table: seedinventory)

14

I could email the db to you Paul and you could see for yourself

It’s just a db of my garden seed collection

15

Sure. paul@xojo.com

16

You could download a copy of oneSql to look inside your SQLite DB: www.onesql.uk. It’s written in Xojo by the way :wink:

17

Sent

18

@Brent Eamer I know you want to use BIRT to read/use your SQLite database. But I would use a 3rd product to check the database. There are many SQLite tools out there (depending on which O/S you are on). I use a lot of SQLite databases with Xojo. I use 2-3 (on each platform) different SQLite tools to check/use/verify the SQLite databases all the time.

So I would find one (or more) of these tools and use it as a validation tool for you.

19

The error indicates to me that BIRT cannot connect to the database… and that the “table is missing” is incidental…
perhaps BIRT does care about the extension… and the .RDB may not be appropriate…
Most other tools don’t care, but BIRT might

20

Sorry, but this was driving me insane :slight_smile: It’s SQLite. With one “L”.