View Issue Details

IDProjectCategoryView StatusLast Update
0006960SymmetricDSBugpublic2025-06-20 20:48
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.5 
Target Version3.15.18Fixed in Version3.15.18 
Summary0006960: DBCompare throws a NullPointerException when one database is missing a row with a null value for a UNIVARCHAR column
DescriptionWhen using DBCompare and one database is missing a row with a null value for a Sybase ASE UNIVARCHAR column, the following NullPointerException occurs:

2025-06-18 09:10:16,767 ERROR [client] [DbCompare] [main] Exception while comparing Table [name=test; 15 columns] to Table [name=test; 15 columns] java.lang.NullPointerException: Cannot invoke "String.contains(java.lang.CharSequence)" because "stringToConvert" is null
    at org.jumpmind.symmetric.io.DbValueComparator.convertString(DbValueComparator.java:101)
    at org.jumpmind.symmetric.io.DbCompareDiffWriter.writeInsert(DbCompareDiffWriter.java:134)
    at org.jumpmind.symmetric.io.DbCompare.compareTables(DbCompare.java:306)
    at org.jumpmind.symmetric.io.DbCompare.compare(DbCompare.java:94)
    at org.jumpmind.symmetric.DbCompareCommand.executeWithOptions(DbCompareCommand.java:128)
    at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:157)
    at org.jumpmind.symmetric.DbCompareCommand.main(DbCompareCommand.java:172)
Tagsdbcompare, dialect: sybase

Relationships

related to 0006961 resolvedemiller DBCompare throws a NullPointerException when one database is missing a row with a null value for a UNIVARCHAR column 

Activities

pbelov

2025-06-20 20:48

manager   ~0003122

Included in the 3.15.18 release

Related Changesets

SymmetricDS: 3.15 1dc09b3f

2025-06-20 14:17:57

evan-miller-jumpmind

Details Diff
0006960: Prevented DBCompare from throwing a NullPointerException when one database is missing a row with a null value for a UNIVARCHAR column Affected Issues
0006960
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbValueComparator.java Diff File

Issue History

Date Modified Username Field Change
2025-06-19 13:24 emiller New Issue
2025-06-19 13:24 emiller Status new => assigned
2025-06-19 13:24 emiller Assigned To => emiller
2025-06-19 13:24 emiller Tag Attached: dbcompare
2025-06-19 13:24 emiller Tag Attached: dialect: sybase
2025-06-19 13:27 emiller Issue cloned: 0006961
2025-06-19 13:27 emiller Relationship added related to 0006961
2025-06-19 18:36 emiller Target Version 3.15.18 => 3.15.19
2025-06-20 14:18 emiller Status assigned => resolved
2025-06-20 14:18 emiller Resolution open => fixed
2025-06-20 14:18 emiller Fixed in Version => 3.15.18
2025-06-20 14:18 emiller Target Version 3.15.19 => 3.15.18
2025-06-20 15:00 Changeset attached => SymmetricDS 3.15 1dc09b3f
2025-06-20 20:48 pbelov Note Added: 0003122
2025-06-20 20:48 pbelov Status resolved => closed