Re: [Geotools-gt2-users] using h2 db in integration tests

[Justin D. <jde...@op...>]

Getting back a null crs from the feature type makes me thing your
geometry_columns table is out of sync... or perhaps one of the columns
(schema/table/column) might not be exactly correct.

The geotools h2 datastore uses a library called geodb [1] to encapsulate
all the spatial stuff, including hatbox. You may want to try creating your
table and adding your geometry columns with that.

[1] https://github.com/jdeolive/geodb/wiki

On Tue, Nov 29, 2011 at 5:34 AM, Andrea Aime
<and...@ge...>wrote:

> On Tue, Nov 29, 2011 at 12:20 AM, Gerson Galang <ger...@gm...>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
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.