Hi there, > One of the first concerns is: how do you run the code generator when the > database is only accessible on the phone?
Unfortunately, I have no experience with that. The biggest trouble you might run into is the fact that Android (per default) circumvents JDBC from what I know. jOOQ (as well as jOOQ-meta for the generator) depends heavily on JDBC. Having said this, jOOQ is integration tested using this inofficial JDBC driver on a Windows machine here: http://www.zentus.com/sqlitejdbc/ > Here are the steps I use when > developing for the desktop: > > 1. Create a sample database using Flyway. > 2. Run JOOQ's code generator against it. > 3. Compile classes that use the generated classes. That would work. Other users on this group have successfully used jOOQ against several databases, such as Oracle, SQL Server, Postgres and other combinations. In essence, you could develop against an H2 database and roll out your application on an Android phone with a SQLite database. Again, this presumes that you're using JDBC... > If I find a way to generate a SQLite database, will JOOQ actually work? Or > is Android support more theoretical than practical at this point? I have not heard of anyone actually using jOOQ on an Android phone so far. Maybe you could get some help on Stack Overflow? Cheers Lukas
