Sequence exception on Oracle DB Lite
Hi,
I'm working on an ADF mobile client app POC project. I have a db sequence created on oracle lite via publication. I'm getting the sequence number in client app code. The sequence works fine when I first time launching the app in blackberry simulator and CUR_VALUE in table C$SEQ_CLIENTS is updated correctly. But if I exit the app and re-launch it, I'm unable to get the sequence. Below is the error in client app log.
Could anyone please help me and let me know what could cause this issue? Appreciate!
[FINE - adfnmc.model - SequenceImpl - create] Database SQLite doesn't support sequences natively; creating TableSequenceImpl for S_SIEBELMOBILE_S_ORG_EXT
[INFO - adfnmc.ui - ErrorHandlerImpl - reportException] BindingContainer: AccountPageDef, exception: oracle.adfnmc.AMCJboException
[WARNING - adfnmc.ui - ErrorHandlerImpl - reportException] [oracle.jbo.server.SequenceImpl$TableSequenceImpl.retrieveSequenceParamsFromDB]
oracle.adfnmc.AMCJboException: ADF-MNC-60109: Error retrieving sequence parameters for sequence S_SIEBELMOBILE_S_ORG_EXT
[WARNING - adfnmc.ui - ErrorHandlerImpl - reportException] oracle.adfnmc.java.sql.SQLException:
net.rim.device.api.database.DataTypeException:Datatype mismatch
[WARNING - adfnmc.ui - ErrorHandlerImpl - reportException] Unable to retrieve String at index 2
[WARNING - adfnmc.ui - ErrorHandlerImpl - reportException]
[FINE - adfnmc.ui - MessageBox - show] message=oracle.adfnmc.AMCJboException: ADF-MNC-60109: Error retrieving sequence parameters for sequence S_SIEBELMOBILE_S_ORG_EXT
[FINE - adfnmc.ui - MessageBox - show] oracle.adfnmc.java.sql.SQLException: net.rim.device.api.database.DataTypeException:Datatype mismatch
[FINE - adfnmc.ui - MessageBox - show] Unable to retrieve String at index 2