UltraLite Java Edition Database Load utility (uljload)

Provides the capability to load an UltraLite Java edition database from an XML source file. The XML file is often produced by the uljunload utility and is customizable.

Note

Database configuration parameters cannot be set on the command line. The uljload utility uses the default configuration when a new database is created. To create a database with different configuration parameters, such as a different page size, create the database in Java first and then use uljload -a to load the XML content into the database you created.

Syntax

uljload -c filename -p password [ options ] inputfile

Option	Description
-a	Adds information from the XML file to an existing database. If this option is not specified, a new database is created.
-c filename	Required. Specifies the name of the database file.
-d	Loads data only; ignores schema information.
-ek key	Specifies the encryption key needed to access the encrypted UltraLite Java edition database.
-f directory	Specifies the directory to retrieve data for columns larger than max blob size specified by the -b option of a uljunload operation.
-i	Inserts rows for upload synchronization.
-n	Loads schema information only; ignores row data.
-p password	Optional. Specifies the password. The default password is sql.
-q	Runs the utility in quiet mode—does not display messages.
-v	Displays verbose messages.
-y	Overwrites the output file if it exists (and the -a option is not specified).
-z pagesize	Specifies the page size, in bytes, to create the database with.
-?	Displays command line usage information.
inputfile	Specifies the input file that contains XML statements.

Example for loading blobfile types

This example assumes that you have applied the following SQL statement to your UltraLite Java edition database and unloaded the file using the UltraLite Java Edition Database Unload utility.

CREATE TABLE blobfile_example
    file_name CHAR(size) DEFAULT AUTOFILENAME( prefix, extension ),
    file_contents LONG BINARY STORE AS FILE( file_name ) CASCADE DELETE

The ulload utility, while encountering a file exported by the uljunload utility, treats the file_name column as a CHAR column and the file_contents column as a LONG BINARY column.

The uljload utility, while encountering the same XML file, reconstructs the blobfile type. The file_name column stores the string <base_dir>/<reference_to_external_file>, where <base_dir> is the exact string in the -f option, and <reference_to_external_file> is the exact string found in the file_contents column in the XML file. The newly constructed database then contains valid references to the external files.

The load fails with an error message prompting you to increase the size of the file_name column if the generated file name is too long.

Example

The -? option displays command line information.

uljload -?

When the uljload utility command line includes the -? option, the following usage information appears:

SQL Anywhere UltraLiteJ Database Load Utility
Usage: uljload [options] <XML file>
        Create and load data into a new UltraLiteJ database from <XML file>.

Options:
        -a      Add to existing database.
        -c <file> Database file.
        -d      Data only -- ignore schema.
        -ek <key> Encryption key.
        -f <directory>
                Directory for loading .File paths.
        -i      Insert rows for upload synchronization.
        -n      Schema only -- ignore data.
        -p      Password to connect to database.
        -q      Quiet: do not print messages.
        -v      Verbose messages.
        -y      Overwrite file if it already exists.
        -z <page size>
                Page size to create the database with.

Discuter à propos de cette page dans DocCommentXchange.