View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003633 | SymmetricDS Pro | Bug | public | 2018-07-17 19:31 | 2019-06-25 18:30 |
| Reporter | mmichalek | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.10.3 | Fixed in Version | 3.10.3 | ||
| Summary | 0003633: MSSQL Server Pro Validation Query Fails with a hyphen in the DB Name | ||||
| Description | Here is a database named: dbHMI-prod. Notice the message: Incorrect syntax near '-'. 2018-07-17 15:27:06,232 WARN [corp-000] [MsSqlDdlReader] [qtp1777443462-16] Failed to determine auto increment columns using this query: 'SELECT t.TEST_ID,t.TEST_VALUE FROM db-prod.dbo.SYM_PERMISSION_TEST t WHERE 1 = 0'. This is probably not harmful, but should be fixed. Table [name=SYM_PERMISSION_TEST; 2 columns] Column [name=TEST_ID; jdbcType=int; mappedType=INTEGER] Column [name=TEST_VALUE; jdbcType=int; mappedType=INTEGER] (org.jumpmind.db.platform.AbstractJdbcDdlReader.determineAutoIncrementFromResultSetMetaData(AbstractJdbcDdlReader.java:1308)) com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '-'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) | ||||
| Tags | No tags attached. | ||||
| related to | 0003976 | resolved | ASE dialect fails to determine auto increment columns with special character in table name |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-07-17 19:31 | mmichalek | New Issue | |
| 2018-07-17 19:31 | mmichalek | Project | SymmetricDS => SymmetricDS Pro |
| 2018-10-10 18:06 | hanes | Target Version | => 3.10.0 |
| 2018-10-17 18:37 | hanes | Status | new => acknowledged |
| 2019-05-08 12:41 | admin | Target Version | 3.10.0 => 3.10.3 |
| 2019-05-28 17:40 |
|
Relationship added | related to 0003976 |
| 2019-05-28 17:51 |
|
Assigned To | => user606 |
| 2019-05-28 17:51 |
|
Status | acknowledged => resolved |
| 2019-05-28 17:51 |
|
Resolution | open => fixed |
| 2019-05-28 17:51 |
|
Fixed in Version | => 3.10.3 |
| 2019-06-25 18:30 | admin | Status | resolved => closed |