bex5使用东方通中间件

飘零2019

在东方通配置数据库连接，测试通过。但是启动/x5/BeX5_V3.8/runtime/BusinessServer报错。在模块"/system/data"下获取数据库连接出错。请问这个应该怎么配置呢？

jishuang

看tomcat控制台完整的错误信息

飘零2019

jishuang 发表于 2020-1-7 16:05
看tomcat控制台完整的错误信息

原因：编码: JUSTEP150055; 提示: 在模块"/system/data"下获取数据库连接出错
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.system.ksql.KSQLUtils.execSysInsertOrUpdate(Unknown Source)
        at com.justep.business.server.BusinessServer.init1(Native Method)
        at com.justep.business.server.BusinessServer.init(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.init(Unknown Source)
        at com.justep.x.bs.BusinessServerServlet.init(Unknown Source)
        at com.tongweb.web.thor.core.StandardWrapper.initServlet(StandardWrapper.java:1267)
        at com.tongweb.web.thor.core.StandardWrapper.loadServlet(StandardWrapper.java:1186)
        at com.tongweb.web.thor.core.StandardWrapper.load(StandardWrapper.java:1081)
        at com.tongweb.web.thor.core.StandardContext.loadOnStartup(StandardContext.java:5090)
        at com.tongweb.web.thor.core.ThorStandardContext.startInternal(ThorStandardContext.java:380)
        at com.tongweb.web.thor.util.LifecycleBase.start(LifecycleBase.java:150)
        at com.tongweb.web.thor.core.ContainerBase.addChildInternal(ContainerBase.java:913)
        at com.tongweb.web.thor.core.ContainerBase.addChild(ContainerBase.java:889)
        at com.tongweb.web.thor.core.StandardHost.addChild(StandardHost.java:618)
        at com.tongweb.web.thor.core.ThorStandardHost.addChild(ThorStandardHost.java:584)
        at com.tongweb.web.thor.startup.ThorHostConfig.deployWar(ThorHostConfig.java:697)
        at com.tongweb.twnt.thor.ThorWebtierWebAppBuilder.fireWebtierProcess(ThorWebtierWebAppBuilder.java:2424)
        at com.tongweb.twnt.thor.ThorWebtierWebAppBuilder.deployApplication(ThorWebtierWebAppBuilder.java:2364)
        at com.tongweb.deploy.TongWebDeployer.deploy(TongWebDeployer.java:212)
        at com.tongweb.twnt.thor.TongwebLoader.deployOneThread(TongwebLoader.java:453)
        at com.tongweb.twnt.thor.TongwebLoader.initDeploy(TongwebLoader.java:403)
        at com.tongweb.twnt.thor.TongwebLoader.event(TongwebLoader.java:246)
        at com.tongweb.web.thor.startup.Tomee.n(Unknown Source)
        at com.tongweb.web.thor.startup.Tomee.start(Unknown Source)
        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:498)
        at com.tongweb.web.thor.startup.ThorBootstrap.start(ThorBootstrap.java:412)
        at com.tongweb.web.thor.startup.ThorBootstrap.main(ThorBootstrap.java:558)
Caused by: javax.naming.NameNotFoundException: Name [system] is not bound in this Context. Unable to find [system].
        at com.tongweb.web.naming.NamingContext.lookup(NamingContext.java:1018)
        at com.tongweb.web.naming.NamingContext.lookup(NamingContext.java:166)
        at com.tongweb.web.naming.NamingContext.lookup(NamingContext.java:1052)
        at com.tongweb.web.naming.NamingContext.lookup(NamingContext.java:166)
        at com.tongweb.web.naming.NamingContext.lookup(NamingContext.java:1052)
        at com.tongweb.web.naming.NamingContext.lookup(NamingContext.java:181)
        at com.tongweb.web.naming.ThorSelectorContext.lookup(ThorSelectorContext.java:82)
        at javax.naming.InitialContext.lookup(InitialContext.java:417)
        at com.justep.system.data.Transaction.getConnectionWithJndi(Unknown Source)
        ... 32 more

jishuang

Name [system] is not bound in this Context. Unable to find [system].
提示已经很明显了中间件中没有找到这个system这个数据源的配置

ecoolper

context.xml文件内容发来看看

飘零2019

ecoolper 发表于 2020-1-7 17:14
context.xml文件内容发来看看

文件

飘零2019

jishuang 发表于 2020-1-7 17:13
Name [system] is not bound in this Context. Unable to find [system].
提示已经很明显了中间件中没有找 ...

自己修改之后，报错

1. Caused by: java.lang.reflect.InvocationTargetException
   
2.         at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
   
3.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
4.         at java.lang.reflect.Method.invoke(Method.java:498)
   
5.         at com.tongweb.tongejb.resource.jdbc.managed.local.ThorManagedConnection$DelegateConnection.invoke(ThorManagedConnection.java:359)
   
6.         ... 49 more
   
7. Caused by: java.sql.SQLException: Connection has already been closed.
   
8.         at com.tongweb.web.webutil.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:130)
   
9.         at com.tongweb.web.webutil.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
   
10.         at com.tongweb.web.webutil.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:71)
    
11.         at com.tongweb.web.webutil.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
    
12.         at com.tongweb.web.webutil.jdbc.pool.TrapException.invoke(TrapException.java:41)
    
13.         at com.sun.proxy.$Proxy120.getAutoCommit(Unknown Source)
    
14.         ... 53 more
    
15. ]

复制代码

ecoolper

在 东方通 中怎么配置jndi，哪句代码是配置jndi的

飘零2019

ecoolper 发表于 2020-1-7 18:17
在 东方通 中怎么配置jndi，哪句代码是配置jndi的

<jdbc-connection-pool 开头的

jishuang

java.sql.SQLException: Connection has already been closed.这个是数据库的标准错误错误，可以咨询数据库人员