#5 并发问题

[Anonymous]

Originally created by: onekilogram

select 字段1 + '#'+字段2 from table_1

我要表达的意思是不支持并发，根本原因是 ExpressionTranslator这个类的 marksList与funcsList 是static对象，这边能优化这个地方么？

java.sql.SQLException: String index out of range: -1
at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:286)
at com.esproc.jdbc.InternalStatement$1.run(InternalStatement.java:148)
Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.AbstractStringBuilder.replace(AbstractStringBuilder.java:851)
at java.lang.StringBuffer.replace(StringBuffer.java:452)
at com.scudata.dm.query.utils.ExpressionTranslator.moveInMarks(ExpressionTranslator.java:257)
at com.scudata.dm.query.utils.ExpressionTranslator.translateExp(ExpressionTranslator.java:115)
at com.scudata.dm.query.SimpleSelect.execute(SimpleSelect.java:6298)
at com.scudata.dm.query.SimpleSelect.query(SimpleSelect.java:3007)
at com.scudata.dm.query.SimpleJoin.query(SimpleJoin.java:5129)
at com.scudata.dm.query.SimpleUnion.query(SimpleUnion.java:84)
at com.scudata.dm.query.SimpleSQL.execute(SimpleSQL.java:140)
at com.scudata.app.common.AppUtil.executeSql(AppUtil.java:198)
at com.esproc.jdbc.JDBCUtil.execute(JDBCUtil.java:398)
at com.esproc.jdbc.InternalStatement.executeJDBC(InternalStatement.java:267)
... 1 common frames omitted

[Anonymous]

Originally posted by: xjl002

我们不打算把这个“简单SQL”支持到很完善的地步。建议直接去用SPL代码，derive函数能产生新的计算列：
T(...).derive(...)

单句SPL一样可以用JDBC调用，和SQL一样简单。