Oracle9i Lite

2.5.1 Row-Wise Binding is Not Supported In Oracle Lite Database

Row-wise binding is not supported with the ODBC 3.5 Database driver.

2.6.1 Java Plug-ins

If you want to use Java Plug-in to run your Web-to-Go applets, then you need to convert the html pages containing the APPLET tag to have the correct settings for the plug-in. You can use the "JavaTM Plug-in Software 1.3 HTML Converter", which is part of the Java Plug-in, for this conversion.

2.6.2 Using JDBC in Web-to-Go Applets

It is recommended to have Mobile Server and Mobile Server Repository database installed on the same machine when using JDBC in Web-to-Go Applets. This way you can use the thin JDBC driver to connect to the Oracle database. The following webtogo.ora parameters need to be set:

[WEBTOGO]
APPLET_USE_THIN_JDBC=YES

[WEBTOGO]
APPLET_SUPPORT_ENABLE=YES

2.6.3 Web-to-Go Workspace Application Switcher

When using Internet Explorer 5.5, the application switcher in the Web-to-Go Workspace may not function correctly. The list of running applications may disappear before you can select one.

2.6.4 Mobile Server Character Set Conversion Behavior

In servlet programming, it is common to implement character set conversion logic in the servlet to get parameter values from the client side. Mobile Server implements automatic character set conversion, assuming that both server and client run in the same character set. Developers should not implement character set conversion code in the servlets.

2.7.1 Problems Downloading the SETUP.EXE Using Internet Explorer 5.5 Service Pack 1

If you are downloading the setup.exe program using certain versions of IE 5.5 on Windows 98/NT/2000/XP, you may experience difficulties in downloading and saving or running the setup.exe program. In order to download and run the setup.exee program, perform the following steps:

1. Click on the link for the Mobile Client setup program you wish to download.

2. The File Download dialog box appears. Choose the option:

   Open this file from its current location
   
   

3. A second File Download dialog box appears. Choose the option:

   Open this file from its current location
   
   

4. A third File Download dialog box appears. Choose the option:

   Run this file from its current location
   
   

5. A security warning dialog box appears with the following warning:

   Authenticode signature not found
   
   

6. Choose Yes to run the Mobile Client setup program.

In order to download and save the setup.exe program, perform the following steps:

1. Click on the link for the Mobile Client setup program you wish to download.

2. The File Download dialog box appears. Choose the option:

   Open this file from its current location
   
   

3. A second File Download dialog box appears. Choose the option:

   Save this file to disk
   
   

4. The Save as dialog box appears. Choose the location where you want to save the file. Choose Save to save the file.

2.7.2 Browser Restart After Installing Mobile Client For Web-to-Go

The setup program for Mobile Client for Web-to-Go automatically modifies the classpath, however you must restart your browser before these changes become effective.

2.7.3 Branch Office Post-Installation Tasks on a Windows NT Terminal Server

After installing Branch Office on Windows NT Terminal Server, manually copy the odbc.ini from \document settings\your_user_name\windows\ to the windows directory after the installation. Then restart the Oracle Web-to-Go Service.

2.7.4 Accessing Mobile Client for Web-to-Go Database Using ODBC Might Fail If <webtogo> DSNentry Already Exists

Installation of Mobile Client for Web-to-Go fails if that machine already has 'webtogo' in the list of ODBC DSN. For example, this happens if the Mobile Development Kit has been installed on the same system. Check the ODBC DSN entry before installing Mobile Client for Web-to-Go and manually remove the 'webtogo' DSN entry.

2.8.1 Branch Office Installation

We do not recommend installing Branch Office on the same system with either the Mobile Server or the Mobile Development Kit.

2.8.2 Branch Office Application Packaging

When packaging a Branch Office application using the Packaging Wizard, you must select Web-to-Go as the platform type. Additionally, the Servlets, Roles, Sequences, DDL's, and Registry panels are not required.

2.8.3 Branch Office Must Restart When New Application Files Are Downloaded

The Branch Office does not automatically restart if new application files are downloaded during synchronization. After synchronization, you may see an HTML page with the following text:

Oracle9i Lite Web-to-Go
New or updated application files have been downloaded.
Please wait while Mobile Client for Web-to-Go is being restarted.

At that moment, you must manually restart the Branch Office. From the Windows NT Services Panel choose the Oracle Web-to-go service. Click Stop to stop the service, then Click Start to restart it.

Note: Branch Office is implemented as a special configuration of the Mobile Client for Web-to-Go.

3.2.1 Supported Character Sets for Database Kernels

Oracle Lite Database is NOT a NLS component. In order to reduce the kernel size, it is built for each language which supports native character sets for Windows. Which means, each language has each kernel. Here are the character sets supported by this release:

• Chinese: MS936 CodePage (Simplified Chinese GBK, ZHS)

• Taiwanese: MS950 CodePage (Traditional Chinese BIG5, ZHT)

• Japanese: MS932 CodePage (Japanese Shift-JIS, JA)

• Korean: MS949 CodePage (Korean, Ko)

The database kernel for each language in this list only supports its corresponding character set. Other multibyte character sets are not supported.

3.2.2 Supported Character Sets for Mobile Server

Mobile Server components, such as Mobile Sync, are NLS components. These components are built based on Java technology and support all character sets which Java technology supports. But there are some restrictions.

