View Issue Details

IDProjectCategoryView StatusLast Update
0006961SymmetricDSBugpublic2025-06-20 15:00
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.16.0 
Target Version3.16.4Fixed in Version3.16.4 
Summary0006961: 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 0006960 closedemiller DBCompare throws a NullPointerException when one database is missing a row with a null value for a UNIVARCHAR column 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.16 a759e107

2025-06-20 14:21:45

evan-miller-jumpmind

Details Diff
0006961: Prevented DBCompare from throwing a NullPointerException when one database is missing a row with a null value for a UNIVARCHAR column Affected Issues
0006961
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:27 emiller New Issue
2025-06-19 13:27 emiller Status new => assigned
2025-06-19 13:27 emiller Assigned To => emiller
2025-06-19 13:27 emiller Tag Attached: dbcompare
2025-06-19 13:27 emiller Tag Attached: dialect: sybase
2025-06-19 13:27 emiller Issue generated from: 0006960
2025-06-19 13:27 emiller Relationship added related to 0006960
2025-06-20 14:21 emiller Status assigned => resolved
2025-06-20 14:21 emiller Resolution open => fixed
2025-06-20 14:21 emiller Fixed in Version => 3.16.4
2025-06-20 15:00 Changeset attached => SymmetricDS 3.16 a759e107