View Issue Details

IDProjectCategoryView StatusLast Update
0004874SymmetricDSImprovementpublic2022-11-07 17:00
Reporterpmarzullo Assigned Tocquamme  
Prioritynormal 
Status resolvedResolutionopen 
Product Version3.12.7 
Summary0004874: SQL Server and Sybase dialects should make sure that SET NOCOUNT OFF is set on each database connection
DescriptionThe database connection property SET NOCOUNT OFF needs to be in place in order for normal processing to succeed. If this property were set to on, then all insert/updates/deletes would always return 0 rows updated, causing lots of logic problems.

Tagsdialect: sql-server, dialect: sybase

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 ef781be0

2022-10-24 12:39:06

cquamme

Details Diff
0004874: SQL Server and Sybase dialects should make sure that SET
NOCOUNT OFF is set on each database connection
Affected Issues
0004874
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlSymmetricDialect.java Diff File

SymmetricDS: 3.14 91f7e611

2022-11-07 16:16:45

cquamme

Details Diff
0004874: SQL Server and Sybase dialects should make sure that SET
NOCOUNT OFF is set on each database connection
Affected Issues
0004874
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/ase/AseSymmetricDialect.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlSymmetricDialect.java Diff File

Issue History

Date Modified Username Field Change
2021-03-05 15:53 pmarzullo New Issue
2021-03-05 15:53 pmarzullo Tag Attached: dialect: sql-server
2021-03-05 15:53 pmarzullo Tag Attached: dialect: sybase
2022-10-19 17:39 cquamme Assigned To => cquamme
2022-10-19 17:39 cquamme Status new => assigned
2022-10-24 13:00 cquamme Changeset attached => SymmetricDS 3.14 ef781be0
2022-11-07 16:17 cquamme Status assigned => resolved
2022-11-07 17:00 cquamme Changeset attached => SymmetricDS 3.14 91f7e611