View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004890 | SymmetricDS Pro | Bug | public | 2021-03-12 14:25 | 2021-03-30 19:47 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.7 | ||||
| Target Version | 3.12.8 | Fixed in Version | 3.12.8 | ||
| Summary | 0004890: dbcp2 package requires setting of validation query, otherwise it runs jdbc driver isValid() method, causing problems | ||||
| Description | When the validation query is not set in the data source, the dbcp2 getConnection() method then calls the jdbc driver isValid() method to determine if the connection is a valid connection. For at least the JTDS driver, that method is not implemented, and throws an AbstractMethodError exception. Using the Pro interface, when the connection is tested, we need to add the validation query. Also, when the permissions are tested, we need to add the validation query. | ||||
| Steps To Reproduce | 1. Create a new SQL Server node, using the JTDS driver. 2. Test the connection. | ||||
| Tags | dialect: sql-server | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-03-12 14:25 | pmarzullo | New Issue | |
| 2021-03-12 14:25 | pmarzullo | Status | new => assigned |
| 2021-03-12 14:25 | pmarzullo | Assigned To | => pmarzullo |
| 2021-03-12 14:25 | pmarzullo | Tag Attached: dialect: sql-server | |
| 2021-03-12 14:28 | pmarzullo | Status | assigned => resolved |
| 2021-03-12 14:28 | pmarzullo | Resolution | open => fixed |
| 2021-03-12 14:28 | pmarzullo | Fixed in Version | => 3.12.8 |
| 2021-03-30 19:47 | admin | Status | resolved => closed |