ORA-00933 SQL命令未正确结束，但在SQL Developer中很好 [英] ORA-00933 SQL command not properly ended but good in SQL Developer

问题描述

我希望有人能够找到我的查询的问题，因为我看不到它的错误，并且Oracle SQL Developer似乎可以与Java Swing应用程序中的代码运行相同的查询.

I am hoping someone can find what is the issue with my query because I am unable to see fault in it and Oracle SQL Developer seems to run the same query as the code in my Java Swing Application just fine.

我在SQL Developer中的查询

My query in SQL Developer:

SELECT 
    ad.ID,ad.Script_Name,ad.Current_Status,
    ad.Issues_found_during_run,ad.Testers,
    ad.Run_Date,ad.Tools,u.fTag,u.role,
    dbms_lob.substr(u.avatar) 
FROM 
    allData ad 
INNER JOIN 
    users u 
ON 
    u.fTag = ad.lastUserWhoUpdated 
GROUP BY 
    ad.ID,ad.Script_Name,ad.Current_Status,
    ad.Issues_found_during_run,ad.Testers,
    ad.Run_Date,ad.Tools,u.fTag,u.role,
    dbms_lob.substr(u.avatar) 
ORDER BY 
    ad.ID ASC;

运行完美并返回我期望的所需记录.

Which run perfectly and returns the needed records I would be expecting it to.

但是，我的Java Swing应用程序中的同一查询似乎不喜欢它，因为它给了我以下错误:

However, that same query in my Java Swing App does not seem to like it as it gives me the error of:

java.sql.SQLSyntaxErrorException:ORA-00933:SQL命令未正确结束.

java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended.

我的Java Swing应用程序代码:

My Java Swing App code:

connectToDB();

String query = 
      "SELECT " + 
        "ad.ID," + 
        "ad.Script_Name," + 
        "ad.Current_Status," + 
        "ad.Issues_found_during_run," + 
        "ad.Testers," + 
        "ad.Run_Date," + 
        "ad.Tools," + 
        "u.fTag," + 
        "u.role," + 
        "dbms_lob.substr(u.avatar) " + 
      "FROM " + 
        "allData ad " + 
      "INNER JOIN " + 
        "users u " + 
      "ON " + 
        "u.fTag = ad.lastUserWhoUpdated " +
      "GROUP BY " + 
        "ad.ID," + 
        "ad.Script_Name," + 
        "ad.Current_Status," + 
        "ad.Issues_found_during_run," + 
        "ad.Testers," + 
        "ad.Run_Date," + 
        "ad.Tools," + 
        "u.fTag," + 
        "u.role," + 
        "dbms_lob.substr(u.avatar) " + 
     "ORDER BY " + 
        "ad.ID;";

ResultSet rs = statement.executeQuery(query);            
ResultSetMetaData metaData = rs.getMetaData();
etc..etc..

我对这两个表的结构是:

My structure for those 2 tables is:

SCRIPT_NAME                  VARCHAR2(100 BYTE)
CURRENT_STATUS               VARCHAR2(50 BYTE)
ISSUES_FOUND_DURING_RUN      VARCHAR2(150 BYTE)
TESTERS                      VARCHAR2(30 BYTE)
RUN_DATE                     DATE
TOOLS                        VARCHAR2(20 BYTE)
T_SUITE                      NUMBER(38,0)
NOE2                         VARCHAR2(5 BYTE)
NOE3                         VARCHAR2(5 BYTE)
ID                           NUMBER(38,0)
LASTUSERWHOUPDATED           NUMBER
DATELASTMOD                  DATE

---

FTAG                         NUMBER(38,0)   
ROLE                         VARCHAR2(15 BYTE)
AVATAR                       CLOB

那么，我可能会缺少什么?

So, what could I be missing?

推荐答案

在ad.ID之后删除分号，如下所示.你不需要

Remove semicolon after the ad.ID like below. You don't need it

"ORDER BY " + 
    "ad.ID";

这篇关于ORA-00933 SQL命令未正确结束，但在SQL Developer中很好的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！