| gvSIG desktop 1

From time to time this error is reported in the list. See attached log as example. This happens for various reasons:

• The length of the name of a postgresql cursor is by default limited to 63 characters. The name of the cursor in gvSIG is built based on the name of the table in the database using some parameters as the current time (in milliseconds) of the system as suffix. So, if the name of the layer is big, the cursor name is truncated and it can collide.

The proposed solution is use a random number for the name of the cursor, and check on the catch if it collide, in this case a new random number will be generated.

• The cursor (at least those called wkb_cursor_prov) are never close. This can be checked using this code after the declare statement on the constructor of source:trunk/extensions/extJDBC/src/com/iver/cit/gvsig/fmap/drivers/jdbc/postgis/PostGisFeatureIterator.java

this.rs = st.executeQuery("select * from pg_cursor()");
while (rs.next()) {
System.out.println(rs.getString("name"));
}

Each time a new iterator object is created we can see that the cursors are not close.

This can be fixed changing the code of the closeIterator method.