数据库问题

zyzn123

BeX5  3.7版本
原先系统自带x5sys数据库，包含sa_opperson表。
我自己新建了一个数据库meetingarrange,并把OA中所有的数据库都新建立到meetingarrange中。

之后我开始登陆，出现
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'meetingarrange.sa_opperson' doesn't exist

问题，我的sa_opperson是在system中的，为什么提示是在'meetingarrange.中，（studio-》数据源配置）

数据源名称   数据库名称
oa                meetingArrange
system           x5sys


x5sys中才又人员表

jishuang

tomcat\conf\context.xml中的配置信息发一下看看

zyzn123

<?xml version="1.0" encoding="UTF-8"?>

<!--
  Licensed to the Apache Software Foundation (ASF) under one or more
  contributor license agreements.  See the NOTICE file distributed with
  this work for additional information regarding copyright ownership.
  The ASF licenses this file to You under the Apache License, Version 2.0
  (the "License"); you may not use this file except in compliance with
  the License.  You may obtain a copy of the License at

      http://www.apache.org/licenses/LICENSE-2.0

  Unless required by applicable law or agreed to in writing, software
  distributed under the License is distributed on an "AS IS" BASIS,
  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  See the License for the specific language governing permissions and
  limitations under the License.
-->
<!-- The contents of this file will be loaded for each web application -->
<Context>
  <!-- Default set of monitored resources -->  
  <WatchedResource>WEB-INF/web.xml</WatchedResource>  
  <!-- Uncomment this to disable session persistence across Tomcat restarts -->  
  <!--
    <Manager pathname="" />
    -->  
  <!-- Uncomment this to enable Comet connection tacking (provides events
         on session expiration as well as webapp lifecycle) -->  
  <!--
    <Valve className="org.apache.catalina.valves.CometConnectionManagerValve" />
    -->  
  <!--
        <Resource name="im" auth="Container" type="javax.sql.DataSource" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/im" username="user" password="password" maxActive="10" maxIdle="5"/>
-->  
  <Resource name="oa" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/meetingArrange" username="root" password="x5" maxActive="10" maxIdle="5"/>
  <Resource name="system" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/x5sys" username="root" password="x5" maxActive="10" maxIdle="5"/>
  <Resource name="demo" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/demo" username="root" password="x5" maxActive="10" maxIdle="5"/>
  <Resource name="doc" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/x5doc" username="root" password="x5" maxActive="10" maxIdle="5"/>
</Context>

jishuang

配置没问题，把tomcat控制台完整的错误信息发一下看看

zyzn123

2018-01-24 14:50:25 执行sql: insert into SA_Log  (sProcessName, sStatusName, sActivity, sAction, sOperatingSystem, version, SID, sProcess, sCreatorPersonName, sCreateTime, sActivityName, sActionName, sParameters, sIP, sTypeName, sDeviceType, $clientName ) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue ), binds: [系统调用, 失败, mainActivity, loginAction, WINDOWS_7, 0, 78469C26AC1A4745B64B3F9777F2BF55, /SA/OPM/system/systemProcess, zhoushanbao, 2018-01-24 14:50:25.253, 系统, 登录, ******, 0:0:0:0:0:0:0:1, 操作日志, Computer]失败
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'meetingarrange.sa_log' doesn't exist
        at sun.reflect.GeneratedConstructorAccessor68.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.Util.getInstance(Util.java:383)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at com.justep.system.interceptor.LogBefore.execSqlUpdate(Unknown Source)
        at com.justep.system.interceptor.LogBefore.loginLog(Unknown Source)
        at com.justep.system.interceptor.LogBefore.doActionLog(Unknown Source)
        at com.justep.system.interceptor.LogBefore.execute(Unknown Source)
        at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
        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:745)
