Description:
I received these error messages for all IME at JBOSS startup:
... ERROR [ims] Invalid audit data source for IME "<IME_01>" : data source name ""
... ERROR [ims] Invalid audit data source for IME "<IME_02>" : data source name ""
... ERROR [ims] Invalid audit data source for IME "<IME_03" : data source name ""
Then I tried to make an Export/Import about Audit settings XML file for the first environment, editing the "datasource" line:
Old line: <Audit enabled="false" auditlevel="NONE" datasource="">
New line: <Audit enabled="false" auditlevel="NONE" datasource="auditDbDataSource">
but a have this new error message
... ERROR [ims] Setting up Audit DB Connection for IME "Gestione Dipendenti" failed with error "Failed to load Database driver "auditDbDataSource" with error "auditDbDataSource not bound""
Note: following the JBOSS audit database service configuration file (imauditdb-ds.xml)
...
<datasources>
<local-tx-datasource>
<jndi-name>auditDbDataSource</jndi-name>
<!-- Oracle
<connection-url>jdbc:oracle:thin:@DBMACHINENAME:1521:AUDIT_STORE</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
-->
<!-- SQL Server -->
<connection-url>jdbc:microsoft:sqlserver://###.###.###.###:1433;selectMethod=cursor;DatabaseName=IM_AUSTORE</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>im_user</user-name>
<password>*********</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
</local-tx-datasource>
</datasources>
...
Note: db login credentials (user-name/password) are correct (checked by SQL Query Analizer).
Datasource value in AuditSettings.xml should be written as "java:/auditDbDataSource" instead of "auditDbDataSource" as IMWE configuration guide v6.0 suggests.
imauditdb-ds.xml should be "...<jndi-name>auditDbDataSource</jndi-name>..." .