Hi i need some help im trying to configure my audit to sql server data base on my orale is working fine but when i change the cas.properties to my sql server the log says
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'inspektrAuditEntityManagerFactory' defined in class path resource [inspektr-jdbc-audit-config.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
Caused by: org.hibernate.exception.GenericJDBCException: Unable to obtain JDBC Connection
the params on my cas.properties are this:
#cas.audit.max.agedays=
#cas.audit.database.dialect=
#cas.audit.database.batchSize=
cas.audit.database.ddl.auto=validate
cas.audit.database.gen.ddl=false
cas.audit.database.show.sql=true
cas.audit.database.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
cas.audit.database.url=jdbc:sqlserver://
172.18.141.81\DESA;databaseName=SEGURIDAD_BOLSA_EMPLEO
cas.audit.database.user=sa_desarrollo
cas.audit.database.password=EPXV5AA9BQ
#cas.audit.database.pool.minSize=
#cas.audit.database.pool.minSize=
#cas.audit.database.pool.maxSize=
#cas.audit.database.pool.maxIdleTime=
#cas.audit.database.pool.maxWait=
#cas.audit.database.pool.acquireIncrement=
#cas.audit.database.pool.acquireRetryAttempts=
#cas.audit.database.pool.acquireRetryDelay=
#cas.audit.database.pool.idleConnectionTestPeriod=
#cas.audit.database.pool.connectionHealthQuery=
cas.audit.database.dialect=org.hibernate.dialect.SQLServerDialect