View Issue Details

IDProjectCategoryView StatusLast Update
0001985SymmetricDSImprovementpublic2015-01-06 22:27
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.6.0 
Target Version3.7.0Fixed in Version3.7.0 
Summary0001985: Add support for DB2 iSeries (AS/400)
DescriptionThe base DB2 dialect and platform should provide enough support for DB2 on iSeries.

https://sourceforge.net/p/symmetricds/discussion/739236/thread/807e05df/?limit=25#fb4f
Additional InformationUsing jtopen_8_3 library (com.ibm.as400.access.AS400JDBCDriver):

Detected database 'DB2 UDB for AS/400', version '6', protocol 'as400'
DdlException: Could not find platform for database DB2 UDB for AS/400

Using db2jcc4.jar + license jar:

Detected database 'AS', version '6', protocol 'db2'
TagsNo tags attached.

Activities

elong

2014-12-30 13:40

developer   ~0000642

Tested using jt400 JDBC driver. The JDBC URL should use the "libraries" property, like this:

db.url=jdbc:as400://hostname/;libraries=myschema

Related Changesets

SymmetricDS: master 2578dacb

2014-12-18 11:17:21

erilong

Details Diff
0001985: Add support for DB2 iSeries (AS/400) Affected Issues
0001985
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/JdbcSymmetricDialectFactory.java Diff File
add - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2As400SymmetricDialect.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2SymmetricDialect.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/DatabaseNamesConstants.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/JdbcDatabasePlatformFactory.java Diff File
add - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2As400DatabasePlatform.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2DdlReader.java Diff File

SymmetricDS: master d5819c82

2014-12-18 16:47:33

erilong

Details Diff
0001985: Add support for DB2 iSeries (AS/400) Affected Issues
0001985
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterServiceSqlMap.java Diff File

SymmetricDS: master d1218d73

2014-12-30 08:29:42

erilong

Details Diff
0001985: Add support for DB2 iSeries (AS/400) Affected Issues
0001985
mod - symmetric-assemble/src/asciidoc/appendix/databases.ad Diff File
mod - symmetric-assemble/src/asciidoc/appendix/db2.ad Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2As400SymmetricDialect.java Diff File
add - symmetric-db/src/main/java/org/jumpmind/db/platform/db2/Db2As400DdlBuilder.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2As400DatabasePlatform.java Diff File
add - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2As400DdlReader.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2DdlReader.java Diff File

Issue History

Date Modified Username Field Change
2014-09-22 13:17 elong New Issue
2014-09-22 13:17 elong Status new => assigned
2014-09-22 13:17 elong Assigned To => elong
2014-09-22 14:00 Changeset attached => SymmetricDS 3.6 r8735
2014-09-22 16:00 Changeset attached => SymmetricDS 3.6 r8736
2014-09-23 23:00 Changeset attached => SymmetricDS 3.6 r8749
2014-12-18 17:00 Changeset attached => SymmetricDS trunk r9078
2014-12-18 22:00 Changeset attached => SymmetricDS trunk r9080
2014-12-30 13:40 elong Note Added: 0000642
2014-12-30 13:40 elong Status assigned => resolved
2014-12-30 13:40 elong Fixed in Version => 3.7.0
2014-12-30 13:40 elong Target Version 3.6.9 => 3.7.0
2014-12-30 14:00 Changeset attached => SymmetricDS trunk r9130
2015-01-06 22:27 chenson Status resolved => closed
2015-07-31 01:49 Changeset attached => SymmetricDS master d1218d73
2015-07-31 01:49 Changeset attached => SymmetricDS master d5819c82
2015-07-31 01:49 Changeset attached => SymmetricDS master 2578dacb