what version of cas? how are you starting up? I would suspect you really dont have correct jar in classpath or you are missing the config for it
On Thursday, May 20, 2021 at 9:21:34 AM UTC-5 shirisha wrote: > I have below DB2 JDBC jars in the classpath: > db2jcc_license_cu.jar > db2jcc_license_cisuz.jar > db2jcc.jar > db2jcc4.jar > sqljdbc4.jar > sqljdbc.jar > > Thanks, > Shireesha > > On Wednesday, May 19, 2021 at 3:56:35 PM UTC-7 richard.frovarp wrote: > >> At the very bottom it is saying it can't find the DB driver. Likely you >> don't have the DB2 JDBC driver in the classpath? >> >> On Wed, 2021-05-19 at 15:30 -0700, shirisha wrote: >> >> I have CAS doing the single sign on for our application on WAS 7.0 and >> Java 6. After migrating to the WAS 9.0 , having CAS authentication issue, >> detail of the error is below. We are using Java 8 ,WAS 9.0 , Spring, >> Hibernate, DB2 database and using JDBC locking strategy, JPA 2.0 and >> database.hibernate.dialect=org.hibernate.dialect.DB2Dialect >> >> Greatly appreciate any assistance provided for resolving the below issue. >> >> error log: [5/19/21 12:08:17:280 CDT] 000000c7 webapp E >> com.ibm.ws.webcontainer.webapp.WebApp logServletError SRVE0293E: [Servlet >> Error]-[cas]: >> org.springframework.webflow.execution.ActionExecutionException: Exception >> thrown executing [AnnotatedAction@763cfd25 targetAction = >> [EvaluateAction@904f002a expression = >> authenticationViaFormAction.submit(flowRequestContext, >> flowScope.credentials, messageContext), resultExpression = [null]], >> attributes = map[[empty]]] in state 'realSubmit' of flow 'login' -- action >> execution attributes were 'map[[empty]]' at >> org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:60) >> >> at >> org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) >> at org.springframework.webflow.engine.State.enter(State.java:194) at >> org.springframework.webflow.engine.Transition.execute(Transition.java:227) >> at >> org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) >> >> at >> org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) >> >> at >> org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) >> >> at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at >> org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) >> >> at >> org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) >> >> at >> org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230) >> at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) >> at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at >> org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259) >> >> at >> org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169) >> >> at >> org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) >> >> at >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) >> >> at >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) >> >> at >> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) >> >> at >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) >> >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at >> org.jasig.cas.web.init.SafeDispatcherServlet.service_aroundBody2(SafeDispatcherServlet.java:115) >> >> at >> org.jasig.cas.web.init.SafeDispatcherServlet.service_aroundBody3$advice(SafeDispatcherServlet.java:44) >> >> at >> org.jasig.cas.web.init.SafeDispatcherServlet.service(SafeDispatcherServlet.java:1) >> >> at >> com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1235) >> >> at >> com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779) >> >> at >> com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478) >> >> at >> com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179) >> >> at >> com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:143) >> >> at >> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:96) >> >> at >> com.github.inspektr.common.web.ClientInfoThreadLocalFilter.doFilter(ClientInfoThreadLocalFilter.java:46) >> >> at >> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197) >> >> at >> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) >> >> at >> com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:979) >> >> at >> com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1119) >> >> at >> com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:82) >> >> at >> com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:963) >> at >> com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817) >> >> at >> com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:382) >> at >> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465) >> >> at >> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:532) >> >> at >> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:318) >> >> at >> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:289) >> >> at >> com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214) >> >> at >> com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113) >> >> at >> com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175) >> >> at >> com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) >> >> at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205) >> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909) Caused by: >> org.springframework.binding.expression.EvaluationException: An >> OgnlException occurred getting the value for expression >> 'authenticationViaFormAction.submit(flowRequestContext, >> flowScope.credentials, messageContext)' on context [class >> org.springframework.webflow.engine.impl.RequestControlContextImpl] at >> org.springframework.binding.expression.ognl.OgnlExpression.getValue(OgnlExpression.java:92) >> >> at >> org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:75) >> >> at >> org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) >> >> at >> org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) >> >> at >> org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) >> >> ... 49 more Caused by: ognl.MethodFailedException: Method "submit" failed >> for object org.jasig.cas.web.flow.AuthenticationViaFormAction@2aa86b19 >> [org.springframework.transaction.CannotCreateTransactionException: Could >> not open JPA Entity Manager for transaction; nested exception is >> javax.persistence.PersistenceException: >> org.hibernate.exception.GenericJDBCException: Cannot open connection] at >> ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1265) at >> ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68) at >> ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1329) at >> ognl.ASTMethod.getValueBody(ASTMethod.java:90) at >> ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) at >> ognl.SimpleNode.getValue(SimpleNode.java:258) at >> ognl.ASTChain.getValueBody(ASTChain.java:141) at >> ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) at >> ognl.SimpleNode.getValue(SimpleNode.java:258) at >> ognl.Ognl.getValue(Ognl.java:494) at >> org.springframework.binding.expression.ognl.OgnlExpression.getValue(OgnlExpression.java:85) >> >> ... 53 more Caused by: >> org.springframework.transaction.CannotCreateTransactionException: Could not >> open JPA EntityManager for transaction; nested exception is >> javax.persistence.PersistenceException: >> org.hibernate.exception.GenericJDBCException: Cannot open connection at >> org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:382) >> >> at >> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) >> >> at >> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335) >> >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) >> >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> >> at >> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) >> >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> >> at >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) >> >> at com.sun.proxy.$Proxy67.createTicketGrantingTicket(Unknown Source) at >> org.jasig.cas.web.flow.AuthenticationViaFormAction.submit_aroundBody2(AuthenticationViaFormAction.java:85) >> >> at >> org.jasig.cas.web.flow.AuthenticationViaFormAction.submit_aroundBody3$advice(AuthenticationViaFormAction.java:44) >> >> at >> org.jasig.cas.web.flow.AuthenticationViaFormAction.submit(AuthenticationViaFormAction.java:1) >> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) >> >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) >> >> at java.lang.reflect.Method.invoke(Method.java:508) at >> ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:830) at >> ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1253) ... 63 more >> Caused by: javax.persistence.PersistenceException: >> org.hibernate.exception.GenericJDBCException: Cannot open connection at >> org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:630) >> >> at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:41) at >> org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70) >> >> at >> org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:57) >> >> at >> org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:332) >> >> ... 80 more Caused by: org.hibernate.exception.GenericJDBCException: Cannot >> open connection at >> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) >> >> at >> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) >> at >> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) >> >> at >> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) >> >> at >> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426) >> >> at >> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) >> >> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119) at >> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) at >> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326) at >> org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38) ... 83 >> more Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create >> JDBC driver of class '' for connect URL '' at >> org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452) >> >> at >> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371) >> >> at >> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) >> >> at >> org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47) >> >> at >> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423) >> >> ... 88 more Caused by: java.sql.SQLException: No suitable driver at >> java.sql.DriverManager.getDriver(DriverManager.java:326) at >> org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437) >> >> ... 92 more >> >> -- - 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/e2c27d9f-9bae-4892-b91e-960840bd1b18n%40apereo.org.
