Database property-specific parameters

DatabaseImpl value = “sybase-javaprocs”

Sybase database implementation:

Sybase database implementation, with ASA data pool (op_portal_asa). The data pool is identified for each of the data services – home, auth, tools, and uwp.

<DatabaseImpl name="sybase-javaprocs" vendor="sybase">

<DatabaseService name="home" pools="op_portal_asa" balancer="com.onepage.db.UserDistrib" stored_proc_handler="com.onepage.db.JavaProcHandler" platform_handler="com.onepage.db.ASEPlatformHandler" description="service descript" />

<DatabaseService name="auth" pools="op_portal_asa" balancer="" stored_proc_handler="com.onepage.db.JavaProcHandler" platform_handler="com.onepage.db.ASEPlatformHandler" description="service descript" />

<DatabaseService name="tools" pools="op_portal_asa" balancer="" stored_proc_handler="com.onepage.db.JavaProcHandler" platform_handler="com.onepage.db.ASEPlatformHandler" description="service descript" />

<DatabaseService name="uwp" pools="op_portal_asa" balancer="" stored_proc_handler="com.onepage.db.JavaProcHandler" platform_handler="com.onepage.db.ASEPlatformHandler" description="this is for UWP connectors" />

</DatabaseImpl>

Data pool value = op_portal_asa, or op_portal_ase

ASA or Adaptive Server data pool implementation:

The default data pool implementation for Unwired Accelerator is op_portal_asa (Adaptive Server Anywhere).

Alternatively, you can use Adaptive Server Enterprise by changing all instances of “op_portal_asa” to “op_portal_ase,” and configuring the op_portal_ase data pool.

<DataPool name="op_portal_asa"      class="com.onepage.db.DbConnectionBroker"      driver="com.sybase.jdbc2.jdbc.SybDriver"      url="jdbc:sybase:Tds:hostname:port"      user="dba"      password="SQL"      password_encrypted="false"      minConnections="1"      maxConnections="50"      unusedtimer="360"      checkouttimer="60"      reuse="30"      debug="true" />

<DataPool name="op_portal_ase"      class="com.onepage.db.DbConnectionBroker"      driver="com.sybase.jdbc2.jdbc.SybDriver"      url="jdbc:sybase:Tds:hostname:port/portaldatabase?IS_CLOSED_TEST= INTERNAL"      user="sa"      password=""      password_encrypted="false"      minConnections="1"      maxConnections="50"      unusedtimer="360"      checkouttimer="60"      reuse="30"      debug="false" />

class

DbConnectionBroker

The Java class used to manage database connections. The full class name is:

com.onepage.db.DbConnectionBroker

driver

SybDriver

JDBC driver used to connect to the database. The default driver connects to the portal database. The full name is:

com.sybase.jdbc2.jdbc.SybDriver

url

ASA:

localhost:4747

Adaptive Server:

localhost:5000

Identifies the JDBC connection URL used to connect to the database. The default URL connects to the portal database. The full name is:

jdbc:sybase:Tds:localhost:4747

user

ASA:

dba

Adaptive Server:

sa

The user name for the database.

password

ASA:SQL

ASE:

" " (no password)

The password for the database.

password_encrypted

false

(true/false) Indicates whether to encrypt the database password, based on the password provided.

• If set to true, you must put the encrypted version of the password into the password property parameter in the “datapool” tag. During allocation of the data pools, the password specified is decrypted and used. See “Changing the password, and optionally the PortalDB table owner” for information about encrypting passwords.

• If set to false (or not set), the default password specified in global.properties.xml is used.

minConnections

1

Minimum database connections allowed.

maxConnections

50

Maximum database connections allowed. You may need to increase this value if you see errors in the datamanager.log file saying there are no more connections. The file is located in the default log file directory, typically, x:\tmp\logs.

unusedtimer

360

This property is not used for Unwired Accelerator; accept the default.

checkouttimer

60

Indicates how long in seconds to keep a connection open in the connection pool when it has not been used. This value enables a mechanism for shrinking the connection pool after a busy period.

reuse

30

This property is not used for Unwired Accelerator; accept the default.

debug

ASA:

true

Adaptive Server:

false

(true/false) Indicates whether to enable debugging. When set to false, debugging is turned off.