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 On Tue, 2017-04-11 at 03:49 -0700, kjlorenzo wrote: Hi! Change cas.audit.jdbc.ddlAuto=create-drop to cas.audit.jdbc.ddlAuto=create Regards El martes, 11 de abril de 2017, 11:11:45 (UTC+1), shruti halgekar escribió: 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. -- Ray Bon Programmer analyst Development Services, University Systems 2507128831 | CLE 023 | [email protected] -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/1491927577.22031.18.camel%40uvic.ca.
