org.postgresql.util.PSQLException処理記録
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);;