Hi all,

I am trying to use PreparedStatement to get a buffer of a geometry invoking the commands bellow

PreparedStatement st = con.prepareStatement("CREATE TABLE geom (g geometry)");
st.execute();
st = con.prepareStatement("INSERT INTO geom VALUES(GeomFromText('POINT(1 1)', 2100))");
st.execute();
st = con.prepareStatement("SELECT Buffer(t.g, ?) AS buffer, t.g AS point FROM geom AS t"); // This line throws an SQLException
st.setFloat(1, (float)1.0);
ResultSet results = st.executeQuery();

However the fifth line throws an SQLException with this message:

types geometry(0,0) and double(53,0) are not equal

Replacing the question mark with a number (e.g. 1.0) the program executes properly.

Why is this exception thrown?
Is something wrong in my code?

Thanks in advance,
George Garbis