ORA-28040: No matching authentication protocol

已于 2024-01-29 19:48:15 修改
阅读量945 收藏
点赞数
分类专栏： oracle 文章标签： oracle
于 2020-06-15 10:42:22 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/spencer_tseng/article/details/106757747
版权 
六月 15, 2020 10:34:48 上午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:rewso' did not find a matching property.
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version:        Apache Tomcat/7.0.67
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built:          Dec 7 2015 13:07:11 UTC
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number:         7.0.67.0
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name:               Windows 7
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version:            6.1
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture:          amd64
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home:             D:\Java\jdk1.8.0_45\jre
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version:           1.8.0_45-b15
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor:            Oracle Corporation
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE:         D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME:         D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:58997
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dwtp.deploy=D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\endorsed
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dfile.encoding=UTF-8
六月 15, 2020 10:34:49 上午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\Java\jdk1.8.0_45\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:\Java\jdk1.8.0_45\jre\bin;D:/Java/jdk1.6.0_43/bin/../jre/bin/server;D:/Java/jdk1.6.0_43/bin/../jre/bin;D:/Java/jdk1.6.0_43/bin/../jre/lib/amd64;D:\Java\jdk1.6.0_43\bin;D:\Java\jdk1.6.0_43\jre\bin;D:\app\Administrator\product\11.2.0\dbhome_1\bin;D:\gradle-2.10-bin\gradle-2.10/bin;D:\apache-maven-3.2.1\bin;C:\Program Files (x86)\Common Files\NetSarang;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Lenovo\Bluetooth Software\;C:\Program Files\Lenovo\Bluetooth Software\syswow64;D:\nodejs\;D:\TortoiseSVN\bin;C:\Users\Administrator.USER-20200323CP\AppData\Roaming\npm;.;;.;;D:\eclipse-jee-luna-SR2-win32-x86_64\eclipse;;.;;.
六月 15, 2020 10:34:49 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-bio-8080"]
六月 15, 2020 10:34:49 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-bio-8009"]
六月 15, 2020 10:34:49 上午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 1159 ms
六月 15, 2020 10:34:49 上午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
六月 15, 2020 10:34:49 上午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/7.0.67
六月 15, 2020 10:34:52 上午 org.apache.catalina.startup.TldConfig execute
信息: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
六月 15, 2020 10:34:52 上午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
六月 15, 2020 10:34:54 上午 org.apache.cxf.endpoint.ServerImpl initDestination
信息: Setting the server's publish address to be /RewsWebService
六月 15, 2020 10:34:55 上午 org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom
信息: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [138] milliseconds.
六月 15, 2020 10:34:55 上午 org.apache.cxf.transport.servlet.CXFServlet updateContext
信息: Load the bus with application context
10:34:55,046  INFO BusApplicationContext:383 - Refreshing org.apache.cxf.bus.spring.BusApplicationContext@4b8770b7: display name [org.apache.cxf.bus.spring.BusApplicationContext@4b8770b7]; startup date [Mon Jun 15 10:34:55 CST 2020]; parent: org.springframework.web.context.support.XmlWebApplicationContext@766bac43
六月 15, 2020 10:34:55 上午 org.apache.cxf.bus.spring.BusApplicationContext getConfigResources
信息: No cxf.xml configuration file detected, relying on defaults.
10:34:55,072  INFO BusApplicationContext:398 - Bean factory for application context [org.apache.cxf.bus.spring.BusApplicationContext@4b8770b7]: org.springframework.beans.factory.support.DefaultListableBeanFactory@5085a57b
10:34:55,073 DEBUG BusApplicationContext:402 - 0 beans defined in org.apache.cxf.bus.spring.BusApplicationContext@4b8770b7: display name [org.apache.cxf.bus.spring.BusApplicationContext@4b8770b7]; startup date [Mon Jun 15 10:34:55 CST 2020]; parent: org.springframework.web.context.support.XmlWebApplicationContext@766bac43
10:34:55,074 DEBUG BusApplicationContext:546 - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@4ebcfd48]
10:34:55,075 DEBUG BusApplicationContext:568 - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@14693ba0]
10:34:55,076 DEBUG BusApplicationContext:244 - Publishing event in context [org.apache.cxf.bus.spring.BusApplicationContext@4b8770b7]: org.springframework.context.event.ContextRefreshedEvent[source=org.apache.cxf.bus.spring.BusApplicationContext@4b8770b7: display name [org.apache.cxf.bus.spring.BusApplicationContext@4b8770b7]; startup date [Mon Jun 15 10:34:55 CST 2020]; parent: org.springframework.web.context.support.XmlWebApplicationContext@766bac43]
六月 15, 2020 10:34:55 上午 org.apache.cxf.transport.servlet.AbstractCXFServlet replaceDestinationFactory
信息: Servlet transport factory already registered 
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\docs
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\docs has finished in 47 ms
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\examples
六月 15, 2020 10:34:55 上午 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
六月 15, 2020 10:34:55 上午 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
六月 15, 2020 10:34:55 上午 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@69d70396')
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\examples has finished in 354 ms
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\host-manager
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\host-manager has finished in 76 ms
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\manager
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\manager has finished in 75 ms
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\ROOT
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory D:\eclipse-jee-luna-SR2-win32-x86_64\apache-tomcat-7.0.67\webapps\ROOT has finished in 50 ms
六月 15, 2020 10:34:55 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-bio-8080"]
六月 15, 2020 10:34:55 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-bio-8009"]
六月 15, 2020 10:34:55 上午 org.apache.catalina.startup.Catalina start
信息: Server startup in 6359 ms
10:35:11,592  INFO RewsWebServiceImpl:102 - 进入接口方法
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
六月 15, 2020 10:35:15 上午 org.apache.cxf.phase.PhaseInterceptorChain doIntercept
信息: Application has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-28040: No matching authentication protocol
)
	at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:119)
	at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.createFault(AbstractJAXWSMethodInvoker.java:83)
	at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:107)
	at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:54)
	at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:68)
	at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:56)
	at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
	at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:92)
	at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:220)
	at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:78)
	at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:92)
	at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:285)
	at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:168)
	at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:175)
	at org.apache.cxf.transport.servlet.AbstractCXFServlet.doPost(AbstractCXFServlet.java:153)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-28040: No matching authentication protocol
)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:329)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:405)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:413)
	at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:444)
	at com.skyon.rewso.dao.impl.SkyApiWsCmsDaoJdbcImpl.query(SkyApiWsCmsDaoJdbcImpl.java:23)
	at com.skyon.rewso.dao.impl.SkyApiWsCmsDaoJdbcImpl.getCust(SkyApiWsCmsDaoJdbcImpl.java:128)
	at com.skyon.rewso.service.impl.SkyApiWsCmsServiceImpl.getCust(SkyApiWsCmsServiceImpl.java:44)
	at com.skyon.rewso.webservice.impl.RewsWebServiceImpl.getResService02(RewsWebServiceImpl.java:338)
	at com.skyon.rewso.webservice.impl.RewsWebServiceImpl.operate(RewsWebServiceImpl.java:132)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:136)
	at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:82)
	... 34 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-28040: No matching authentication protocol
)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
	... 49 more
Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
	at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
	... 52 more



