Hey all, Mentaer (Stefan) suggested I send a message to the JPP list to let everyone know about a new OpenJump database plugin. I know there are several other DB plugins out there, but they all seem to be table-based. I needed something that would let me put in arbitrary spatial queries and display the results in Jump, so I wrote this plugin.
Features: * You can call stored procedures, query views, do inline calculations, use DUAL in oracle, etc., and view the results in OpenJUMP * Oracle Spatial support via GeoTools * MySQL support via GeoTools * Ability to save DB connection parameters for multiple DBs so you don't have to keep retyping connection info every time you start jump or switch to a different database. Limitations: * Read-only * Handling of null geometries is kind of kludgy * No postgres support, but that's on my todo list * MySQL queries require "AsText" workaround to handle polygons * Large result sets might cause out-of-memory errors in OpenJUMP. A resultset limit (similar to what the Squirrel JDBC client does) is also on my todo list. If you're interested, check out the plugin's main page at http://jumpdbqplugin.sourceforge.net. Let me know if you have problems or suggestions. Tested on Linux, using Oracle Spatial 10.x, and MySQL 4.1.11. -Larry ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