zhoushanbao--------------  123456-----------  0:0:0:0:0:0:0:1 ------- zh_CN  2018-01-24  {OperatingSystem=WINDOWS_7, DeviceType=Computer}
selfCheck={OperatingSystem=WINDOWS_7, DeviceType=Computer}
selfLogin=null  0:0:0:0:0:0:0:1
传统登录方式------New---
userName=zhoushanbao   password=123456  passwordPre={SHA}
java.lang.RuntimeException: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select SA_OPPerson.sPassword,SQL.to_base64(SQL.unhex(SQL.sha1('123456'))) as newPwd from SA_OPPerson  SA_OPPerson where SA_OPPerson.sLoginName=:userName
--> sql: SELECT  SA_OPPerson.SPASSWORD AS sPassword, to_base64(unhex(sha1(?))) AS newPwd FROM SA_OPPerson SA_OPPerson  WHERE SA_OPPerson.SLOGINNAME =  ?
--> binds: [123456, zhoushanbao]
        at SelfLogin.loginCheck(SelfLogin.java:38)
        at OPMProcedure.login(OPMProcedure.java:160)
        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 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:745)

zyzn123

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select SA_OPPerson.sPassword,SQL.to_base64(SQL.unhex(SQL.sha1('123456'))) as newPwd from SA_OPPerson  SA_OPPerson where SA_OPPerson.sLoginName=:userName
--> sql: SELECT  SA_OPPerson.SPASSWORD AS sPassword, to_base64(unhex(sha1(?))) AS newPwd FROM SA_OPPerson SA_OPPerson  WHERE SA_OPPerson.SLOGINNAME =  ?
--> binds: [123456, zhoushanbao]
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at SelfLogin.loginCheck(SelfLogin.java:23)
        ... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  SA_OPPerson.SPASSWORD AS sPassword, to_base64(unhex(sha1(?))) AS newPwd FROM SA_OPPerson SA_OPPerson  WHERE SA_OPPerson.SLOGINNAME =  ? , binds: [123456, zhoushanbao]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 32 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'meetingarrange.sa_opperson' doesn't exist
        at sun.reflect.GeneratedConstructorAccessor68.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.Util.getInstance(Util.java:383)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 33 more
2018-01-24 14:50:25 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/SA/OPM/system/systemProcess" activity="mainActivity" name="loginAction" execute-context="" content-type="application/xml"><parameters><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">zhoushanbao</xbiz:simple></parameter><parameter name="options"><xbiz:map xmlns:xbiz="http://www.justep.com/xbiz#"><item key="OperatingSystem"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">WINDOWS_7</xbiz:simple></item><item key="DeviceType"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">Computer</xbiz:simple></item></xbiz:map></parameter><parameter name="loginDate"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#Date">2018-01-24</xbiz:simple></parameter><parameter name="pwd"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">123456</xbiz:simple></parameter><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></parameters></action>
java.lang.reflect.InvocationTargetException
        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 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:745)
Caused by: java.lang.RuntimeException: 用户密码错误
        at OPMProcedure.login(OPMProcedure.java:172)
        ... 26 more

zyzn123

恩，登陆方式我自定义修改过，不是账号和密码错误的问题。还是数据库找不到某个表

zyzn123

帮我远程一下吧，QQ1425077119

jishuang

/BIZ/system/data/db.config.m下配置的数据源是哪个？

zyzn123

<?xml version="1.0" encoding="utf-8"?>

<model xmlns="http://www.justep.com/model">
        <!--  
        <config name="dataSource" value="net.sourceforge.jtds.jdbc.Driver;jdbc:oracle:thin://192.168.1.19:1433/oracle73;x5_dev;1"/>
         
        <config name="dataSource" value="oracle.jdbc.driver.OracleDriver;jdbc:oracle:oci:@192.168.1.19:1521:oracle73;x5_dev;1"/>
        
        <config name="dataSource" value="oracle.jdbc.driver.OracleDriver;jdbc:oracle:thin:@192.168.1.19:1521:oracle73;x5sysinit;1"/>
        -->
        <config name="dataSource" value="java:comp/env/system"/>
</model>