View Issue Details

IDProjectCategoryView StatusLast Update
0003710SymmetricDSNew Featurepublic2018-09-06 14:00
Reporterjosh-a-hicksAssigned Tojosh-a-hicks 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.9.14 
Target Version3.9.14Fixed in Version3.9.14 
Summary0003710: Jdbc Batch bulk data loader
DescriptionA new bulk data loader to provide jdbc batch execution based on a provided size rather than one row at a time. To turn on set the sym_channel.data_loader_type to 'bulk'. If the dialect being loaded does not already have a bulk data loader implementation the jdbc batch implementation will be used.

There are two additional parameters that also can be used to configure this data loader.

db.jdbc.bulk.execute.batch.size - Defaults to 25 but can be adjusted to the number of statements that will be batched together.
db.jdbc.bulk.execute.batch.override - Defaults to false, but turning this on will override the provided bulk loader with the jdbc batch loader.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 8201c38d

2018-09-06 13:53:52

josh-a-hicks

Details Diff
0003710: Jdbc Batch bulk data loader
0003710
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/ClientSymmetricEngine.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/ext/BulkDataLoaderFactory.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/io/AbstractBulkDatabaseWriter.java Diff File
add - symmetric-client/src/main/java/org/jumpmind/symmetric/io/JdbcBatchBulkDatabaseWriter.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataLoaderService.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/sql/SqlTemplateSettings.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/sql/JdbcSqlTransaction.java Diff File

Issue History

Date Modified Username Field Change
2018-09-06 13:52 josh-a-hicks New Issue
2018-09-06 13:52 josh-a-hicks Status new => assigned
2018-09-06 13:52 josh-a-hicks Assigned To => josh-a-hicks
2018-09-06 13:54 josh-a-hicks Status assigned => resolved
2018-09-06 13:54 josh-a-hicks Resolution open => fixed
2018-09-06 13:54 josh-a-hicks Fixed in Version => 3.9.14
2018-09-06 14:00 josh-a-hicks Changeset attached => SymmetricDS 3.9 8201c38d