Processing large-print segments based on the Aeai ESB

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.