Wow, you already closed this issue, very soon, thanks:) Lukas Eder於 2013年7月5日星期五UTC+8下午3時46分35秒寫道： > > 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] <javascript:>> > >> 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] <javascript:>. >> 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.
