Using existing SQLite database in Cayenne

Question

I've been playing around with Apache Cayenne in an IntelliJ project. I configure the JDBC in the datanode like in the image but it gives me an error

I have the Cayenne project stored in my IntelliJ project folder, as well as the SQLite database "data.db".

Can anyone help me figuring out this?

score 2 · Accepted Answer · answered Apr 01 '16 at 07:38

2

You need to tell CayenneModeler GUI where to find SQLite jar. To do that on Windows, go to Tools > Preferences > ClassPath and add a path to your SQLLite jar.

answered Apr 01 '16 at 07:38

andrus_a

2,528
1
16
10

Klajd Deda · Answer 2 · 2018-08-24T03:30:08.057

0

It works with cayenne 3.1.1 and

    <dependency>
        <groupId>org.xerial</groupId>
        <artifactId>sqlite-jdbc</artifactId>
        <version>3.23.1</version>
    </dependency>

https://bitbucket.org/xerial/sqlite-jdbc/overview

edited Aug 24 '18 at 03:30

answered Aug 24 '18 at 03:29

Klajd Deda

355
2
7

Using existing SQLite database in Cayenne

2 Answers2