We are using the HXTT MS Access Embedded driver to build mobile applications for a U.S. Gov't customer.
Currently, we have a successful implementation of the HXTT MS Access Embedded driver for standard MS Access databases (i.e. with file extension .MDB) on mobile devices.
We now have a requirement to use an older mobile format of the MS Access database in a compacted structure (i.e. with file extension .CDB) which is produced by Microsoft ActiveSync version 4.2 and older. I tried to connect to, load, and query the MS Access compacted database and the driver failed. I set the driver property "otherExtension" to "CDB" and the driver again failed.
I suspect the HXTT MS Access Embedded driver does not have the capability to handle the MS Access compacted mobile database format and structure.
Your response and insight into this matter is greatly appreciated.
Thank you.
Following is the exception encountered when trying to connect to and use an MS Access compacted mobile database:
java.sql.SQLException: Failed to load database IMA! For more information, please use SQLException.getNextException().
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.aw.int(Unknown Source)
at com.hxtt.sql.access.aw.for(Unknown Source)
at com.hxtt.sql.access.aw.(Unknown Source)
at com.hxtt.sql.access.au.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.aw.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.bc.a(Unknown Source)
at com.hxtt.sql.access.ae.a(Unknown Source)
at com.hxtt.sql.bq.if(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.bq.a(Unknown Source)
at com.hxtt.sql.bq.a(Unknown Source)
at com.hxtt.sql.ah.a(Unknown Source)
at com.hxtt.sql.dk.executeQuery(Unknown Source)
at gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataTransactor.selectUsingParameters(FSAccessDataTransactor.java:159)
at gov.usda.fs.iweb.mobile.utils.managers.BaseDatabaseDataTransactor.processTransaction(BaseDatabaseDataTransactor.java:61)
at gov.usda.fs.iweb.mobile.utils.managers.BaseDatabaseDataManager.processEvent(BaseDatabaseDataManager.java:160)
at gov.usda.fs.iweb.mobile.framework.FSMobileFramework.processDataEvent(FSMobileFramework.java:558)
at gov.usda.fs.iweb.mobile.framework.FSMobileFramework.run(FSMobileFramework.java:390)
at java.lang.Thread.run(Thread.java:619)
DEBUG 25 May 2010 13:20:58,730 [Thread-2]=>
class = gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataTransactor ->
msg = FSAccessDataTransactor.selectUsingParameters() : SQLException : Failed to load database IMA! For more information, please use SQLException.getNextException().
DEBUG 25 May 2010 13:20:58,730 [Thread-2]=>
class = gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataTransactor ->
msg = FSAccessDataTransactor.selectUsingParameters() : SQLException.nextException : An unknown Access database file
|
>We now have a requirement to use an older mobile format of the MS Access
>database in a compacted structure (i.e. with file extension .CDB) which is
>produced by Microsoft ActiveSync version 4.2 and older.
CDB from Pocket Access is another database format.
|
I understand your response to be that "this database format is not supported with our MS Access driver". Is that correct?
|
>I understand your response to be that "this database format is not supported with
>our MS Access driver". Is that correct?
Yeah. HXTT Access supports MDB(ACCDB) format from MS Access 95~2007. But Pocket Access is another database with different format. If there're many customers need such a JDBC driver, maybe we will try to crack that format.
|