Documentation Issues and Updates

Read about updates, corrections, and clarifications to the documentation released with Sybase Unwired Platform 2.0 ESD #1.

CR #Description
676285
Clarification for using Query APIs with column names and aliases.
If an alias is defined for a selected column, you must use the alias to retreive results. For example:
query.Select("m.MATERIAL as test"); 
... ... 
MaterialNumber = qrs.GetStringByName("test")
If there is no alias defined for a selected column, use the attribute name to retreive results. For example:
query.Select("m.MATERIAL"); 
... ... 
MaterialNumber = qrs.GetStringByName("MATERIAL")
674115
For large database files, BlackBerry recommends using a secure digital (SD) card instead of persistent storage.
Use this code to store the package database on the device's SD card:
getConnectionProfile().setProperty("databaseFile", "file:///SDCard/BlackBerry/documents/MyPackage1_0.ulj");
Where databaseFile is the name of the connection profile property and file:///SDCard/BlackBerry/documents/MyPackage1_0.ulj is the file path to a location on the SDCard. The path should start with file:///SDCard/ to store the database on the BlackBerry SD card. All folders in the path must exist, since they are not automatically created.
SD card recommendations
Sybase recommends that customers use industrial grade SD cards using Single Level Cell (SLC) technology. SD cards that use SLC technology are generally more reliable and faster than MLC cards, although they may be more limited in size and more expensive per unit of storage. Not all SD cards perform equally, and it is advised that customers evaluate the benchmarks available from different suppliers.
674115
Use the openConnection and closeConnection methods generated in the package database class for managing device database connections for Java, C#, and Objective-C.
  • public static void openConnection(); checks that the package database exists, creates it if it does not, and establishes a connection to the database. This method is useful when first starting the application: Since it takes a few seconds to open the database when creating the first connection, if the application starts up with a login screen and a background thread that performs the openConnection method, after logging in, the connection already exists and the database connection is immediately available to the user.
  • public static void closeConnection(); closes all open connections in the connection pool, clears the connection pool, and releases those connection resources when exiting the application.
673555
Configuring Unwired Server client user account lockout properties
  • loginFailureLockThreshold – the number of unsuccessful login attempts before a user is locked out of their account
  • loginFailureLockTimeout – the amount of time, in seconds, the user is locked out of their account after they reach the loginFailureLockThreshold
Configure these properties by adding these two lines and values to the <UnwiredPlatform_InstallDir>\UnwiredPlatform\Servers\UnwiredServer\Repository\Instance\com\sybase\djc\security\SecurityDomain\default.properties file. For example:
loginFailureLockThreshold=5 (locked out after five unsuccessful login attempts)
loginFailureLockTimeout=600 (locked out for 600 seconds)
673053
The documentation incorrectly states that the administrator account is locked out after three unsuccessful login attempts. The note in topic Sybase Unwired Platform 2.0 > Sybase Control Center for Sybase Unwired Platform > Get Started > Getting Started with Unwired Server Administration > Logging in and Starting an Unwired Server Session > Logging in to Sybase Control Center to Administer Unwired Platform is incorrect and can be ignored.
671378
Incorrect cache timeout default in the documentation. The topic System Administration > Security Administration > Security Layers > User Security Setup > Authentication > Authentication Cache Timeouts incorrectly states that the cache timeout default value is 3600 minutes (or 3 hours). The actual default value is 3600 (seconds).
671239
Sybase Unwired Platform does not support 64-bit native Windows mobile clients, but does support Windows 32-bit on Windows 64-bit (WoW64).

See the Unwired Platform Installation Guide for a complete list of supported device clients.

670560
MBO relationship validation rule change

The Unwired WorkSpace validation rule that prevents a delete operation on the parent, because the child is related with a composite operation is not necessary and has been removed. In an MBO relationship, it is valid for a customer to model a parent delete only and allow the cache refresh to remove any children.

670156
As part of a regular administrative procedure, run the packtool.exe utility to keep the system in the proper running state and to compress the ADS data file (QUEUED_MESSAGES.adm) for increased messaging client performance.

Performance may degrade over time, when a large number of initial subscriptions and synchronizations occur. Run the <UnwiredPlatform_installDir>\UnwiredPlatform\Servers\MessagingServer\Bin\packtool.exe utility from the command line periodically to compresses and reclaim unused/orphaned space in the ADS data file, which is located in the <UnwiredPlatform_installDir>\UnwiredPlatform\Servers\MessagingServer\Data\OBR directory. A size of 1341702 KB is considered normal.

Run PackTool.exe with no arguments from the bin directory on the Unwired Server node in which the database is installed. This is the same server in which Unwired Server is installed in single node environments and is the data tier in clustered environments.

Important: In a clustered environment, you must use the latest version of the packtool.exe utility. Contact Technical Support, or use the utility shipped with Sybase Unwired Platform 2.1 ESD #2 or later.
667198
When switching network types, Unwired WorkSpace is unable to connect to the predefined "My Sample Database" connection profile

By default, Adaptive Server Anywhere connection profiles use the machine name as the host property. But when you switch network types, the host may not be recognized. For example, moving a laptop from an office ethernet to an WiFi connection outside the company's firewall may prevent access to the database even if it is on the same machine as Unwired WorkSpace.

Workaround: In Unwired WorkSpace, modify the connection profile host property to indicate localhost as the Host. To verify the connection is working, click Test Connection to ping the database. You may also have to redeploy any projects that access an Unwired Server ASA database connection pool and reestablish the Unwired Server connection to the database by modifying the same property from hostname to localhost.

649885

Incorrect navigation paths in the documentation. Through the course of documentation enhancements, these navigation paths have shifted. These navigation issues will be corrected in a future version.

Workaround: Use the document title to locate the topic and search on the topic title listed.

663867
Valid, supported value range for DateTime datatypes.

When a DateTime value is stored in the database, it will only be represented accurately if it is within the range 1600-02-28 23:59:59 to 7911-01-01 00:00:00. Attempting to store dates outside this range may result in incomplete and inaccurate information.

Workaround: None