gwenn

Could you please check `hibernate.hbm2ddl.auto` properties (or something similar) ? ```xml ``` Since SQLite doesn't fully support `ALTER TABLE`, you cannot use `update` (you must upgrade the DB schema yourself).

No

Are you sure that the JPA transaction is correctly declared ? Which JDBC driver is used ? Could you try to activate the SQLite [log](http://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfiglog) and [trace](http://sqlite.org/c3ref/profile.html) and see what...

So I still don't known/have the SQLite driver used, the SQLite traces (not the hibernate traces because drivers execute their owns queries), and no sample. Could you try to tweak...

I can't reproduce the error: ```java @Service("clientService") public class ClientServiceImpl implements ClientService { @PersistenceContext private EntityManager entityManager; // ... @Transactional public void replaceAll(Client client) { entityManager.createQuery("DELETE FROM Client").executeUpdate(); entityManager.persist(client); entityManager.flush();...

Why do you use `GenerationType.AUTO` instead of `GenerationType.IDENTITY` ? If there is no reason, what happens when you switch to `GenerationType.IDENTITY` ? And maybe we should fix driver / dialect...

See https://github.com/gwenn/sqlite-dialect/commit/43fdae9dd5bcf245ed148bf3e4711adf463b5eee (but useful only with GenerationType.IDENTITY).

Because, in the super constructor you can find: ```java registerColumnType( Types.FLOAT, "float($p)" ); registerColumnType( Types.DOUBLE, "double precision" ); ``` And because, with SQLite: https://sqlite.org/datatype3.html#affinity Column types are used only for...

As far as I know, you cannot generate Java entities from your database. And the problem may be related to SQLiteDialect. But also related to SQLite JDBC driver. I am...

The _orphan rule_ means that only `rust_decimal` or `rusqlite` crates can implement `FromSql`/`ToSql` for `Decimal` directly.