org.postgresql.util.PSQLException処理記録

809 ワード

   geomtry      ,    :

String sql = "create table " + tableName + " (id Int4,geom geometry);";
Connection connection = null;
Statement statement = null;
try {  
    Class.forName(driver);
    connection = DriverManager.getConnection(url, userName, password);
    statement = connection.createStatement();
    statement.execute(sql);
    return true;
} catch (Exception e) {
    e.printStackTrace();
    return false;
} finally {
    try {
        statement.close();
        connection.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

デバッグプロセス、異常orgを報告する.postgresql.util.PSQLException : type geometry does not exist.
解決策:geometryに「public.」を付ける作成文は、String sql="create table"+tableName+"(id Int 4,geom public.geometry);;