The ULjDbT utility provides the capability to transfer an UltraLiteJ database from a BlackBerry smartphone to an external device, such as a desktop, laptop, or server. In addition, you can delete a database, display database information, or view or email the database transfer log. The utility consists of two applications that must run simultaneously—the UltraLiteJ Database Transfer desktop application (ULjDbt) and the BlackBerry smartphone client application (ULjDatabaseTransfer.cod).
The desktop application receives UltraLiteJ databases using a USB or HTTP connection method. When you start the server application, it waits for a BlackBerry smartphone to transfer the database through the specified connection with the client application. The connection is closed either manually through the application interface, when the application times out, or when the transfer is complete.
The BlackBerry Smartphone client application sends UltraLiteJ databases through a USB cable or a TCP port specified to the desktop application.
In addition, you can delete a database, display database information, or view or email the database transfer log.
The client application is a signed file located in the UltraLite\UltraLiteJ\BlackBerry4.2 directory of your SQL Anywhere installation.
Load ULjDatabaseTransfer.cod from the UltraLite\UltraLiteJ\BlackBerry4.2 directory of your SQL Anywhere installation.
The client application icon appears in your list of applications.
Start the application and press the trackwheel.
On the Database Connection screen, complete the following fields:
Database Name The name of the database to transfer to the external device. If the name starts with file:// (this is case sensitive), then the client application will try to find the database in the file system; otherwise it will find the database in the object store.
Database Password The database password used to allow data transfer. If you leave Database Password blank, the default password is used.
Click Next. The Action screen appears. This is the screen from which you can access all of the client application functionality.
On the Action screen, select the desired connection method (USB or HTTP).
For a USB transfer, select USB database transfer. For an HTTP transfer, proceed to step 4.
Follow the directions to start the database transfer desktop application (see To receive a database using the UltraLiteJ Database Transfer application).
To ensure a successful database transfer, make sure that the device or simulator is connected to the BlackBerry Device Manager. For a simulator, make sure that a USB connection is simulated using USB Cable Connected.
Click Next on the client application.
On the desktop application, make sure USB is selected and click Start.
The BlackBerry smartphone starts transferring the database to the external device. Progress information is displayed on the desktop application.
Click OK on both the client and desktop applications to close them.
For an HTTP transfer, select HTTP database transfer.
On the HTTP Transfer screen, click Next.
Specify the following values:
Host The IP address of your desktop.
Port The port specified in Connection Properties on the desktop application.
URL Suffix The hostname of the server receiving the transfer, including the http:// suffix (this is required).
and click Next.
To transfer through the BES on a non-ident device, leave Suffix empty. On ident devices, use the suffix ;deviceside=false.
To transfer through Direct TCP use the suffix ;deviceside=true. Note that not all carriers support this.
The carrier's WAP gateway can be used if you know the APN information for it. You have to append that information to the suffix as well. Note that even if you are going through a BES, there may be a firewall between the BES and the machine you are running the UltraLiteJ Database Transfer utility on. In this case you need to use an SSL tunneler. On the HTTP Transfer Parms screen, specify the port and name or IP address of the SSL server running on the BES-side of the firewall. You also need to specify the port the SSL client is mapped to the transfer application.
If you are transferring a database from a BlackBerry simulator, you need to have a BlackBerry MDS simulator running or specify a URL suffix of ;deviceside=true to the UltraLiteJ Database Transfer utility running in the BlackBerry simulator.
On the desktop application, make sure HTTP is selected and click Start.
Click Next on the client application.
The BlackBerry smartphone starts transferring the database to the external device. Progress information is displayed on the desktop application.
Click OK on both the client and desktop applications to close them.
Run ULjDbTServ.cmd from the Bin32 directory of your SQL Anywhere installation.
The UltraLiteJ Database Transfer application loads.
On the Connect tab, select the desired Connection Method.
Under Connection Properties, specify the following values:
Port This field only applies to HTTP connections. Type the TCP port number that you want the BlackBerry smartphone to connect to. Usually, this port number matches the port number specified to the UltraLiteJ Database Transfer utility running on the BlackBerry device; however, if you are using SSL, then this number can be different.
BlackBerry Password This field only applies to USB connections. Type the password used to access the connected BlackBerry smartphone when it is locked. Leave this field blank if there is no password.
Timeout The number of idle minutes before the server application times out and closes the connection.
Output Specify a file name and location to which to save the transferred database.
Click Start to open a connection to the BlackBerry smartphone. The server application waits until it either times out or establishes a connection. If you have specified an existing file, you are asked whether you want to overwrite it.
The Logs tab provides details on the server status and transfer progress, including error messages.
On the Action screen, select Delete The Database.
In the confirmation window, click Delete to delete the database.
In the Database Deleted window, click OK to close the client.
On the Action screen, select View Database Info. Scroll down to view all the database information.
Click Back to return to the Action screen.
On the Database Connection screen, display the menu.
Click Log. The log screen is displayed.
To email the log file, enter the email address to send the log to and click Send Email. To return to the previous screen, press the return key.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |