Configuring an alternate audit database

If you plan to use an audit database other than the Alternate Control Database (ACDB), you must create a connection pool to the database, and link the default “jdbc.Audit” resource reference in com.sybase.ep.security.audit/SecureAuditWriter to the new connection pool. “jdbc.Audit” is configured by the Enterprise Portal installer by default. This procedure is necessary if you are using WebLogic with the Oracle database.

Configuring an audit database

Use the WebLogic administrator console to create a new connection pool for the audit database, and switch the connection pool from the default “sybepsecurity connpool” to the new connection pool. For example, create a connection pool named AuditingConnectionPool. See the WebLogic documentation for information and procedures for creating the connection pool.
Use the WebLogic administrator console to create a new data source, and connect the new connection pool to the new data source. For example, create a data source with the JDBCName “jdbc.Auditing,” and connect it to AuditingConnectionPool.

Modify the weblogic-ejb-jar.xml file to connect the SecureAuditWriter to the new data source as follows:

<weblogic-enterprise-bean>
  <ejb-name>Auditer</ejb-name>
  <jndi-name>com.sybase.ep.security.audit/Auditer
     </jndi-name>
</weblogic-enterprise-bean>
<weblogic-enterprise-bean>
  <ejb-name>SecureAuditWriter</ejb-name>
 <reference-descriptor>
   <resource-description>
     <res-ref-name>
     jdbc/Audit
     </res-ref-name>
     <jndi-name>
     jdbc.Auditing
     </jndi-name>
   </resource-description>
   <resource-description>
     <res-ref-name>
     jms/AuditConnectionFactory
     </res-ref-name>
     <jndi-name>
     jms.AuditConnectionFactory
     </jndi-name>
   </resource-description>
   <resource-env-description>
     <res-env-ref-name>
     jms/AuditTopic
     </res-env-ref-name>
     <jndi-name>
     jms.AuditTopic
     </jndi-name>
   </resource-env-description>
   </reference-descriptor>
</weblogic-enterprise-bean>
<weblogic-enterprise-bean>
  <ejb-name>SecureAuditWriter</ejb-name>
  <jndi-name>com.sybase.ep.security.audit/
     SecureAuditWriter</jndi-name>
</weblogic-enterprise-bean>
</weblogic-ejb-jar>