Thank you for reply. I tried with validate and empty string. Still it is dropping COM_AUDIT_TRAIL table.
On Tuesday, April 11, 2017 at 9:49:46 PM UTC+5:30, rbon wrote: > > 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] <javascript:> > > -- - 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/8f39952c-b35a-49fd-b276-65c422a400fb%40apereo.org.
