Hello, Thanks for reporting this. This is a bug, for which I have registered #2608. https://github.com/jOOQ/jOOQ/issues/2608
jOOQ should not assume that the sqlite_sequence table exists. In the mean time, create a dummy table to force the generation of this sqlite_sequence table, as a workaround. Cheers Lukas 2013/7/5 Pay Liu <[email protected]> > Hi @Lukas > * > * > When I run codegen for sqlite db, I got a error as below. > It seem to be caused by missing table *sqlite_sequence*. > * > * > I checked the doc*, SQLite Autoincrement<http://www.sqlite.org/autoinc.html> > .* > * > * > That table *sqlite_sequence* is created automatically when create a table > contain AUTOINCREMENT column, such as > > CREATE TABLE table_name ( > id INTEGER PRIMARY KEY AUTOINCREMENT, > name TEXT > ); > > In my case, I do NOT use any AUTOINCREMENT column, so I don't have a > table *sqlite_sequence.* > * > * > For now, a workaround is ... > create a "dummy" table that contain AUTOINCREMENT and sqlite will > produce sqlite_sequence for me. > And then code-gen is working. > > > Still ask, is there another way to avoid this issue by configuration or > input parameter?? > > or AUTOINCREMENT is must for using jooq? > > thanks!! > > - Pay. > > > > > =====ERROR MESSAGE==== > SEVERE: Error while generating table zorder_option > org.jooq.exception.DataAccessException: SQL [select count(*) from > sqlite_sequence where name = ?]; [SQLITE_ERROR] SQL error or missing > database (no such table: sqlite_sequence) > at org.jooq.impl.Utils.translate(Utils.java:1078) > at > org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:462) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:302) > at > org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:339) > at > org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:330) > at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:458) > at org.jooq.impl.DefaultDSLContext.fetchOne(DefaultDSLContext.java:419) > at > org.jooq.util.sqlite.SQLiteTableDefinition.getElements0(SQLiteTableDefinition.java:77) > at > org.jooq.util.AbstractElementContainerDefinition.getElements(AbstractElementContainerDefinition.java:80) > at > org.jooq.util.AbstractTableDefinition.getColumns(AbstractTableDefinition.java:135) > at > org.jooq.util.AbstractTableDefinition.getPrimaryKey(AbstractTableDefinition.java:74) > at org.jooq.util.JavaGenerator.generateTable(JavaGenerator.java:1359) > at org.jooq.util.JavaGenerator.generateTables(JavaGenerator.java:1348) > at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:190) > at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:174) > at org.jooq.util.GenerationTool.run(GenerationTool.java:291) > at org.jooq.util.GenerationTool.main(GenerationTool.java:135) > at org.jooq.util.GenerationTool.main(GenerationTool.java:122) > Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing > database (no such table: sqlite_sequence) > at org.sqlite.DB.newSQLException(DB.java:886) > at org.sqlite.DB.newSQLException(DB.java:897) > at org.sqlite.DB.throwex(DB.java:864) > at org.sqlite.NativeDB.prepare(Native Method) > at org.sqlite.DB.prepare(DB.java:207) > at org.sqlite.PrepStmt.<init>(PrepStmt.java:50) > at org.sqlite.SQLiteConnection.prepareStatement(SQLiteConnection.java:616) > at org.sqlite.SQLiteConnection.prepareStatement(SQLiteConnection.java:606) > at org.sqlite.SQLiteConnection.prepareStatement(SQLiteConnection.java:578) > at > org.jooq.impl.ProviderEnabledConnection.prepareStatement(ProviderEnabledConnection.java:107) > at > org.jooq.impl.SettingsEnabledConnection.prepareStatement(SettingsEnabledConnection.java:71) > at org.jooq.impl.AbstractResultQuery.prepare(AbstractResultQuery.java:220) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:272) > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
