数据连接能否支持中文表？

pqhuatong

BeX5和WeX5的服务数据库连接能不能支持中文表？怎么解决？

jishuang

表可以是中文的，但是BeX5中定义概念的时候不要用中文的，ksql操作的是概念，概念中不是中文一般就没问题

pqhuatong

jishuang 发表于 2016-10-20 15:34
表可以是中文的，但是BeX5中定义概念的时候不要用中文的，ksql操作的是概念，概念中不是中文一般就没问题 ...

但是我baas里面的服务文件定义数据表的时候，在w文件里面database选择数据表，运行的时候就会报错是什么情况？

jishuang

http://bbs.wex5.com/forum.php?mo ... 9&pid=165226280

pqhuatong

jishuang 发表于 2016-10-21 10:49
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=89089&pid=165226280

这个帖子等于啥也没说

jishuang

在平台提供的数据库中加一个中文表有错误吗？

pqhuatong

jishuang 发表于 2016-10-21 15:12
在平台提供的数据库中加一个中文表有错误吗？

没试过，我用的是SQlServer，eclipse应该支持中文表，这为什么不支持

jishuang

具体报错是什么？

pqhuatong

环境：BeX5 V3.6
1、通过反向生成本体生成的概念 表： JCSJ_部门编码     列： 编码、名称、备注

2、将关系标识更改为字母

3、点击完成后显示的英文

4、将关系名称重命名（但是此时左侧与右侧不同步）

5、字段映射与主键都已设置好

6、添加标准动作后
在query中的select中测试语句

报错：
内容：


2017-02-23 22:10:21 action:<?xml version="1.0" encoding="UTF-8"?>
<action xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:p="http://www.orbeon.com/oxf/pipeline" xmlns:justep="http://www.justep.com/x5#" xmlns:xslt="http://www.orbeon.com/oxf/processors" xmlns:xforms="http://www.w3.org/2002/xforms" xmlnsxf="http://www.orbeon.com/oxf/processors" xmlns:ns="http://www.justep.com/x5#" xmlns:xbiz="http://www.justep.com/xbiz#" activity="mainActivity" process="/SA/OPM/system/systemProcess" name="queryDataTestAction"><parameters><parameter name="ksql"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">select JCSJ_part.*     from JCSJ_part JCSJ_part LIMIT 0, 50</xbiz:simple></parameter><parameter name="dataModel"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">/ERP/JYGL/data</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.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: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select JCSJ_part.*     from JCSJ_part JCSJ_part LIMIT 0, 50
--> sql: SELECT  JCSJ_part.BM AS JCSJ_part, JCSJ_part.名称 AS Name, JCSJ_part.备注 AS Remark FROM JCSJ_部门编码 JCSJ_part
--> 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)
at KSQLProcedure.query(KSQLProcedure.java:17)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  JCSJ_part.BM AS JCSJ_part, JCSJ_part.名称 AS Name, JCSJ_part.备注 AS Remark FROM JCSJ_部门编码 JCSJ_part, binds: []出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 32 more
Caused by: java.sql.SQLException: 对象名 'JCSJ_部门编码' 无效。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 33 more

pqhuatong

jishuang 发表于 2016-10-21 17:23
具体报错是什么？

http://bbs.wex5.com/forum.php?mo ... 9&pid=165366664