DBDictionary for SQLite

[Marc Siegel]

Hi folks,

I am trying to user OpenJPA 1.0.0 on top of SQLiteJDBC.
OpenJPA wants to insert an Id if zero for every row.

I know I need a DBDictionary subclass, I have tried making one with
  - createPrimaryKey = false
  -  lastGeneratedKeyQuery = "SELECT SEQ FROM SQLITE_SEQUENCE WHERE
NAME = \"{0}\"";

Neither of these worked. Any knowledgable suggestions?

Many thanks,
-Marc