Hi. I'm running OpenJPA (2.1.0) with Derby database. The default dictionary doesn't have value for selecting values from sequences. So, I've added this to my persistence.xml:
<property name="openjpa.jdbc.DBDictionary" value="NextSequenceQuery="SELECT NEXT VALUE FOR {0} from SYSIBM.SYSDUMMY1""/> However, I understand that this will apply unconditionally. And if my application, packaged as it is, is ever executed under another database, the above line will override whatever is the default for the proper dictionary. So I was wondering whether it's possible to set a property like that for a specific dictionary only. I tried doing that, but it didn't work: <property name="org.apache.openjpa.jdbc.sql.DerbyDictionary" value="NextSequenceQuery="SELECT NEXT VALUE FOR {0} from SYSIBM.SYSDUMMY1""/> Thank you! Pawel.