New answers tagged

0

I read about connection pooling and found that I only need to close the "parent" connection. finally { if (itr != null) itr.close(); if (con != null && !con.isClosed()) con.close(); }


0

You shouldn't be opening your own connections, let GeoTools manage that for you. I have used the following code (with a PostGIS connection as I don't have Oracle installed) and it is fine. The main trick is to make sure you close your featurereaders/featurecollections/iterators, otherwise they will hang on to a connection until they are garbage collected. ...


0

Try making an editable view for this foreign table, if you need to see up-to-date data, and add this view to QGIS.


0

In Oracle geodatabases, the DEFINITION column is an ArcSDE XML type rather than the native Oracle XML type which stores the information as BLOBs. To enable reading these values, the SDE schema in Oracle contains a view for the GDB_Items table named GDB_Items_vw for details http://support.esri.com/ES/knowledgebase/techarticles/detail/38375



Top 50 recent answers are included