Processing large-print segments based on the Aeai ESB

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

1. Read Pictures/files locally, insert Oracle Database

2. Reading data from Oracle into SQL Server

3. Read data from SQL Server to local

4. JDBC The flow mechanism is used to read and write the Blob/clob.

5. 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