context.xml修改数据连接，还要清除缓存吗？

cactus78

我的数据库服务器地址变了，我记得修改数据连接 是在BeX5_V3.5\apache-tomcat\conf\context.xml，但是还是连不上数据库，好像是还要清除缓存？我记不清了。

jishuang

tomcat重启了吗？

cactus78

jishuang 发表于 2018-7-16 17:00
tomcat重启了吗？

重启了，我是直接从另一个操作系统拷贝过来的，操作系统是Win2012。我觉得应该是缓存的事，用PLSQL Developer 都能连上了。

cactus78

Caused by: com.justep.system.util.BizSystemException: 编码: JUSTEP180040; 提示:
查询用户出错
        at com.justep.system.util.BizSystemException.create(Unknown Source)
        at com.justep.system.opm.OrgUtils.select(Unknown Source)
        at com.justep.system.opm.OrgUtils.getPersonByDB(Native Method)
        at com.justep.system.opm.OrgUtils.getPerson(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:141)
        at OPMProcedure.login(OPMProcedure.java:126)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执
行KSQL出错, KSQL: 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.sLoginNa
me)=:name or UPPER(p.sCode)=:name) and p.sValidState=1 order by odr
--> sql:
--> binds: []
        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)
        ... 33 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150055; 提示: 在
模块"/system/data"下获取数据库连接出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.Transaction.getConnection(Unknown Source)
        at com.justep.system.data.Transaction.getConnection(Unknown Source)
        at com.justep.model.ModelUtils.getConnection(Unknown Source)
        ... 37 more
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create Poolabl
eConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor )
      

jishuang

报错是oracle数据库的问题，不是缓存的问题
https://blog.csdn.net/hxl122lcq/article/details/7542462

cactus78

行啦，确实是连接串的问题，原来是oracle11g，现在改成oracle12c了，SID前面必须用“/”不能用“:”了。:L

https://www.cnblogs.com/pcbaby-c ... cle12c-pdb-cdb.html

4.3  jdbc连接字符串引发问题:
l  jdbc连接cdb数据库时,url兼容2种模式:

ü  "jdbc:oracle:thin:@192.168.75.131:1521:oracle12c"

ü  "jdbc:oracle:thin:@192.168.75.131:1521/oracle12c"

l  jdbc连接pdb数据库时url必须使用:" jdbc:oracle:thin:@192.168.75.131:1521/oracle12c"格式,若使用传统格式" jdbc:oracle:thin:@192.168.75.131:1521:oracle12c"则会报一下错误:

java.sql.SQLException: Listenerrefused the connection with the following error:

ORA-12505, TNS:listener does notcurrently know of SID given in connect descriptor