> >SISDB plugin
> >I spent quite a long time installing and configurind this
> plugin for rather a stupid reason. When playing with the
> native connector I had learned that pressing Connect would
> lit a green light if settings were OK. This is not the case
> with SISDB but the red cross remains there even if the
> connection succeeds. The connection can be tested in the
> previous dialog by selecting the newly configured driver and
> opening the drop-down menu for available datasets. If the
> menu remains empty then the parameters are not set correctly.
> >Once I realised that I had a database connection through
> SISDB plugin it was staright forward to perform Add Database
> Layer. It behaved just like the native PostGIS connector.
> However, Run Datastore Query with SISDB driver is used in
> another way because SISDB do not require "SELECT AsBinary"
> for the geometry field. Here I feel that SISDB way is better.
> >
> >
> There is a hidden drawback with this nice plugin. The code is
> much more
> complex than the first one for about the same (apparent) capabilities.
Hi all,
the reason why I wrote the SISDB plugin is that the "original" PostGIS plugin
doesn't support (or didn't support):
.) MultiCase table and field names (like "City" instead of "city")
.) multiple schemas (tables outside the default public schema)
.) multiple fields primary keys (PKs composed of more than one field)
All three problems are quite common using PostgreSQL. I had those same problem
(with varying degrees) also using qGis, MapServer, etc.
The other reason was that I already had a data access layer available,
so the plugin is only a thin layer between it an OpenJUMP and it didn't take me
a lot of work to write it.
Once I did, it was good enough for my purposes, so I never found the time
to make it better... sorry... :-(
Besides, the plugin also supports Oracle and, if I'll aver find the time,
it could also support ODBC connections and GeoTools DataStores too,
so you could use it with MS Access, ESRI Shapes, MapInfo MIF, etc.
Bye
Paolo Rizzi
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
