View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000742 | SymmetricDS | Bug | public | 2012-07-29 17:37 | 2014-02-03 01:52 |
| Reporter | evfvadim | Assigned To | chenson | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.0.10 | ||||
| Target Version | 3.1.0 | Fixed in Version | 3.1.0 | ||
| Summary | 0000742: "ORA-01000: maximum open cursors exceeded" during initial load (RouterService.insertInitialLoadEvents) | ||||
| Description | This happens when number of tables is big enough (650 in our case). The cause of problem is missing JdbcSqlTemplate.close() calls for PreparedStatement in several places in org.jumpmind.db.sql.JdbcSqlTemplate. | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Attached fixed JdbcSqlTemplate - I don't have permissions to commit for some reason. |
|
|
Are you sure your changes are in JdbcSqlTemplate? I don't see any difference from the trunk version. |
|
|
|
|
|
Sorry, you are right, the bug was in JdbcSqlTransaction (the fix is attached). |
|
|
I see the issue you are describing in JdbsSqlTransaction. Is that where you made the fix? |
|
|
Yes |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-07-29 17:37 | evfvadim | New Issue | |
| 2012-07-29 17:52 | evfvadim | File Added: JdbcSqlTemplate.java | |
| 2012-07-29 17:54 | evfvadim | Note Added: 0000040 | |
| 2012-07-29 17:55 | evfvadim | Note Edited: 0000040 | View Revisions |
| 2012-07-29 18:57 | chenson | Note Added: 0000041 | |
| 2012-07-29 19:05 | chenson | Assigned To | => chenson |
| 2012-07-29 19:05 | chenson | Status | new => assigned |
| 2012-07-29 19:06 | chenson | Fixed in Version | => 3.1.0 |
| 2012-07-29 19:06 | chenson | Target Version | => 3.1.0 |
| 2012-07-29 19:06 | evfvadim | File Added: JdbcSqlTransaction.java | |
| 2012-07-29 19:07 | evfvadim | Note Added: 0000042 | |
| 2012-07-29 19:11 | chenson | Note Added: 0000043 | |
| 2012-07-29 19:14 | evfvadim | Note Added: 0000044 | |
| 2012-07-29 20:45 | chenson | Status | assigned => resolved |
| 2012-07-29 20:45 | chenson | Resolution | open => fixed |
| 2012-08-14 11:58 | chenson | Status | resolved => closed |
| 2014-02-03 01:52 | Changeset attached | => SymmetricDS trunk r6105 | |
| 2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master f5824b05 |