Announcement Announcement Module
No announcement yet.
Help me ! Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help me !

    Help me to solve this

    I am involved in a project which is a data base inegration of db2 & mysql.
    Here i want to imgrate data from db2 database to mysql database. I am not possible to use any other 3rd party tool like 'Pentaho'
    So i have to write my own java project with jdbc queries.In my case db2 database is a legacy database it doesn't implemented fundamentals of the db designing. (ex:- keys, relaion ships)
    Any how i have a mapping doc with descrbing table mapping of db2 and mysql

    "Bank Table" of db2 database mapped with mysql database "Bank Table" as follows

    db2 side mysql side
    Bank Code | Bank Name Bank Code | Bank Name | Date
    ------------------------ ----------------------------------
    000 | BOC 000 | BOC | SYSDATE
    001 | COM 001 | COM | SYSDATE

    What i want is to write java appo read db2 database table and write to mysql db.

    Tools i am using
    Jboss 7.1 app server with hornet queue
    Spring 2.5
    Ejb 3.0

    I herd MDB(Message Driven Bean) is a good soluion for implementing loosely coupled heteregenous systems together.

    So what is the best method from follwing ways

    1. Read the data from db2 database and put the result set the message queue & insert data o mysql database inside "onMesagge" method of the MDB

    2. Pass a paramter and read it in the MDB and select data and insert

    Data rows may be 100000+ in some tables
    Also have a requirements to use spring schdulers

    What is the best mehod for implemening that?

    Thank you

  • #2
    Sorry for not getting to this sooner. We are in the process of moving to StackOverflow for our forums.

    This question is probably a better candidate for StackOverflow, perhaps against the #spring-jms tag.

    If you do post it there, please reply here with the link.