inspektr-jdbc-audit-config.xml

[carlos maddaleno cuellar]

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

[Uxío]

Is the new data base being served from the same host URL and port that served the original one?

In case not, have you checked JDBC connectivity to that target destination host from the desired source host using another JDBC tool (not Apereo CAS) like a CLI client (the SQL*plus like alternative Microsoft provides for connecting to the data base they license) or the lovely SchemaSpy tool?

Hope that helped,

Sent from my iPhone

--
- 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 cas-user+u...@apereo.org.
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CANEG9%2BcvcYkq1hay-2mZcpia1y%2BOaYBuOLKLMVNWEfvE9knYbw%40mail.gmail.com.