德比嵌入数据库奇怪的行为，sqlsyntaxerrorexception

Question

我在一个Java项目中有一个嵌入式数据库，其中包含两个列“ tool_id”（int）和“ tool_image”（blob）的table tools_images。 我尝试通过以下代码获得斑点：

rs = stmt.executeQuery("SELECT * FROM 'TOOLS_IMAGES' WHERE 'TOOL_id' = " + id);

程序trys以这种方式获得15个不同的图像。当我运行程序时，有时会设法获得一张图像，有时甚至有时甚至六个图像，但在某一时刻，它总是在例外抛出。在那之后，它会给以下每个图像提供此例外：

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "\'TOOLS_IMAGES\'" at line 1, column 15.
Caused by: ERROR 42X01: Syntax error: Encountered "\'TOOLS_IMAGES\'" at line 1, column 15.

为什么我在SQL查询中使用使徒？我已经在没有它们的情况下尝试过了，但是在这里SQL将查询中的所有下尺寸转换为大写，并抱怨后来找不到该列-.-找不到该列。 看起来像这样：

rs = stmt.executeQuery("SELECT * FROM TOOLS_IMAGES WHERE TOOL_id = " + id);

编辑

java.sql.SQLSyntaxErrorException: Column 'TOOL_ID' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOOL_ID' is not a column in the target table.
Caused by: ERROR 42X04: Column 'TOOL_ID' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TOOL_ID' is not a column in the target table.

： 这是我用来创建表的脚本

create table TOOLS_IMAGES
(
    "TOOL_id"   INTEGER not null
        constraint TOOLS_IMAGES_PK
            primary key,
    "TOOL_mask" BLOB,
    "TOOL_img"  BLOB
);

Answer 1

尝试使用：

ResultSet rs = stm.executeQuery("SELECT * FROM TOOLS_IMAGES WHERE \"TOOL_id\" = " + 1);

如果您说：

rs = stmt.executeQuery("SELECT * FROM TOOLS_IMAGES WHERE TOOL_id = " + id);

它将由德比（Derby）进行处理：

rs = stmt.executeQuery("SELECT * FROM TOOLS_IMAGES WHERE TOOL_ID = " + id);

更多

信息访问