Sirs,
I have your trial version of the MS Access JDBC driver and am implementing it in a mobile Java environment (i.e. Creme Java VM from NSICOM - Java 1.3.1).
I have successfully implemented the driver and it is working in a desktop environment (i.e. Sun Java VM version 1.6). When I run the application and JDBC driver implementation on the mobile environment I get an out of memory exception.
Have you experienced this memory problem and if so, have a solution?
Do you have a less memory intensive version of the MS Access JDBC driver?
Thank you for your time,
Tim Valentine
Senior Mobile Systems Developer
Following is output from the VM:
NSIcom Ltd., CrEme(tm)
CrE-ME J2ME(tm)
CrE-ME V4.12 B142.190307 19-March-2007
MemoryLimit=29824Kb
EBCI(TM) Interpreter V1.00,
Copyright 1998-2002 by Bytecodes, Inc.
=>FSFrameworkBase.initParams() : NO ARGUMENTS
***: Exceed Memory Limit(29696Kb)!
current=10712Kb,
req=21044Kb
java.lang.OutOfMemoryError
and here is output from the application at the time a connection object is created:
DEBUG 20 Jan 2010 11:15:13,689 [Thread-3]=>
class = gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataManager ->
msg = FSAccessDataManager.getConnection() : mem free=452312
DEBUG 20 Jan 2010 11:15:13,736 [Thread-3]=>
class = gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataManager ->
msg = FSAccessDataManager.getConnection() : mem tot=1900544
|
|
Try maxCacheSize=16 and delayedClose=0 connection property. If you still failed, please send your mdb sample and sql sample.
|
Try maxCacheSize=16 and delayedClose=0 connection property. If you still failed, please send your mdb sample and sql sample.
I tried the above properties, also maxCacheSize=8 and maxCacheSize=4 but still got an out of memory exception (same memory size values as before). This is happening on the creation of a connection (i.e. DriverManager.getConnection(url, props)
How do I send the Access database?
=============previous message=================================
Sirs,
I have your trial version of the MS Access JDBC driver and am implementing it in a mobile Java environment (i.e. Creme Java VM from NSICOM - Java 1.3.1).
I have successfully implemented the driver and it is working in a desktop environment (i.e. Sun Java VM version 1.6). When I run the application and JDBC driver implementation on the mobile environment I get an out of memory exception.
Have you experienced this memory problem and if so, have a solution?
Do you have a less memory intensive version of the MS Access JDBC driver?
Thank you for your time,
Tim Valentine
Senior Mobile Systems Developer
Following is output from the VM:
NSIcom Ltd., CrEme(tm)
CrE-ME J2ME(tm)
CrE-ME V4.12 B142.190307 19-March-2007
MemoryLimit=29824Kb
EBCI(TM) Interpreter V1.00,
Copyright 1998-2002 by Bytecodes, Inc.
=>FSFrameworkBase.initParams() : NO ARGUMENTS
***: Exceed Memory Limit(29696Kb)!
current=10712Kb,
req=21044Kb
java.lang.OutOfMemoryError
and here is output from the application at the time a connection object is created:
DEBUG 20 Jan 2010 11:15:13,689 [Thread-3]=>
class = gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataManager ->
msg = FSAccessDataManager.getConnection() : mem free=452312
DEBUG 20 Jan 2010 11:15:13,736 [Thread-3]=>
class = gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataManager ->
msg = FSAccessDataManager.getConnection() : mem tot=1900544
|
>How do I send the Access database?
You can zip and send to webmaster or support at hxtt.com .
|
|
Please download the latest package, you can use J2ME=true connection property. Passed test with 1536kb memory limitation.
|
the new package download and property setting for J2ME=true worked. I now have the MSaccess JDBC driver working in a Creme VM (JDK 1.3.1) Personal Profile environment fully accessing an MS Access database.
Where are these connection properties documented? I could not find a mention in your documentation.
Thanks.
|
|
It's at here. J2ME is the new connection property, which hasn't been added.
|
Main
webmaster@hxtt.com