On Tue, Nov 29, 2011 at 12:20 AM, Gerson Galang <[email protected]>wrote:
> Hi Andrea,
>
> I hacked your unit test to create the spatial table outside of the hatbox
> UI but it gave me the same output as yesterday. The ReferenceEnvelope for
> the new table is still [0.0 : -1.0, 0.0 : -1.0] even if I have a point
> inside it with the following coordinate (150, 30).
>
> Here's how I created the table
>
> create.runSafe("DROP TABLE T2; COMMIT;");
> create.runSafe("DROP TABLE T2_HATBOX; COMMIT;");
> create.runSafe("DELETE FROM geometry_columns WHERE f_table_name =
> 'T2'");
>
> String sql = "CREATE TABLE T2 (id int AUTO_INCREMENT(1) PRIMARY
> KEY, "
> + "geometry POINT, stringProperty varchar)";
> create.run(sql);
>
> sql = "CALL AddGeometryColumn('PUBLIC', 'T2', 'geometry', 4326,
> 'POINT', 2)";
> create.run(sql);
>
> sql = "INSERT INTO T2 (geometry, stringProperty) VALUES ("
> + "ST_GeomFromText('POINT(150 30)',4326), 'first');";
> create.run(sql);
>
> I can get the FeatureCollection fine. It's only the methods relating to
> the schema that are giving me null or the wrong output. Any other
> suggestions?
>
Nope, I don't actually use the H2 store, just happened to look a bit in its
sources from
time to time as I make new tests for PostGIS and Oracle (all the test suite
is shared among
the various databases).
I've cc'ed the H2 module maintainer, he might know more
Cheers
Andrea
--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-------------------------------------------------------
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
