Hi Gerson,
Ok... sounds like you may have just encountered a bug. Can you provide me
with a runnable test case that illustrates the issue, and i will be happy
to dig deeper.
-Justin
On Thu, Dec 1, 2011 at 6:16 PM, Gerson Galang <[email protected]>wrote:
> Hi Justin,
>
> Thanks for your email. I apologise for getting back to you only now.. I've
> been preoccupied with other stuff here at work and didn't get to test your
> suggestion until now.
>
> So I downloaded geodb-0.6 and followed the instructions they've provided
> in the wiki to create a spatial table. I also had to revert back to an
> older version of H2 (1.1.118 instead of 1.3.161) to make it compatible with
> the H2 version packaged with geodb-0.6.
>
> After going through that, I still got the same issue, CRS equals to null
> and ReferenceEnvelope with a value [0.0 : -1.0, 0.0 : -1.0]. :-(
>
> I don't think I'm doing anything wrong because when I wired the Postgis
> DataStore into my test, it just worked.
>
> Regards,
> Gerson
>
>
>
>
> On Wed, Nov 30, 2011 at 4:04 AM, Justin Deoliveira
> <[email protected]>wrote:
>
>> 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 <
>> [email protected]> wrote:
>>
>>> 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
>>>
>>>
>>
>>
>> --
>> Justin Deoliveira
>> OpenGeo - http://opengeo.org
>> Enterprise support for open source geospatial.
>>
>>
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
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
