gvSIG bugs #2160
gvSIG freezes creating the fifth DB table document
| Status: | Closed | % Done: | 0% | |
|---|---|---|---|---|
| Priority: | Urgent | Spent time: | - | |
| Assignee: | ||||
| Category: | Database | |||
| Target version: | 2.1.0-2217-devel | |||
| Severity: | Add-on version: | |||
| gvSIG version: | 2.1.0 | Add-on build: | ||
| gvSIG build: | 2215 | Add-on resolve version: | ||
| Operative System: | Linux | Add-on resolve build: | ||
| Keywords: | Proyecto: | |||
| Has patch: | No | Hito: | ||
| Add-on name: | Unknown |
Description
I've tried to add 5 table document from a Postgres source gvSIG freezes. After a while, console shows this message:
Caused by: org.gvsig.fmap.dal.resource.exception.AccessResourceException: Error while atemp to access resource 'PostgreSQLResource(jdbc:postgresql://localhost:5432/reconecdb,reconec)'.
at org.gvsig.fmap.dal.resource.db.AbstractDBResourceNoBlocker.get(AbstractDBResourceNoBlocker.java:76)
at org.gvsig.fmap.dal.store.jdbc.JDBCResource.getJDBCConnection(JDBCResource.java:99)
at org.gvsig.fmap.dal.store.jdbc.JDBCHelper.getConnection(JDBCHelper.java:212)
at org.gvsig.fmap.dal.store.jdbc.JDBCHelper$3.run(JDBCHelper.java:248)
at org.gvsig.fmap.dal.resource.spi.AbstractResource.performExecution(AbstractResource.java:316)
at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:57)
... 72 more
Caused by: org.gvsig.fmap.dal.store.jdbc.exception.JDBCSQLException: An JDBC driver exception was throw
at org.gvsig.fmap.dal.store.postgresql.PostgreSQLResource.getTheConnection(PostgreSQLResource.java:190)
at org.gvsig.fmap.dal.resource.db.AbstractDBResourceNoBlocker.get(AbstractDBResourceNoBlocker.java:74)
... 77 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.gvsig.fmap.dal.store.postgresql.PostgreSQLResource.getTheConnection(PostgreSQLResource.java:186)
... 78 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1174)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 80 more
I think that this problem is caused due a missing dispose-call of a DB resource
History
#1
Updated by Juan Lucas Domínguez over 12 years ago
- Assignee set to Juan Lucas Domínguez
#2
Updated by Juan Lucas Domínguez over 12 years ago
- Status changed from New to Fixed
Closing connection after short use and improving GUI events management.
#3
Updated by Joaquín del Cerro Murciano over 12 years ago
- Target version set to 2.1.0-2217-devel
#4
Updated by Álvaro Anguix over 12 years ago
- Status changed from Fixed to Closed