登录名或密码错误

xiaoxunv

控制台打印的sql语句：
select case when UPPER(p.sLoginName)=:name then 1 when UPPER(p.sCode)=:name then 2 else 3 end as odr , mo, mo.sFID, mo.sFName, mo.sFCode, p.* from SA_OPPerson p join SA_OPOrg mo ON p.sMainOrgID = mo where (UPPER(p.sLoginName)=:name or UPPER(p.sCode)=:name) and p.sValidState=1 order by odr



请问这是什么问题，为什么登录不进去

jishuang

看控制台完整的错误信息

xiaoxunv

完整的报错信息：
2018-08-22 10:32:52 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/SA/OPM/system/systemProcess" activity="mainActivity" name="loginAction" executeContext="" content-type="application/xml"><parameters><parameter name="lang"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">zh_CN</xbiz:simple></parameter><parameter name="loginDate"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#Date">2018-08-22</xbiz:simple></parameter><parameter name="ip"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">0:0:0:0:0:0:0:1</xbiz:simple></parameter><parameter name="name"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">system</xbiz:simple></parameter><parameter name="options"><xbiz:map xmlns:xbiz="http://www.justep.com/xbiz#"><item key="DeviceType"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">计算机</xbiz:simple></item><item key="OperatingSystem"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">WINDOWS</xbiz:simple></item></xbiz:map></parameter><parameter name="pwd"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">E10ADC3949BA59ABBE56E057F20F883E</xbiz:simple></parameter></parameters></action>
java.lang.reflect.InvocationTargetException
        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:592)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150021; 提示: 登录名或密码错误
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.throwBusinessException(Unknown Source)
        at com.justep.system.opm.OrgUtils.login(Native Method)
        at com.justep.system.opm.OrgUtils.login1(Unknown Source)
        at OPMProcedure.login(OPMProcedure.java:111)
        at OPMProcedure.login(OPMProcedure.java:96)
        ... 26 more

jishuang

数据库的密码是E10ADC3949BA59ABBE56E057F20F883E吗？

xiaoxunv

不是

jishuang

不是那密码肯定不对啊

E10ADC3949BA59ABBE56E057F20F883E是123456的md5中
数据库的明显不是

xiaoxunv

把数据库里的md5改成E10ADC3949BA59ABBE56E057F20F883E这个就好了

但是登录需要6s左右才能登进去，用的是我本地的oracle数据库，登陆过程这么慢，是因为我电脑配置低吗

jishuang

F12打开浏览器的开发人员调试工具看看network监控的请求具体哪个请求慢

xiaoxunv

就是登陆的请求慢，要查数据库嘛，是我电脑配置低，导致查询数据库慢吗

jishuang

sql语句的执行时间打出来看看
http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035