在报表中找不到表

Question

Class.forName("org.hsqldb.jdbcDriver");
    conn = DriverManager.getConnection("jdbc:hsqldb:file:Pokemondaten","sa","");
    getData = conn.createStatement();
    ResultSet rs = getData.executeQuery
    ("SELECT HP FROM PKMN WHERE ID = " + basicnumber); 
    int hpp = rs.getInt(1);
    System.out.println(hpp);

我得到的都是

java.sql.SQLException: Table not found in statement [SELECT HP FROM PKMN]
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
    at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
    at pokeWpRechner.Main.main(Main.java:46)

我的数据库被称为Pokemondaten，我的表被称为PKMN，并且我的表在程序中是继承的。

我做错了什么?我不明白

Answer 1

试试下面的

conn = DriverManager.getConnection("jdbc:hsqldb:file:Pokemondaten;shutdown=true","sa","")

这样可以防止表定义丢失

Answer 2

我认为您需要在JDBC URL中提供数据库文件的完整路径:

DriverManager.getConnection("jdbc:hsqldb:file:c:mydirPokemondaten","sa","");