java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied

Kuali JIRA | Kyle Campos | 6 years ago
  1. 0

    DB: https://test.kuali.org/svn/student/tags/builds/perf/ks-1.1-20101216-build-2/ks-cfg-dbs/ks-rice-db/ War: http://maven.kuali.org/snapshot/org/kuali/student/web/ks-rice/1.1.0-M10-SNAPSHOT/ks-rice-1.1.0-M10-20101217.085529-34.war This is very strange. The same oracle connection info is in place in impex and ks-rice-config.xml. These settings are correct and worked fine for all previous milestones. I've tried this on 2 separate environments to make sure I wasn't crazy. One fresh setup, and the other I just replaced the wars and reimpexed. #IMPEX import.torque.database = oracle import.torque.database.driver = oracle.jdbc.OracleDriver # EC2 dbserv-1 import.torque.database.url = jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB import.torque.database.user=ks_rice import.torque.database.schema=ks_rice import.torque.database.password=ks_rice # ks-rice-config.xml <param name="datasource.url">jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB</param> <param name="datasource.username">ks_rice</param> <param name="datasource.password">ks_rice</param> <param name="datasource.driver.name">oracle.jdbc.driver.OracleDriver</param> # ks-standalone-config.xml <param name="datasource.url">jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB</param> <param name="datasource.username">ks_rice</param> <param name="datasource.password">ks_rice</param> <param name="ks.lum.datasource.url">${datasource.url}</param> <param name="ks.lum.datasource.username">ks_standalone</param> <param name="ks.lum.datasource.password">ks_standalone</param> <param name="ks.core.datasource.url">${datasource.url}</param> <param name="ks.core.datasource.username">ks_standalone</param> <param name="ks.core.datasource.password">ks_standalone</param> 1. Impex completes successfully, no problems connecting to DB and importing all the data 2. I can connect to the DB through DB Visualizer using the same connect info 3. ks-rice server starts up without any errors, appears to be running fine other than KSLAB-1706 4. Startup ks-standalone without any errors at all (it finds all of its tables with same connect info with the exception of a different schema) 5. When you attempt to login to ks-standalone and it tries to retrieve data from ks-rice it errors out saying it can't connect to oracle. Sounds like a simple configuration issue I know, but the config is correct and I can connect to the ks_rice schema fine through other means. 2010-12-17 12:33:48,986 [http-9080-1] u:/d: INFO org.apache.ojb.broker.cache.ObjectCacheFactory - New ObjectCache instance was created 2010-12-17 12:33:51,645 [http-9080-1] u:/d: ERROR org.enhydra.jdbc.xapool - Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied 2010-12-17 12:33:51,718 [http-9080-1] u:/d: ERROR org.enhydra.jdbc.xapool - Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied 2010-12-17 12:33:51,784 [http-9080-1] u:/d: ERROR org.enhydra.jdbc.xapool - GenericPool:getFromPool Error Exception in GenericPool:getFromPool java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:216) at org.kuali.rice.core.database.RiceXADataSource.getConnection(RiceXADataSource.java:54) at org.enhydra.jdbc.standard.StandardPooledConnection.<init>(StandardPooledConnection.java:65) at org.enhydra.jdbc.standard.StandardXAConnection.<init>(StandardXAConnection.java:81) at org.enhydra.jdbc.standard.StandardXADataSource.getXAConnection(StandardXADataSource.java:110) at org.enhydra.jdbc.pool.StandardXAPoolDataSource.create(StandardXAPoolDataSource.java:159) at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:251) at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:357) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:194) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210) at $Proxy94.prepareStatement(Unknown Source) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(StatementsForClassImpl.java:263) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(StatementsForClassImpl.java:171) at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:609) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:279) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:72) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:187) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:2113) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1668) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:119) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:263) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:289) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1524) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383) at org.springmodules.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:195) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.kns.dao.impl.BusinessObjectDaoOjb.findMatching(BusinessObjectDaoOjb.java:108) at org.kuali.rice.kns.dao.proxy.BusinessObjectDaoProxy.findMatching(BusinessObjectDaoProxy.java:185) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy39.findMatching(Unknown Source) at org.kuali.rice.kns.service.impl.BusinessObjectServiceImpl.findMatching(BusinessObjectServiceImpl.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy40.findMatching(Unknown Source) at org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessages(MessageServiceImpl.java:96) at org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessagesByGroups(MessageServiceImpl.java:116) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89) at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:60) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:243) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:110) at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:98) at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:423) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:178) at org.kuali.rice.ksb.messaging.servlet.CXFServletControllerAdapter.handleRequest(CXFServletControllerAdapter.java:55) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.kuali.rice.ksb.messaging.bam.BAMServerProxy.invokeInternal(BAMServerProxy.java:56) at org.kuali.rice.core.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy106.handleRequest(Unknown Source) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.kuali.rice.ksb.messaging.servlet.KSBDispatcherServlet.service(KSBDispatcherServlet.java:155) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.kns.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:169) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:204) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210) at $Proxy94.prepareStatement(Unknown Source) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(StatementsForClassImpl.java:263) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(StatementsForClassImpl.java:171) at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:609) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:279) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:72) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:187) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:2113) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1668) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:119) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:263) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:289) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1524) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383) at org.springmodules.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:195) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.kns.dao.impl.BusinessObjectDaoOjb.findMatching(BusinessObjectDaoOjb.java:108) at org.kuali.rice.kns.dao.proxy.BusinessObjectDaoProxy.findMatching(BusinessObjectDaoProxy.java:185) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy39.findMatching(Unknown Source) at org.kuali.rice.kns.service.impl.BusinessObjectServiceImpl.findMatching(BusinessObjectServiceImpl.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy40.findMatching(Unknown Source) at org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessages(MessageServiceImpl.java:96) at org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessagesByGroups(MessageServiceImpl.java:116) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89) at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:60) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:243) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:110) at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:98) at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:423) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:178) at org.kuali.rice.ksb.messaging.servlet.CXFServletControllerAdapter.handleRequest(CXFServletControllerAdapter.java:55) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.kuali.rice.ksb.messaging.bam.BAMServerProxy.invokeInternal(BAMServerProxy.java:56) at org.kuali.rice.core.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy106.handleRequest(Unknown Source) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.kuali.rice.ksb.messaging.servlet.KSBDispatcherServlet.service(KSBDispatcherServlet.java:155) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.kns.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:169) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:619) 2010-12-17 12:33:51,799 [http-9080-1] u:/d: ERROR org.apache.ojb.broker.accesslayer.StatementsForClassImpl - * Can't prepare statement: * sql statement was 'SELECT A0.ID,A0.MSG_ID,A0.LOCALE,A0.GRP_NAME,A0.MSG_VALUE,A0.OBJ_ID,A0.VER_NBR FROM KSMG_MESSAGE A0 WHERE (A0.GRP_NAME = ?) AND A0.LOCALE = ?' * Exception message is [SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied ] * Vendor error code [0] * SQL state code [null]

    Kuali JIRA | 6 years ago | Kyle Campos
    java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied
  2. 0

    DB: https://test.kuali.org/svn/student/tags/builds/perf/ks-1.1-20101216-build-2/ks-cfg-dbs/ks-rice-db/ War: http://maven.kuali.org/snapshot/org/kuali/student/web/ks-rice/1.1.0-M10-SNAPSHOT/ks-rice-1.1.0-M10-20101217.085529-34.war This is very strange. The same oracle connection info is in place in impex and ks-rice-config.xml. These settings are correct and worked fine for all previous milestones. I've tried this on 2 separate environments to make sure I wasn't crazy. One fresh setup, and the other I just replaced the wars and reimpexed. #IMPEX import.torque.database = oracle import.torque.database.driver = oracle.jdbc.OracleDriver # EC2 dbserv-1 import.torque.database.url = jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB import.torque.database.user=ks_rice import.torque.database.schema=ks_rice import.torque.database.password=ks_rice # ks-rice-config.xml <param name="datasource.url">jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB</param> <param name="datasource.username">ks_rice</param> <param name="datasource.password">ks_rice</param> <param name="datasource.driver.name">oracle.jdbc.driver.OracleDriver</param> # ks-standalone-config.xml <param name="datasource.url">jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB</param> <param name="datasource.username">ks_rice</param> <param name="datasource.password">ks_rice</param> <param name="ks.lum.datasource.url">${datasource.url}</param> <param name="ks.lum.datasource.username">ks_standalone</param> <param name="ks.lum.datasource.password">ks_standalone</param> <param name="ks.core.datasource.url">${datasource.url}</param> <param name="ks.core.datasource.username">ks_standalone</param> <param name="ks.core.datasource.password">ks_standalone</param> 1. Impex completes successfully, no problems connecting to DB and importing all the data 2. I can connect to the DB through DB Visualizer using the same connect info 3. ks-rice server starts up without any errors, appears to be running fine other than KSLAB-1706 4. Startup ks-standalone without any errors at all (it finds all of its tables with same connect info with the exception of a different schema) 5. When you attempt to login to ks-standalone and it tries to retrieve data from ks-rice it errors out saying it can't connect to oracle. Sounds like a simple configuration issue I know, but the config is correct and I can connect to the ks_rice schema fine through other means. 2010-12-17 12:33:48,986 [http-9080-1] u:/d: INFO org.apache.ojb.broker.cache.ObjectCacheFactory - New ObjectCache instance was created 2010-12-17 12:33:51,645 [http-9080-1] u:/d: ERROR org.enhydra.jdbc.xapool - Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied 2010-12-17 12:33:51,718 [http-9080-1] u:/d: ERROR org.enhydra.jdbc.xapool - Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied 2010-12-17 12:33:51,784 [http-9080-1] u:/d: ERROR org.enhydra.jdbc.xapool - GenericPool:getFromPool Error Exception in GenericPool:getFromPool java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:216) at org.kuali.rice.core.database.RiceXADataSource.getConnection(RiceXADataSource.java:54) at org.enhydra.jdbc.standard.StandardPooledConnection.<init>(StandardPooledConnection.java:65) at org.enhydra.jdbc.standard.StandardXAConnection.<init>(StandardXAConnection.java:81) at org.enhydra.jdbc.standard.StandardXADataSource.getXAConnection(StandardXADataSource.java:110) at org.enhydra.jdbc.pool.StandardXAPoolDataSource.create(StandardXAPoolDataSource.java:159) at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:251) at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:357) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:194) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210) at $Proxy94.prepareStatement(Unknown Source) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(StatementsForClassImpl.java:263) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(StatementsForClassImpl.java:171) at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:609) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:279) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:72) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:187) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:2113) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1668) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:119) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:263) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:289) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1524) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383) at org.springmodules.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:195) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.kns.dao.impl.BusinessObjectDaoOjb.findMatching(BusinessObjectDaoOjb.java:108) at org.kuali.rice.kns.dao.proxy.BusinessObjectDaoProxy.findMatching(BusinessObjectDaoProxy.java:185) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy39.findMatching(Unknown Source) at org.kuali.rice.kns.service.impl.BusinessObjectServiceImpl.findMatching(BusinessObjectServiceImpl.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy40.findMatching(Unknown Source) at org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessages(MessageServiceImpl.java:96) at org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessagesByGroups(MessageServiceImpl.java:116) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89) at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:60) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:243) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:110) at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:98) at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:423) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:178) at org.kuali.rice.ksb.messaging.servlet.CXFServletControllerAdapter.handleRequest(CXFServletControllerAdapter.java:55) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.kuali.rice.ksb.messaging.bam.BAMServerProxy.invokeInternal(BAMServerProxy.java:56) at org.kuali.rice.core.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy106.handleRequest(Unknown Source) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.kuali.rice.ksb.messaging.servlet.KSBDispatcherServlet.service(KSBDispatcherServlet.java:155) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.kns.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:169) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:204) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210) at $Proxy94.prepareStatement(Unknown Source) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(StatementsForClassImpl.java:263) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(StatementsForClassImpl.java:171) at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:609) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:279) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:72) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:187) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:2113) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1668) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:119) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:263) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:289) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1524) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383) at org.springmodules.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:195) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.kns.dao.impl.BusinessObjectDaoOjb.findMatching(BusinessObjectDaoOjb.java:108) at org.kuali.rice.kns.dao.proxy.BusinessObjectDaoProxy.findMatching(BusinessObjectDaoProxy.java:185) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy39.findMatching(Unknown Source) at org.kuali.rice.kns.service.impl.BusinessObjectServiceImpl.findMatching(BusinessObjectServiceImpl.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy40.findMatching(Unknown Source) at org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessages(MessageServiceImpl.java:96) at org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessagesByGroups(MessageServiceImpl.java:116) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89) at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:60) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:243) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:110) at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:98) at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:423) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:178) at org.kuali.rice.ksb.messaging.servlet.CXFServletControllerAdapter.handleRequest(CXFServletControllerAdapter.java:55) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.kuali.rice.ksb.messaging.bam.BAMServerProxy.invokeInternal(BAMServerProxy.java:56) at org.kuali.rice.core.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59) at $Proxy106.handleRequest(Unknown Source) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.kuali.rice.ksb.messaging.servlet.KSBDispatcherServlet.service(KSBDispatcherServlet.java:155) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.kns.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:169) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:619) 2010-12-17 12:33:51,799 [http-9080-1] u:/d: ERROR org.apache.ojb.broker.accesslayer.StatementsForClassImpl - * Can't prepare statement: * sql statement was 'SELECT A0.ID,A0.MSG_ID,A0.LOCALE,A0.GRP_NAME,A0.MSG_VALUE,A0.OBJ_ID,A0.VER_NBR FROM KSMG_MESSAGE A0 WHERE (A0.GRP_NAME = ?) AND A0.LOCALE = ?' * Exception message is [SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied ] * Vendor error code [0] * SQL state code [null]

    Kuali JIRA | 6 years ago | Kyle Campos
    java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied
  3. 0

    Io exception: Oracle Error ORA-12650 after upgrading Oracle to 12g

    Stack Overflow | 1 year ago | EGHM
    java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@test.db.my.edu:1521:sid : Io exception: Oracle Error ORA-12650
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Jetty and Oracle Configuration

    Stack Overflow | 4 years ago | ivan_drago
    java.sql.SQLException: Error trying to load driver: com.mysql.jdbc.Driver : com.mysql.jdbc.Driver
  6. 0

    Cannot get Mule ESB - Studio Artifacts

    Stack Overflow | 3 years ago | Brad Overstreet
    org.mule.common.MuleArtifactFactoryException: Error initializing

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Cannot get connection for URL jdbc:oracle:thin:@dbserv-1.ks.kuali.net:1521:KSDB : ORA-01017: invalid username/password; logon denied

      at org.enhydra.jdbc.standard.StandardDataSource.getConnection()
    2. XAPool
      StandardDataSource.getConnection
      1. org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:216)
      1 frame
    3. org.kuali.rice
      RiceXADataSource.getConnection
      1. org.kuali.rice.core.database.RiceXADataSource.getConnection(RiceXADataSource.java:54)
      1 frame
    4. XAPool
      StandardPoolDataSource.getConnection
      1. org.enhydra.jdbc.standard.StandardPooledConnection.<init>(StandardPooledConnection.java:65)
      2. org.enhydra.jdbc.standard.StandardXAConnection.<init>(StandardXAConnection.java:81)
      3. org.enhydra.jdbc.standard.StandardXADataSource.getXAConnection(StandardXADataSource.java:110)
      4. org.enhydra.jdbc.pool.StandardXAPoolDataSource.create(StandardXAPoolDataSource.java:159)
      5. org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:251)
      6. org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:357)
      7. org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:194)
      8. org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
      8 frames
    5. Spring Framework
      TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke
      1. org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
      2. org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
      2 frames
    6. Unknown
      $Proxy94.prepareStatement
      1. $Proxy94.prepareStatement(Unknown Source)
      1 frame
    7. ObJectRelationalBridge
      DelegatingPersistenceBroker.getCollectionByQuery
      1. org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(StatementsForClassImpl.java:263)
      2. org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(StatementsForClassImpl.java:171)
      3. org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:609)
      4. org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:279)
      5. org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:72)
      6. org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:187)
      7. org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
      8. org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:2113)
      9. org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1668)
      10. org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:119)
      11. org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:263)
      12. org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:289)
      13. org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1524)
      14. org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383)
      15. org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:383)
      15 frames
    8. org.springmodules.orm
      PersistenceBrokerTemplate.getCollectionByQuery
      1. org.springmodules.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:195)
      2. org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
      3. org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162)
      4. org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193)
      4 frames
    9. org.kuali.rice
      BusinessObjectDaoProxy.findMatching
      1. org.kuali.rice.kns.dao.impl.BusinessObjectDaoOjb.findMatching(BusinessObjectDaoOjb.java:108)
      2. org.kuali.rice.kns.dao.proxy.BusinessObjectDaoProxy.findMatching(BusinessObjectDaoProxy.java:185)
      2 frames
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    11. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    12. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    13. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    14. Unknown
      $Proxy39.findMatching
      1. $Proxy39.findMatching(Unknown Source)
      1 frame
    15. org.kuali.rice
      BusinessObjectServiceImpl.findMatching
      1. org.kuali.rice.kns.service.impl.BusinessObjectServiceImpl.findMatching(BusinessObjectServiceImpl.java:197)
      1 frame
    16. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    17. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
      2 frames
    18. Unknown
      $Proxy40.findMatching
      1. $Proxy40.findMatching(Unknown Source)
      1 frame
    19. org.kuali.student
      MessageServiceImpl.getMessagesByGroups
      1. org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessages(MessageServiceImpl.java:96)
      2. org.kuali.student.admin.messages.service.impl.MessageServiceImpl.getMessagesByGroups(MessageServiceImpl.java:116)
      2 frames
    20. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    21. Apache CXF Core
      AbstractInvoker.invoke
      1. org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173)
      2. org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89)
      2 frames
    22. Apache CXF Runtime JAX-WS Frontend
      JAXWSMethodInvoker.invoke
      1. org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:60)
      1 frame
    23. Apache CXF Core
      ServiceInvokerInterceptor$1.run
      1. org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)
      2. org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
      2 frames
    24. Java RT
      FutureTask.run
      1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      2. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      3. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      3 frames
    25. Apache CXF Core
      ChainInitiationObserver.onMessage
      1. org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
      2. org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)
      3. org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:243)
      4. org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:110)
      4 frames
    26. Apache CXF Runtime HTTP Transport
      ServletController.invoke
      1. org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:98)
      2. org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:423)
      3. org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:178)
      3 frames
    27. org.kuali.rice
      CXFServletControllerAdapter.handleRequest
      1. org.kuali.rice.ksb.messaging.servlet.CXFServletControllerAdapter.handleRequest(CXFServletControllerAdapter.java:55)
      1 frame
    28. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    29. org.kuali.rice
      BaseInvocationHandler.invoke
      1. org.kuali.rice.ksb.messaging.bam.BAMServerProxy.invokeInternal(BAMServerProxy.java:56)
      2. org.kuali.rice.core.proxy.BaseInvocationHandler.invoke(BaseInvocationHandler.java:59)
      2 frames
    30. Unknown
      $Proxy106.handleRequest
      1. $Proxy106.handleRequest(Unknown Source)
      1 frame
    31. Spring MVC
      FrameworkServlet.doPost
      1. org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
      2. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
      3. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
      4. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
      5. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
      5 frames
    32. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      1 frame
    33. org.kuali.rice
      KSBDispatcherServlet.service
      1. org.kuali.rice.ksb.messaging.servlet.KSBDispatcherServlet.service(KSBDispatcherServlet.java:155)
      1 frame
    34. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      1 frame
    35. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    36. org.kuali.rice
      HideWebInfFilter.doFilter
      1. org.kuali.rice.kns.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:66)
      1 frame
    37. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    38. spring-security-core
      FilterChainProxy.doFilter
      1. org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:169)
      1 frame
    39. Spring
      DelegatingFilterProxy.doFilter
      1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
      2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
      2 frames
    40. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      8 frames
    41. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      3 frames
    42. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame