Hi Pandu, I have also encounter a similar problem before (mine is with another database driver), and I find out that I need to include your database driver into your pom, which is also likely to be your problem.
You can try the following: - find the driver by seaching "oracle.jdbc.Oracle maven" - I find this "https://mvnrepository.com/artifact/com.oracle/ojdbc14"; - Copy one of the artifacts version into your pom.xml - Restart and see if the error is fixed Hopefully this helps you! Cheers! - Andy On Tuesday, 21 August 2018 23:49:46 UTC+8, Ranga Nadha wrote: > > Hi Everyone, > > We are using CAS 5.1.8 and I am trying to connect to the database for > authentication purpose. > > I have followed the below procedure but I am getting exceptions. > > > - Downloaded the CAS 5.1.8 > - Modify POM.xml with the following dependency > > <dependency> > <groupId>org.apereo.cas</groupId> > <artifactId>cas-server-support-jdbc</artifactId> > <version>${cas.version}</version> > <exclusions> > <exclusion> > <artifactId>log4j-slf4j-impl</artifactId> > </exclusion> > <exclusion> > <groupId>org.codehaus.groovy</groupId> > <artifactId>groovy-jsr223</artifactId> > </exclusion> > </exclusions> > </dependency> > <dependency> > <groupId>org.apereo.cas</groupId> > <artifactId>cas-server-support-jdbc-drivers</artifactId> > <version>${cas.version}</version> > </dependency> > <dependency> > <groupId>org.apereo.cas</groupId> > <artifactId>cas-server-support-jdbc-authentication</artifactId> > <version>${cas.version}</version> > </dependency> > > - Build cas project using mvn clean install. > - Take the war file and deploy in tomcat. > - In the extracted cas war. > - Go to Tomcat/webapps/cas/WEB-INF/classes/appliation.properties and > add the below properties. > > cas.authn.jdbc.query[0].sql=SELECT * FROM USERS WHERE USER_ID=? > cas.authn.jdbc.query[0].url=jdbc:oracle:thin:@xxx.xxxx.local:1521:db12c > cas.authn.jdbc.query[0].dialect=org.hibernate.dialect.Oracle12cDialect > cas.authn.jdbc.query[0].user=xxxx > cas.authn.jdbc.query[0].password=xxxx > cas.authn.jdbc.query[0].driverClass=oracle.jdbc.OracleDriver > cas.authn.jdbc.query[0].fieldPassword=PASSWORD > cas.authn.jdbc.query[0].passwordEncoder.type=DEFAULT > cas.authn.jdbc.query[0].passwordEncoder.characterEncoding=UTF-8 > cas.authn.jdbc.query[0].passwordEncoder.encodingAlgorithm=SHA1 > cas.authn.jdbc.query[0].passwordEncoder.secret= > cas.authn.jdbc.query[0].passwordEncoder.strength=16 > > > cas.authn.accept.users= > logging.level.org.apereo=DEBUG > > *I am getting the below error* > > 2018-08-21 21:00:02,828 DEBUG > [org.apereo.cas.adaptors.jdbc.config.CasJdbcAuthenticationConfiguration] - > <Created and mapped principal attributes [{givenName=givenNa > me, sn=sn, cn=commonName}] for > [jdbc:oracle:thin:@xxxx.xxxx.local:1521:dev12c]...> > 2018-08-21 21:00:02,870 ERROR [com.zaxxer.hikari.HikariConfig] - <Failed > to load class of driverClassName oracle.jdbc.OracleDriver in HikariConfig > class classloader > ParallelWebappClassLoader > context: cas > delegate: false > ----------> Parent Classloader: > java.net.URLClassLoader@13221655 > > > 2018-08-21 21:00:02,870 ERROR [org.apereo.cas.configuration.support.Beans] > - <Error creating DataSource: [Failed to load class of driverClassName > [oracle.jdbc.Oracle > Driver] in either of HikariConfig class loader or Thread context > classloader]> > > Can any one help to resolve this issue. > > Thanks in advance, > > Thanks, > Pandu Ranga T. > -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- 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/d0c43339-ce03-4141-849d-386f2da479aa%40apereo.org.
