Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Unanswered: Generate XML file through MySQL DB Insertion

    We are in process to execute the event the moment we get an entry in DB i.e. at the time of insertion in MYSQL we need to generate an XML and forward to another server.

    For example we got an message from user A, we need to fetch all who are linked up with user A and finally put in encoded XML file. At last this XML file has sent to third party server i.e. http://yahoo.com?data=<encoded-xml-string>&action=data

    Please let us update if there is any alternate to do rather than MYSQL JOB Handler.

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    sorry I don't understand
    do you mean you need to get an XML feed from MySQL at the point that you insert the data?
    or do youmena you want to query MySQL and return data to the client application in XML?

  3. #3
    Join Date
    Nov 2007
    Posts
    2
    Hey Healdem,

    Our scenario as follows:

    Once the data has Inserted into DB we wanna retrieve the relevant data as per this inserted value and make a pre formatted XML file. This XML file we want to send a third party server. [I mean the sending part has to triggered automatically].

    In simple words we can say that we want to trigger the sending XML stream after insertion of data.

    Thanks.

  4. #4
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    You're going to be using your application to do this...
    Steps :
    1) application takes data input
    2) application submits information to database
    3) database stores information (as was sent)
    4) application collects data from database
    5) application builds xml file
    6) application sends xml file over stream

    As you can see from the above the only thing the database does is store and retrieve the information for you. Your application will handle the rest.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •