JDBC Properties

into

<class name>

The class must implement the com.sybase.djc.sql.BlobUpdater interface.

<class name>

The class must implement the com.sybase.djc.sql.ClobUpdater interface.

[server]

If the value is server, the value of the current application server’s defaultCodeSet property is used.

Specifies how Unwired Server handles connections for a datasource at commit time, specifically when a single transaction requires data from multiple endpoints.

If you use XA, the recovery log is stored in the tx_manager datasource, and its commit protocol must be optimistic. If tx_manager is aliased to another datasource (that is, one that is defined with the aliasFor property), the commit protocol for that datasource must be optimistic. A last-resource optimization ensures full conformance with the XA specification. The commit protocol for all other datasources should be XA_2PC. Alternately, a transaction that accesses multiple datasources for which the commit protocols are optimistic is permitted.

[optimistic| pessimistic | XA_2PC]

Choose only one of these protocols:

• Optimistic – enables connections to be committed without regard for other connections enlisted in the transaction, assuming that the transaction is not marked for rollback and will successfully commit on all resources. Note: if a transaction accesses multiple data sources with commit protocol of "optimistic", atomicity is not guaranteed.
• Pessimistic – specifies that you do not expect any multi-resource transactions. An exception will be thrown (and transaction rolled back) if any attempt is made to use more than one "pessimistic" data source in the same transaction.
• XA_2PC – specifies use of the XA two phase commit protocol. If you are using two phase commit, then the recovery log is stored in the "tx_manager" data source, and that data source (or the one it is aliased to) must have the commit protocol of "optimistic" or "pessimistic". All other data sources for which atomicity must be ensured should have the "XA_2PC" commit protocol.

Sets the class that implements the JDBC datasource.

Use this property (along with the driverClass property) only if you do not have a predefined database-type entry in Unwired Server for the kind of SQL database you are connecting to. For example, you must use this property for MySQL database connections.

You can implement a datasource class to work with a distributed transaction environment. Because Unwired Server supports distributed transactions, some datasources may require that a datasource class be implemented for Unwired Server to interact with it.

For two-phase transactions, use the xaDataSourceClass connection property instead.

<com.mydatasource.jdbc.Driver>

Echoes a database command to both the console window and the server log file.

Use this property to immediately see and record the status or outcome of database commands.

When you enable this property, Unwired Server echoes every SQL query to ml.log, which may help you debug your application.

[true|false]

Set a value of 1 to echo the database commands like databaseStartCommand, and databaseStopCommand.

Otherwise, do not set this property, or use a value of 0 to disable the echo.

<command>

Example: <UnwiredPlatform_InstallDir>\Servers\SQLAnywhere11\BIN32\dbinit -q ${databaseFile}

Indicates the database file to load when connecting to a datasource.

Use this property when the path to the database file differs from the one normally used by the database server.

If the database you want to connect to is already running, use the databaseName connection parameter.

<string>

Supply a complete path and file name. The database file you specify must be on the same host as the server.

Identifies a loaded database with which to establish a connection, when connecting to a datasource.

Set a database name, so you can refer to the database by name in other property definitions for a datasource.

If the database to connect to is not already running, use the databaseFile connection parameter so the database can be started.

[DBN|default]

If you set this property to default, the name is obtained from the DBN option set by the database administrator.

If no value is used, the database name is inherited from the database type.

<command>

Example: <UnwiredPlatform_InstallDir>\Servers\SQLAnywhere11\BIN32\dbsrv11.exe

<command>

For a Adaptive Server® Anywhere database, where the user name and password are the defaults (dba and sql), enter:

<UnwiredPlatform_InstallDir>\Servers\SQLAnywhere11\BIN32\dbsrv11.exe

Sets the JDBC URL for connecting to the database if the datasource requires an Internet connection.

Typically, the server attempts to construct the database URL from the various connection properties you specify (for example, portNumber, databaseName). However, because some drivers require a special or unique URL syntax, this property allows you to override the server defaults and instead provide explicit values for this URL.

<JDBCurl>

The database URL is JDBC driver vendor-specific. For details, refer to the driver vendor's JDBC documentation.

[true|false]

The default is false.

[true|false]

The default is true.

[true|false]

The default is false.

Sets the name of the class that implements the JDBC driver.

Use this property (along with the dataSourceClass property) only if you do not have a predefined database-type entry in Unwired Server for the kind of SQL database you are connecting to. For example, MySQL database connections require you to use this connection property.

To create a connection to a database system, you must use the compatible JDBC driver classes. Sybase does not provide these classes; you must obtain them from the database manufacturer.

<Class.forName("foo.bar.Driver")>

Replace <Class.forName("foo.bar.Driver")> with the name of your driver.

[true|false]

Set to true to enable debugging, or false to disable.

[default|<setting>]

The default is STATIC:ALL.

A valid SQL query.

The default is select getdate().

Sets the initial number of connections in the pool for a datasource.

In general, holding a connection causes a less dramatic performance impact than creating a new connection. Keep your pool size large enough for the number of concurrent requests you have; ideally, your connection pool size should ensure that you never run out of available connections.

The initialPoolSize value is applied to the next time you start Unwired Server.

<int>

Replace <int> with an integer to preallocate and open the specified number of connections at start-up. The default is 0.

Sybase suggests that you start with 0, and create additional connections as necessary. The value you choose allows you to create additional connections before client synchronization requires the server to create them.

Specifies whether the driver file downloaded from jdbcDriverDownloadURL is in .ZIP format.

This property is ignored if the value of jdbcDriverDownloadURL connection is an empty string.

[True|False]

The default is false. The file is copied, but not zipped to <UnwiredPlatform-install>\lib\jdbc.

Set isDownloadZipped to true to save the file to <UnwiredPlatform-install>\lib\jdbc and unzip the archived copy.

[True|False]

The default is false.

This property is for Sybase ASA or Sybase ASE databases only.

As above, this property is used for the jConnect driver. You can force jConnect to follow the standard JDBC behavior for isClosed() by setting the IS_CLOSED_TEST connection property to the special value 'INTERNAL'. The INTERNAL setting means that jConnect returns true for isClosed() only when Connection.close() has been called, or when jConnect has detected an IOException that has disabled the Connection.

You can specify a query other than sp_mda to use when isClosed() is called. For example, if you want jConnect to try select 1 when isClosed() is called, you can set the IS_CLOSED_TEST connection property to select 1.

The default is INTERNAL.

The driverType property.

For an Oracle database type, use "thin".

Specifies the URL from which you can download a database driver.

Use this property with isDownloadZipped to put the driver in an archive file before the download starts.

<URL>

Replace <URL> with the URL from which the driver can be downloaded.

A varbinary (16384) value.

For example, varbinary(255).

A varchar (16384) value.

A univarchar (16384) value.

For those interfaces that support localization, this property specifies the language to use when connecting to your target database. When you specify a value for this property, Unwired Server:

• Allocates a CS_LOCALE structure for this connection
• Sets the CS_SYB_LANG value to the language you specify
• Sets the Microsoft SQL Server CS_LOC_PROP connection property with the new locale information

Unwired Server can access Unicode data in an Adaptive Server® 12.5 or later, or in Unicode columns in Adaptive Server 12.5 or later. Unwired Server automatically converts between double-byte character set (DBCS) data and Unicode, provided that the Language and CodeSet parameters are set with DBCS values.

<language>

Replace <language> with the language being used.

<int>

If the value is 0, idle connections remain in the pool until the server shuts down. The default is 60.

Sets the maximum number of connections allocated to the pool for this datasource.

Increase the maxPoolSize property value when you have a large user base. To determine whether a value is high enough, look for ResourceMonitorTimeoutException exceptions in <hostname>-server.log. Continue increasing the value, until this exception no longer occurs.

To further reduce the likelihood of deadlocks, configure a higher value for maxWaitTime.

To control the range of the pool size, use this property with minPoolSize.

<int>

A value of 0 sets no limit to the maximum connection pool size.

<int>

The default is 60.

<int>

A value of 0 (default) sets no limit to the maximum statements.

<int>

A value of 0 (default) sets no limit to the minimum connection pool size.

Sets the protocol used for network communication with the datasource.

Use this property (along with the driverClass, and dataSourceClass properties) only if you do not have a predefined database-type entry in Unwired Server for the kind of SQL database you are connecting to. For example, you may be required to use this property for MySQL database connections.

The network protocol is JDBC driver vendor-specific. There are no predefined values.

See the driver vendor's JDBC documentation.

[default|<password>]

[True|False]

Set to true to enable, or false to disable.

[True|False]

Set to true to enable ping connections, or false to disable.

[default|<statement>]

Replace <statement> with the SQL statement identifier. The default is "select 1".

Sets the server port number where the database server listens for connection requests.

[default|<port>]

Replace <port> with the TCP/IP port number to use (that is, 1 – 65535).

If you set the value as default, the default protocol of the datasource is used.

[default|<int>]

Replace <int> with the number of bytes allowed during an update. The default is 16384.

[default|<int>]

Replace <int> with the number of bytes allowed during an update. The default is 16384.

Sets the database role that the user must have to log in to the database.

[default|<name>]

If you set this value to default, the default database role name of the datasource is used.

A template SQL statement.

For example, for a Sybase ASA database type:

${selectList}${intoClause}${fromClause} holdlock${whereClause}

A template SQL statement.

For example, for a Sybase ASA database type:

update ${mainTable} set ${touchColumn} = 1 -${touchColumn}${fromClause}${whereClause};;

${selectList}${intoClause}${fromClause}${whereClause}

A template SQL statement.

For example, for a Sybase database type:

${selectList}${intoClause}${fromClause} holdlock${whereClause}

<name>

Replace <name> with an appropriate name for the server.

Defines the service name for the datasource.

For SQL Anywhere servers, use this property to specify the database you are attaching to.

<name>

Replace <name> with an appropriate name for the service.

Establishes an effective database identity that matches the current mobile application user.

If you use this property, you must also use setSessionAuthSystemID to set the session ID.

Alternately you can pingAndSetSessionAuth if you are using this property with pingConnection. The pingAndSetSessionAuth property runs the ping and session-authorization commands in a single command batch, which may improve performance.

[true|false]

Choose a value of 1 to use an ANSI SQL set session authorization command at the start of each database transaction. Set to 0 to use session-based authorizations.

<database identity>

Replace <database identity> with the database identifier.

Sets the wait time (in seconds) before a connection problem is reported. If the start command completes successfully within this time period, no exceptions are reported in the server log.

startWait time is used only with the databaseStartCommand property.

<int>

Replace <int> with the number of seconds Unwired Server waits before reporting an error.

[default|<int>]

The default is 10 000 000.

[True|False]

Set to true to enable use of quoted identifiers, or false to disable.

[True|False]

The default is true.

[default|<user name>]

Replace <user name> with the database user name.

For DB2 and SQL Server databases, this property is user. For Informix, Oracle, and SQL Anywhere databases, this property is User.

<class name>