SQL 字段别名 报错，编码: JUSTEP150039;

icecream20000

程序源码：
public static Object getStationInfo() {

        System.out.println("getStationInfo() action in!");

        // 获取当前实时数据
        StringBuffer sqlSb = new StringBuffer();
        sqlSb.append("SELECT ");
        sqlSb.append("rps.STATION_ID AS stationId,");
        sqlSb.append("rps.PEAKPOWER AS peakpower,");
        sqlSb.append("rps.POWER AS power,");
        sqlSb.append("rps.ENERGY AS energy,");
        sqlSb.append("rps.DIOXIDE AS dioxide,");
        sqlSb.append("rps.TREES AS trees ");
        sqlSb.append("FROM ");
        sqlSb.append("Runtime_power_station rps ");
        sqlSb.append("ORDER BY ");
        sqlSb.append("rps.CREATEDATE DESC ");
        sqlSb.append("LIMIT 1");
        String strSql = sqlSb.toString();// 按时间排序曲最新数据
        
        Map<String, String> sqlmap = new HashMap<String, String>();
        sqlmap.put(DatabaseProduct.DEFAULT.toString(), strSql);
        Table tab1 = SQL.select(sqlmap, null, "/fspsm/homePage/data");


错误信息：

执行sql: SELECT rps.STATION_ID AS stationId,rps.PEAKPOWER AS peakpower,rps.POWER AS power,rps.ENERGY AS energy,rps.DIOXIDE AS dioxide,rps.TREES AS trees FROM Runtime_power_station rps ORDER BY rps.CREATEDATE DESC LIMIT 1, binds: []出错
编码：JUSTEP150039
隐藏详细
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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: 编码: JUSTEP150039; 提示: 执行sql: SELECT rps.STATION_ID AS stationId,rps.PEAKPOWER AS peakpower,rps.POWER AS power,rps.ENERGY AS energy,rps.DIOXIDE AS dioxide,rps.TREES AS trees FROM Runtime_power_station rps ORDER BY rps.CREATEDATE DESC LIMIT 1, binds: []出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.SQL.select(Unknown Source)
at com.justep.system.data.SQL.select(Unknown Source)
at HomePage.getStationInfo(HomePage.java:76)
... 27 more
Caused by: java.sql.SQLException: Column 'STATION_ID' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1073)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5212)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
... 30 more


临时解决办法：

修改数据库连接信息   BeX5_V3.3\apache-tomcat\conf.xml 增加红色字体部分
<Context>
   
  <WatchedResource>WEB-INF/web.xml</WatchedResource>  
  <Resource name="system" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://192.168.40.243: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://192.168.40.243:3306/x5demo" 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://192.168.40.243:3306/x5doc" username="root" password="x5" maxActive="10" maxIdle="5"/>
  <Resource name="fspsm" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://192.168.40.243:3306/psm?useOldAliasMetadataBehavior=true" username="root" password="x5" maxActive="10" maxIdle="5"/>
</Context>

修改完后系统运行正常，但是重启启动X5 的Studio 工具后， conf.xml 文件又还原了，问题依然存在。

jishuang

at HomePage.getStationInfo(HomePage.java:76)
... 27 more
Caused by: java.sql.SQLException: Column 'STATION_ID' not found

应该是数据库中没有找到这个字段

jishuang

mysql取别名的问题，应该是产品缺陷，我们已提交到产品组(内部编号：2016031100025)，感谢楼主的支持与配合。