hello every one,
i have come across a new type in oracle SDO_GEOMETRY in the recent past, i am using hibernate in my app.
after searching online for a lot of time i came to know hibernate-spatial.jar and jts.jar are proper jars to deal this type.
the classes i have used are
with the above mappings i am able to fetch the data without errors but not the entire data that has been inserted into the DB.
for example
INSERT INTO LINES (id,geom) VALUES (1, MDSYS.SDO_GEOMETRY(2002,null,null, MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(10,10,20,25,30,10,40,10)));
in the above example 2 columns are being inserted in a row where 1 is the data in the first column and the remaining data into 2nd column, which contains 5 sub columns as well.
SDO_GTYPE
SDO_SRID
SDO_POINT
SDO_ELEMINFO
SDO_ORDINATES
the above data has been collected from Pro Oracle Spatial for Oracle Database 11g
With the help of the classes i mentioned i retrieved the data of SDO_ORDINATES where
java will eliminate the words MDSYS.SDO_ORDINATE_ARRAY and give them to us as
LINESTRING(10,10,20,25,30,10,40,10)
it is actually right there are many such types like POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINE, MULTIPOLYGON and etc (they are the only few i explored).
i guess by now everyone can understand my problem what is the proper mapping(Class) for the remaining data to handle by hibernate(hibernate-spatial).
can any one help me in this regard.