The properties that you configure on the General tab are:
Alias For To set up this data source to be an alias for another data source, enter the name of the other data source. When a data source name is specified, all other properties for this data source are ignored. Initially, each of the predefined data sources—cluster.db, JavaCache, message.db, session.db, and tx_manager—is configured as an alias for the default data source. The configuration property name is aliasFor.
Database Type The database type. Required for data sources that use the EAServer automatic persistence or stateful failover features, such as EJB CMP entity beans. This property defines database-specific information that is required by the storage component, for example, the commands to verify that a table exists and to create new tables. The configuration property name is databaseType. The predefined database types are listed in Table 4-1.
Database URL The JDBC URL for connecting to the database. The configuration property name is databaseURL. You can reference other data source properties in the URL; for example:
jdbc:sybase:Tds:${serverName}:${portNumber}
If you specify “[default]” as the URL, the value of the database property Default Database URL is used.
Database Name The name of the database for this data source. The configuration property name is databaseName. Once defined, you can refer to this as “${databaseName}” in other property definitions for this data source. If you specify “[default]” as the database name, the value of the database property Default Database Name is used.
Network Protocol The network protocol that the database server uses for network communication. The configuration property name is networkProtocol. If the value is “[default],” the Default Network Protocol database property value is used.
Server Name The name of the host where the database server is running; typically, a TCP/IP host name. The configuration property name is serverName. If you enter “[default]” as the server name, the value of the Default Server Name database property is used.
Port Number The server port number where the database server listens for connection requests; typically, a TCP/IP port number 1 – 65535. The configuration property name is portNumber. If the value is “[default],” the Default Port Number database property value is used.
User The name used (along with a password) to connect to the database identified by the server entry. The configuration property name is user.
Password The password used to connect to the database identified by the server entry. The Management Console stores passwords in encrypted form. If you define the data source password using an XML configuration script, specify “*” to avoid having plain-text passwords stored in the data source properties file. The configuration property name is password. If the value is “[default],” the Default Password database property value is used.
The Management Console does not display passwords for existing data sources. To change a password, enter the new password and click Apply.
Service Name The service name for the data source. The configuration property is serviceName.
Locale/Codeset The value of CS_SYB_CHARSET for this data source. This is currently applied only to Open Client connections with a JCM_Sybase database type. If the value is “[server],” the value of the current application server’s defaultCodeSet property is used. The configuration property name is codeSet.
Locale/Language The value of CS_SYB_LANG for this data source. This is currently applied only to Open Client connections with a JCM_Sybase database type. The configuration property name is language.
High Availability Select to initialize CTLIB connections with the CS_HAFAILOVER attribute. The configuration property name is highAvailability.
Role Name The database role that the user must have to log in to the database. The configuration property name is roleName. If the value is “[default],” the Default Role Name database property value is used—see “Database Settings tab”.
Owner Prefix The owner prefix for stored procedures and table names in this data source. A prefix is used by the EJB persistence manager and JIT driver wrappers to qualify database identifiers for stored procedures and tables. The configuration property name is ownerPrefix.
Set Session Authorization To establish an effective database identity that matches the current application server user, select to use an ANSI SQL set session authorization command at the start of each database transaction. The configuration property name is setSessionAuth.
Set Session Authorization System ID If Set Session Authorization is selected, specify the database identity to use when the application server accesses the database from a transaction that runs with “system” identity. The configuration property name is setSessionAuthSystemID.
Commit Protocol Specify how connections for this data source are handled at commit time. The configuration property name is commitProtocol:
Optimistic – enables connections to be committed without regard for other connections enlisted in the transaction, assuming the transaction is not marked for rollback and can successfully commit on all resources. This is the default.
XA_2PC – XA two-phase commit.
If you are using two-phase commit, the recovery
log is stored in the tx_manager data source, and its commit
protocol must be optimistic. If tx_manager is aliased to
another data source, the commit protocol for that data source must
be optimistic. A last-resource optimization is used to ensure
full conformance with the XA specification. The commit protocol for
all other data sources should be XA_2PC. Alternately, a
transaction that accesses multiple data sources whose commit protocols
are optimistic is permitted, but atomicity is not guaranteed.
Ping Pooled Connections Select to ping connections before attempting to reuse them from the connection pool. Selecting this option somewhat degrades performance. If transaction retry is enabled for your EJB transactions, dead database connections are discarded automatically (usually after a rollback), and you can improve performance by unselecting this property. The configuration property name is pingConnections.
Disable Prefetch Prefetch optimizes container-managed persistence by batching queries from a parent to its children, to reduce the calls from the application server to the database. The configuration property is disablePrefetch.
Disable Triggers Select to deactivate database triggers, on a per-connection basis, when the application server accesses the database. If selected, the database must support both the set triggers on and set triggers off commands. For Adaptive Server Enterprise, the data source user must have the replication_role database role.
Disabling triggers is useful when using container-managed persistence with version columns for optimistic concurrency control. Database triggers permit external updates to version columns, by non-application-server clients. Disabling triggers prevents concurrent updates to version columns, which could lead to optimistic concurrency failures, and require transaction retries. This is particularly relevant if using an isolation level of ReadCommittedWithCache, RepeatableReadWithCache, or SerializableWithCache—see ejb.isolationLevel in “Commonly configured properties” in Chapter 2, “Deploying and Configuring EJB Components,” in the EAServer Enterprise JavaBeans User’s Guide.
