This content has been marked as final. Show 11 replies
For the Locator user guide:
And look for "2 Day Plus Locator Developer Guide"
Excellent News !
I just tested this and it works really well.
All expected features of my application are working.
Plus the database only has a 160MB footprint.
Now for the next release I'll have to go hassle the InterMedia team to include InterMedia Image support.
Thanks to all concerned,
I'll pass on your request to the intermedia folks.
But it will be the same as Locator, We have to convince the XE folks to add features and you could help by going to the intermedia discussion forum and start lobbying.
I'll do that now. I think Image's alone would suffice, no real need for Audio / Video in a small database.
I just installed XE (quick and easy !) and have started testing locator. I could not use the sdo_geometry constructor with well-known text, e.g.:
INSERT INTO test1 VALUES (2,'church',
SDO_GEOMETRY('POLYGON ((-69 -25, -72 -25, -72 -27, -69 -27, -69 -25))', NULL));
It gave no error, but the resulting geometry was NULL. The same works with standard edition oracle 10g.
Also, when trying to print out the wkt value of the shape fields (when populated using the normal constructor) the output is always NULL, e.g.
select col1, s.shape.get_wkt() from test1 s;
Is there no support for Well-known text in Locator/XE?
The WKT constructors need javavm in the database.
Since javavm in the DB is not included Express edition, some of the Locator
features which depend on javavm are not available in Express edition.
Is there any other way to get the WKT-knowm format in a SQL-Editor from oracle xe ?
Or do I always have to look for the WKT in sqlplus over the cmd-line ?
Yes, there is exist one very nice open-source tool developed as extension for Oracle SQL Developer - called GeoRaptor. You need to download Oracle SQL Developer from OTN and GeoRaptor from http://mygeoraptor.googlepages.com/. Installation instructions for GeoRaptor are provided also on the same site.
You can use the JTS library (Version 1.7) to insert WKT Geometry's into your database.
Probably WAY off topic, but worth mentioning somewhere here.
Its Java code, so not for everyone, but here it is anyway:
Connection connection = getConnection();
PreparedStatement ps = connection.prepareStatement( "UPDATE TABLE SET GEOMETRY = ?" );
WKTReader reader = new WKTReader();
Geometry myPoly = reader.read( POLYGON ((-69 -25, -72 -25, -72 -27, -69 -27, -69 -25)) );
OraWriter writer = new OraWriter( connection );
STRUCT obj = writer.write( myPoly );
ps.setObject( 1, obj );
Also, the JTS OraReader Class, performs 1/3 faster than JGeometry.load(...), but does not support all the complex Geometry types that JGeometry does.
That's great, best free SQL -Editor I've ever seen and the plugin: GeoRaptor....(Geometry-View-Function !!!)...
=> A perfect double to work with spatial data.
P.S. The Plugin can also be downloaded by sourceforge, I got some problems with the direct SQL -Editor-Update-Function:
Direct Link: http://prdownloads.sourceforge.net/georaptor/org.GeoRaptor-20060202-dev.jar?download
I'm glad, that you have found it useful!