Hi all.
I have a big problem on my work.
First of all, the version based on my work is PostgreSQL : 8.1.11, PostGIS :
1.5.2.
The problem is I can not get the value of Point and Polygon.
The code is below :
blah blah
--------------------------------------------------------------------------------
public Test find(String Id) throws DAOException, ClassNotFoundException,
SQLException {
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:8080/testdao";
Connection conn = DriverManager.getConnection(url, admin, apple);
PreparedStatement ps = conn.prepareStatement("select name, addr,
ST_AsText(position) from listFriend where id=?");
ps.setString(1, Id);
ResultSet rs = ps.executeQuery();
//
((org.postgresql.PGConnection)conn).addDataType("point",Class.forName("org.postgis.Point"));
while(rs.next()) {
test = new Test();
p = new Point();
test.setName(rs.getString(1));
test.setAddr(rs.getString(2));
test.setPosition(p);
// System.out.println(rs.getString(3));
------------------------------------------------------------------------------------------
If I run the sentence, "System.out.println(rs.getString(3));, it works. It
prints right output like "Point(13.123 11.123)".
But I don't know how to fix test.setPosition(p);
any helps will be thank.
P.S. is it possible to be reason why the low or high version of PostgreSQL and
PostGIS?
Best Regards
Kevin Lee.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