org.apache.cxf.interceptor.Fault: org.apache.commons.collections.map.ListOrderedMap cannot be cast to [Ljava.lang.Object;
	at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:119)
	at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.createFault(AbstractJAXWSMethodInvoker.java:83)
	at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:107)
	at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:54)
	at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:68)
	at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:56)
	at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
	at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:92)
	at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:220)
	at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:78)
	at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:92)
	at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:285)
	at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:168)
	at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:175)
	at org.apache.cxf.transport.servlet.AbstractCXFServlet.doPost(AbstractCXFServlet.java:153)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ClassCastException: org.apache.commons.collections.map.ListOrderedMap cannot be cast to [Ljava.lang.Object;
	at com.skyon.rewso.webservice.impl.RewsWebServiceImpl.getResService02(RewsWebServiceImpl.java:350)
	at com.skyon.rewso.webservice.impl.RewsWebServiceImpl.operate(RewsWebServiceImpl.java:132)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:136)
	at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:82)
	... 34 more


	public List<Object[]> query(String sql)
	{
		List<Map<String, Object>> list = getJdbcTemplate().queryForList(sql);
		
		if (list != null && list.size() > 0)
		{
			List<Object[]> listReturn = new ArrayList<Object[]>();
			
			for (int i = 0; i < list.size(); i++)
			{
				Map<String, Object> map = list.get(i);
//				HashMap<String, Object> cur = list.get(i);
				List<Object> mapValuesList = new ArrayList<Object>(map.values());
				listReturn.add(mapValuesList.toArray());
			}
			
			
			return listReturn;
		}
		else
		{
			return null;
		}
		
	}

spencer_tseng
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
[ORA-28040]No matching authentication protocol
weixin_42161494的博客
05-08 596
项目使用ojdbc14.jar连接oracle数据库，但是升级到oracle12后，出现ORA-28040的异常。解决办法是：在12c的network/admin/sqlnet.ora文件里，添加一行兼容的版本号即可。SQLNET.ALLOWED_LOGON_VERSION=8如下：# sqlnet.ora Network Configuration File: c:\app\hanch\prod...
java.sql.SQLException: ORA-28040: No matching authentication protocol 问题
ATwill的专栏
01-28 1万+
解决办法： oracle 12c   解决 需要在 E:\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora 文件中加入 SQLNET.ALLOWED_LOGON_VERSION=8 这样就解决了 ！
java.sql.SQLException: ORA-28040: 没有匹配的验证协议
ddd306的专栏
01-17 2万+
一直以来用的都是服务器上的Oracle数据库，今天改成连接本地Oracle 12c数据库是出问题了。hibernate连接Oracle12c时出现        java.sql.SQLException: ORA-28040: 没有匹配的验证协议。 通过查找资料找到了好的解决方案。不需要像网友所说的到官网上下载新的驱动来解决问题。 解决方案：      在Oracle的安装路径下找到s
关于PLSQL连接远程库时报错：ORA-28040: No matching authentication protocol 解决方案
热门推荐
qq_39751996的博客
06-07 14万+
关于PLSQL连接远程库时报错：ORA-28040:No matching authentication protocol 解决方案 问题：ORA-28040: No matching authentication protocol 说明：在配置远程连接数据库时出现ORA-28040: No matching authentication protocol 错误； 此错误表示客户端连接错误...
【故障处理】ORA-28040: No matching authentication protocol
似水流年
04-13 1万+
1.1BLOG文档结构图 1.2前言部分 1.2.1导读和注意事项 各位技术爱好者，看完本文后，你可以掌握如下的技能，也可以学到一些其它你所不知道的知识，~O(∩_∩)O~： ①告警日志中频繁出现Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter、ORA-28040: No matching authentic...
本地连接数据库时出现ORA-28040: No matching authentication protocol
及时止损_的博客
12-05 1万+
在配置本地连接数据库时出现ORA-28040: No matching authentication protocol 错误，这个错误的意思是没有匹配的认证协议
Navicat连接Oracle报错: ORA-28040 No matching authentication protocol
zhuchunyan_aijia的博客
09-30 2397
https://blog.csdn.net/wanghailong_qd/article/details/85887825 Navicat版本为12.0.29, Oracle数据库版本为12c. 新建一个数据库连接, 填写完主机, 服务, 用户名, 密码等信息后点击测试连接报错: ORA-28040 No matching authentication protocol. 错误原因就是oci....
Oracle ORA-28040 No matching authentication protocol (没有匹配的验证协议) 报错处理
运维老兵的专栏
05-09 7092
问题描述： 使用低版本客户端访问高版本的数据库，如使用11G客户端访问12C、19C库时，出现ORA-28040报错，无法登录数据库。 解决方法： 1.修改数据库端sqlnet.ora配置文件（需要重新修改用户密码生效） 修改 $ORACLE_HOME/network/admin/sqlnet.ora 文件，两种修改方法，可任选其一： a、增加一行配置如下 SQLNET.ALLOWED_LOGON_VERSION=8 b、增加两行配置如下 SQLNET.ALLOWED_LOGON_SE.
BLOG_【故障处理】Oracle_lhr_ORA-28040 No matching authentication protocol.pdf
08-08
### 故障处理：ORA-28040: No matching authentication protocol #### 1. 概述 在Oracle数据库管理中，遇到ORA-28040: No matching authentication protocol这一错误通常意味着客户端与服务器之间的认证协议不匹配...
解决：ORA-28040: No matching authentication protocol。oracle12c驱动jdbc8.jar下载，
12-04
ORA-28040: No matching authentication protocol问题需要oracle12匹配的驱动，目前使用的ojdbc6会出现此问题。用ojdbc8.jar即可解决此问题。官网下载的原版。
kettle连接oracle12C--报错ORA-28040 没有匹配的验证协议.rar
02-25
当尝试使用Kettle连接Oracle 12c时，可能会遇到错误"ORA-28040：没有匹配的验证协议"。这个错误通常意味着客户端和服务器之间的安全认证不兼容。 **ORA-28040错误的解释：** 此错误通常出现在Oracle数据库服务器...
连接Oracle数据库时报ORA-12541:TNS:无监听程序的图文解决教程
09-10
主要介绍了连接Oracle数据库时报ORA-12541:TNS:无监听程序的图文解决教程,非常不错，具有参考借鉴价值，需要的朋友可以参考下
Oracle dbca时报：ORA-12547: TNS:lost contact错误的解决
12-16
最近在工作中遇到了一个问题，错误是Oracle dbca时报错：ORA-12547: TNS:lost contact，通过查找相关的资料终于找到了解决的方法，下面分享给大家，话不多说了，来一起看看详细的介绍吧。 环境： OS:RHEL6.5 x86-...
ORA-00904: "WM_CONCAT": 标识符无效
07-05
在Oracle数据库中，"ORA-00904"是一个常见的错误代码，它表示尝试引用一个不存在或无效的标识符。在这个场景下，错误信息提到的是"WM_CONCAT"函数，这表明在Oracle 19c数据库环境中，用户尝试使用WM_CONCAT函数，但...
Oracle｜ORA-28040 低版本客户端无法连接Oracle 19C
最新发布
瑞琪姐的运维小站
07-12 3865
3、配置内容: 本地的PLSQL客户端是8.5版本，所以版本号配置为8就行。如果有不能直接vi 需要使sed -a 命令追加，否则会导致ora文件乱码。如果没有sqlnet.ora文件可以直接创建 vi sqlnet.ora。添加参数后新无需重启数据库或者监听，但是需要修改用户密码，否则会报错。1、在数据库服务器上找到sqlnet.ora文件。ORA-28040: 没有匹配的验证协议。–查询Oracle服务器端密码版本。2、如果有直接修改，没有直接创建。客户端与服务器端的密码生成版本。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值