1. Background
Large numbers of data migrations have always been a headache, and it is not possible to use SQL statements to implement inserts and updates when the value in large segments is greater than 32K. There are generally two common solutions: stored procedures and JDBC. The following is a summary of the solution based on the Aeai ESB using JDBC for large-font segments.
2. Realization of Ideas
Read Pictures/files locally, insert Oracle Database
Reading data from Oracle into SQL Server
Read data from SQL Server to local
JDBC The flow mechanism is used to read and write the Blob/clob.
Verify that the images/files written locally are consistent with the source data
3. Functional Design
JDBC Large print processing is divided into three processes:
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/58/E6/wKioL1TAbqrjNIcuAABE6-_gw6Y468.jpg "title=" Cldzd1.png "alt=" Wkiol1tabqrjnicuaabe6-_gw6y468.jpg "/>
3.1.read local file/Picture3.1.1. Flowchart
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/58/E8/wKiom1TAbeOydD5dAABX92gmVT4094.jpg "title=" Cldzd2.png "alt=" Wkiom1tabeoydd5daabx92gmvt4094.jpg "/>
3.1.2. Component Description
Read Insert Oracle Database: Read local file/Picture into Oracle database.
The main code is as follows:
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/58/E6/wKioL1TAbsmzF0QFAAMMXoivwF0328.jpg "title=" Cldzd3.jpg "width=" "height=" 426 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:600px;height:426px; "alt=" Wkiol1tabsmzf0qfaammxoivwf0328.jpg "/>
3.2. inserting SQL Server from an Oracle query3.2.1. Flowchart
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/58/E8/wKiom1TAbgSAlJARAABzksLfaPk451.jpg "title=" Cldzd4.png "alt=" Wkiom1tabgsaljaraabzkslfapk451.jpg "/>
3.2.2. Component Description
Read data from Oracle: reads data stored in Oracle database tables.
Insert SQL Server: Inserts data read from Oracle into SQL Server.
The main code is as follows:
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/58/E6/wKioL1TAbuahww_sAAL8TdLnpYk534.jpg "title=" Cldzd5.png "width=" "height=" 458 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:600px;height:458px; "alt=" Wkiol1tabuahww_saal8tdlnpyk534.jpg "/>
3.3. read write locally from SQL Server3.3.1. Flowchart
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/58/E8/wKiom1TAbiGTTHPUAABW4K4Y8gw834.jpg "title=" Cldzd6.png "alt=" Wkiom1tabigtthpuaabw4k4y8gw834.jpg "/>
3.3.2. Component Description
Read Write locally:
The main function code is as follows:
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/58/E6/wKioL1TAbwHC8-x_AAJ543Gp5fk853.jpg "title=" Cldzd7.png "width=" "height=" 411 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:600px;height:411px; "alt=" Wkiol1tabwhc8-x_aaj543gp5fk853.jpg "/>
processing Large-text documents based on the Aeai ESB Download
This article is from the "Digital unobstructed portal Integration Platform" blog, please be sure to keep this source http://aeaiportal.blog.51cto.com/9300497/1606920
Processing large-print segments based on the Aeai ESB