'[OpenIDM] Batch insert for openIDM database table connector'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       forgerock-openidm
Subject:    [OpenIDM] Batch insert for openIDM database table connector
From:       XJ He <xhe () enernoc ! com>
Date:       2015-11-18 14:04:14
Message-ID: D271EF8C.26DFD%xhe () enernoc ! com
[Download RAW message or body]

Hi All,

In one of my projects, I am using openIDM Database Table Connector \
(https://backstage.forgerock.com/#!/docs/openidm/3.1.0/integrators-guide/chap-resource-conf#database-table-connector) \
to connect target oracle database, and live sync pushes the change when a change is \
detected from source side.

When large amount of records being modified at source side, which issue massive \
update/insert/delete statements to the target oracle data store. Since this database \
table connector is JDBC based, is there a way people can control the auto commit and \
make a batch insert?

Thanks,

This email and any information disclosed in connection herewith, whether written or \
oral, is the property of EnerNOC, Inc. and is intended only for the person or entity \
to which it is addressed.   This email may contain information that is privileged, \
confidential or otherwise protected from disclosure.   Distributing or copying any \
information contained in this email to anyone other than the intended recipient is \
strictly prohibited.

[Attachment #3 (text/html)]

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, \
sans-serif;"> <div><span style="color: rgb(68, 68, 68); font-family: Arial, \
Helvetica, sans-serif; font-size: 12px; line-height: 1.5em;">Hi All,</span></div> \
<div> <p style="margin: 2px 10px 6px 0px; padding: 0px; color: rgb(68, 68, 68); \
line-height: 1.5em; font-family: Arial, Helvetica, sans-serif; font-size: 12px;"> \
<span style="line-height: 1.5em;">In one of my projects, I am using openIDM Database \
Table Connector (</span><a \
href="https://backstage.forgerock.com/#!/docs/openidm/3.1.0/integrators-guide/chap-resource-conf#database-table-connector" \
rel="nofollow noreferrer" target="_blank" style="line-height: 1.5em; margin: 0px; \
padding: 0px; color: rgb(51, 51, 51); cursor: \
pointer;">https://backstage.forgerock.com/#!/docs/openidm/3.1.0/integrators-guide/chap-resource-conf#database-table-connector</a><span \
style="line-height: 1.5em;">)  to connect target oracle database, and live sync \
pushes the change when a change is detected from source side.</span><span \
style="line-height: 1.5em;">&nbsp;</span></p> <p style="margin: 2px 10px 6px 0px; \
padding: 0px; color: rgb(68, 68, 68); line-height: 1.5em; font-family: Arial, \
Helvetica, sans-serif; font-size: 12px;"> When large amount of records being modified \
at source side, which issue massive update/insert/delete statements to the target \
oracle data store. Since this database table connector is JDBC based, is there a way \
people can control the auto commit and make a  batch insert?</p>
<p style="margin: 2px 10px 6px 0px; padding: 0px; color: rgb(68, 68, 68); \
line-height: 1.5em; font-family: Arial, Helvetica, sans-serif; font-size: 12px;"> \
Thanks,</p> </div>
<br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:gray'>This \
email and any information disclosed in connection herewith, whether written or oral, \
is the property of EnerNOC, Inc. and is intended only for the person or entity to \
which it is addressed.   This email may contain information that is privileged, \
confidential or otherwise protected from disclosure.   Distributing or copying any \
information contained in this email to anyone other than the intended recipient is \
strictly prohibited.</span> &nbsp;&nbsp;&shy;&shy;&nbsp;&nbsp;</body>
</html>

_______________________________________________
OpenIDM mailing list
OpenIDM@forgerock.org
https://lists.forgerock.org/mailman/listinfo/openidm

--===============1473237864684662471==--

[prev in list] [next in list] [prev in thread] [next in thread] 