Multibyte characters cannot be used for Mobile Sync names and Web-to-Go user names.

When Mobile Sync synchronizes with an Oracle database which has a multibyte character set other than UTF8, the character integrity issue occurs. Mobile Sync retrieves data from the server database through Oracle 8.1.7 OCI JDBC Driver for Oracle9iAS version 1.0.2.2, and 9i for Oracle9iAS version 2.0. Character sets are converted from database character sets to UTF8 by Oracle Server's NLS functions. In the code conversion, some multibyte characters are garbled because of the difference of the character mapping. This is not a bug of Mobile Sync.

For more Information, see "Character Integrity Issues in NLS Environment" technical paper on Oracle Technology Network (technet.oracle.com) Java/SQLJ & JDBC section in Technologies category.

Some characters cannot be used for the object name in Oracle Lite database for Palm because of the difference in reserved word handling between Oracle database and Oracle Lite database for Palm.

For example, in the Orders sample application (sample11 database schema), the word 'KEY' is used as a column name of ORD_DETAIL table. However KEY is recognized as a reserved word by Oracle Lite database for Palm, which is, SQL including the KEY column causes a syntax error.

Therefore the KEY column is unable to be accessed in Palm Computing Platform.

3.2.3 NLS Parameters in POLITE.INI

In order to handle the proper language, some NLS related parameter need to be set as written in POLITE.INI. NLS related parameters are set in POLITE.INI. These parameters are set by default during installation.

3.2.4 NLS_LOCALE

Oracle Lite database refers NLS_LOCALE parameter. This parameter affects the behavior for calendar and currency unit handling and must be set in each language specific value. The actual value for NLS_LOCALE parameter are:

• For ZHS (China) : CHINESE-SIMPLIFIED

• For ZHT (Taiwan): CHINESE-TRADITIONAL

• For Ja (Japan) : JAPANESE

• For KO (Korea) : KOREAN

3.2.5 DBCharEncoding

DBCharEncoding parameter affects the code conversion behavior for Oracle Lite database and Oracle Lite JDBC Driver. This parameter must be set as follows regardless of the language.

DBCharEncoding = Native

3.2.6 NLS_DATE_FORMAT

NLS_DATE_FORMAT parameter affects the input/output format for the date. The parameter is NOT mandatory. See the Oracle9i Lite Developer's Guide for Windows32 for the date format expression.

3.3.1 Packaging Wizard of Mobile Development Kit

Some GUI parts or message strings on the Packaging Wizard screen are sometimes clipped by Packaging Wizard itself. This can be resolved by resizing the Packaging Wizards window.

3.3.2 Overlay Support For Palm Computing Platform

This release contains files for two GUI components for the Palm Computing Platform; Mobile SQL and Mobile Sync. The GUI parts for those components can be translated based on overlay technology, which is provided by Palm, Inc. This release has the following resource .prc files for Japanese market:

• msync_jpJP.prc

• msync_static_jpJP.prc

• msql_jpJP.prc

• msql_static_jpJP.prc

Because these files have only resource portions for corresponding executables (.prc), if the only the resource file is installed, it does not work at all.

In a deployment environment of the Mobile Server, Mobile Sync and its resource file are deployed together by default. However for development, users need to install both executable and resource files manually. For more information about overlay technology, see "Palm OS Programmer's Companion" distributed at http://www.palmos.com.

3.3.3 Mobile Server Code Conversion Behavior

Mobile Server performs code conversion function internally. In servlet programming, it is very common to implement code conversion logic in the servlet to get parameter values from the client side. In this release, Mobile Server does that code conversion automatically. Users do not need to implement code conversion code in the servlets. If the code conversion code is implemented, the retrieved value of the parameters will be garbled.

3.4.1 Mobile Sync User Name and Web-to-Go User Name

Multibyte characters cannot be used for Mobile Sync name and Web-to-Go user name.

3.4.2 Character Integrity Issues for Mobile Server Replication (aka Consolidator)

When Mobile Sync synchronizes with Oracle Server database, which has multibyte character set other than UTF8, the character integrity issue occurs. Mobile Sync retrieves data from server database through Oracle 8.1.7 OCI JDBC Driver, which converts character sets from database character sets to UTF8 by Oracle Server's NLS functions. In the code conversion, some multibyte characters are garbled because of the difference of the character mapping. This is not a bug of Mobile Sync.

For more Information, see "Character Integrity Issues in NLS Environment" technical paper on Oracle Technology Network (technet.oracle.com) Java/SQLJ & JDBC section in Technologies category.

3.4.3 Sample 11 for Mobile Server Replication (aka Consolidator)

Some characters are cannot be used for the object name in Oracle Lite database for Palm because of the difference of reserved word handling between Oracle database and Oracle Lite database for Palm. For example, in the Orders sample application (sample11 database schema), the word 'KEY' is used as a column name of ORD_DETAIL table. However KEY is recognized as reserved word by Oracle Lite database for Palm, which is, SQLs including KEY column causes syntax error. Therefore the KEY column is unable to be accessed in Palm Computing Platform.

3.4.4 Mutibyte Names for odbc.txt File

When setting a multibyte name to odbc.txt for the DataDirectory parameter, add '\' or '/' to the directory name. For example:

DataDirectory=\<multi-byte name>\
DataDirectory=/<multi-byte name>/