View Issue Details

IDProjectCategoryView StatusLast Update
0002996SymmetricDSBugpublic2017-02-24 14:18
Reportermmichalek Assigned Tommichalek  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.17 
Target Version3.8.17Fixed in Version3.8.17 
Summary0002996: DB2 dialect fails to detect existence of sym tables
DescriptionOn certain DB2 platforms, the table meta data may contain the key "NAME" instead of the standard "TABLE_NAME".

https://sourceforge.net/p/symmetricds/discussion/739236/thread/07d6c6d6/#79bd

This results in startup errors where SymmetricDS tries to recreate the already existing tables.

DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=CAT.SYM_CHANNEL;TABLE, DRIVER=4.14.137

OR

SYM_CHANNEL in CATALOG type *FILE already exists.. Failed to execute: CREATE TABLE "SYM_CHANNEL...

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 ab0eb3ac

2017-02-16 09:13:53

mmichalek

Details Diff
0002996: DB2 dialect fails to detect existence of sym tables Affected Issues
0002996
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2017-02-16 14:13 mmichalek New Issue
2017-02-16 14:13 mmichalek Status new => assigned
2017-02-16 14:13 mmichalek Assigned To => mmichalek
2017-02-16 14:14 mmichalek Status assigned => resolved
2017-02-16 14:14 mmichalek Resolution open => fixed
2017-02-16 14:14 mmichalek Fixed in Version => 3.8.17
2017-02-16 15:00 mmichalek Changeset attached => SymmetricDS 3.8 ab0eb3ac
2017-02-24 14:18 chenson Status resolved => closed