COM_AUDIT_TRAIL Table Dropping on every start up

[shruti halgekar]

Hi,

I am working on CAS 5, whenever I start the server, COM_AUDIT_TRAIL is getting drop and its getting recreated.

Is there any way or settings in cas.properties to prevent this table from dropping and recreating on every server start up?

Hibernate: drop table COM_AUDIT_TRAIL if exists

Hibernate: create table COM_AUDIT_TRAIL (id bigint generated by default as identity (start with 1), AUD_ACTION varchar(255), APPLIC_CD varchar(255), AUD_CLIENT_IP varchar(255), AUD_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP not null, AUD_RESOURCE varchar(255), AUD_SERVER_IP varchar(255), AUD_USER varchar(255), primary key (id))

Thank you in advance.

[kjlorenzo]

Hi!

Change

cas.audit.jdbc.ddlAuto=create-drop

to

cas.audit.jdbc.ddlAuto=create

Regards

[Ray Bon]

Shruti,

After creating the tables, change to validate

cas.audit.jdbc.ddlAuto=validate

or nothing 

cas.audit.jdbc.ddlAuto=

An empty value means do nothing.

Ray

-- 
Ray Bon
Programmer analyst
Development Services, University Systems
2507128831 | CLE 023 | rb...@uvic.ca

[shruti halgekar]

Thank you for reply.

I tried with validate and empty string. Still it is dropping COM_AUDIT_TRAIL table.