Geospatial data in Oracle and xMII

[Former Member]

Hello xMII team and enthusiasts,

I have had a request to store and retrieve geospatial data into an Oracle database using xMII. The basic idea was to be able to transfer a file containing geospatial data from a mining survey application and store it into an Oracle database. Has anyone handled this type of application? I am interested to know your thoughts on the best way to tackle it.

I understand that Oracle has GIS specific data types like SDO_GEOMETRY (for coordinates), and of course has BLOBs. Can xMII handle these types natively? (I am guessing no, since these are fairly database specific making it difficult to handle generically in JDBC, but would like to confirm if anyone has handled such cases).

I guess stored procedures can be developed to import data from files and insert it into the database. Do you think this would be the best approach?

Sorry for asking multiple questions in one forum post, am trying to lay out my thought processes and these questions have just popped up :).

Thank you in advance for any insight that you can provide.

Kind regards,

Sidney Shek

[Former Member]

Also, if you're a developer, you can either create custom "actions" that plug into the xMII business logic services environment or you could wrap the activities in a web service that is callable by xMII.

- Rick