java.sql.SQLException: 列名无效
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5971)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1527)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)
at com.inventec.das.dao.ServicesDAO.addRecordsSet(ServicesDAO.java:213)
at com.inventec.das.dao.ServicesDAO.getAllXMLStrBySQL(ServicesDAO.java:147)
at com.inventec.das.services.Services.getAllXMLStrBySQL(Services.java:43)
at com.inventec.das.services.Services.main(Services.java:82)
com.inventec.das.exception.WebServicesException: Web services error:
Access database Error:列名无效
at com.inventec.das.dao.ServicesDAO.addRecordsSet(ServicesDAO.java:245)
at com.inventec.das.dao.ServicesDAO.getAllXMLStrBySQL(ServicesDAO.java:147)
at com.inventec.das.services.Services.getAllXMLStrBySQL(Services.java:43)
at com.inventec.das.services.Services.main(Services.java:82)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5971)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1527)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)
at com.inventec.das.dao.ServicesDAO.addRecordsSet(ServicesDAO.java:213)
at com.inventec.das.dao.ServicesDAO.getAllXMLStrBySQL(ServicesDAO.java:147)
at com.inventec.das.services.Services.getAllXMLStrBySQL(Services.java:43)
at com.inventec.das.services.Services.main(Services.java:82)
com.inventec.das.exception.WebServicesException: Web services error:
Access database Error:列名无效
at com.inventec.das.dao.ServicesDAO.addRecordsSet(ServicesDAO.java:245)
at com.inventec.das.dao.ServicesDAO.getAllXMLStrBySQL(ServicesDAO.java:147)
at com.inventec.das.services.Services.getAllXMLStrBySQL(Services.java:43)
at com.inventec.das.services.Services.main(Services.java:82)
仔细检查sql 语句,最好是输出sql 看看是否对错。
看看是不是拼写错误引起的。
求助……
提示java.sql.SQLException: 列名无效
但是打印出sql在toad里执行时没问题的