Skip to Content
author's profile photo
Former Member

Regarding JDBC Adapter

Hi All,

If We r Dealing with JDBC Serder Means

We have "<b>Query Sql Statement & Update Sql Statement "</b> in Processing Parameters.

what is the Use of these ??? When we Will use these ?????

Can Any one Please Explain this

Regards

Vamsi

Add comment
10|10000 characters needed characters exceeded

5 Answers

  • Best Answer
    Posted on Aug 23, 2007 at 09:16 AM

    <b>Query Sql Statement</b> executes the query and retreives the data for processing.

    <b>Update Sql Statement</b> upon retreival of some data u may want to update few fields. in this case u write an update query here

    Add comment
    10|10000 characters needed characters exceeded

    • <b>Q1) If we did this, this will be the Permanant Changes to the database or Temporarly changes ????</b>

      Temporary...[ But permanant untill u make any changes to that data in future 😊 ]

      Q2) This Update Sql Stement is Mandatory Input to the JDBC Sender or Optional One ???

      Optional....[ But mandatory when u make changes to table content using JDBC]

      Regards

      Santhosh

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 09:16 AM

    Query string is ur select statement i.e. on what conditino u wannt to select the data from database.

    Update statement it to update the record so next in next select it should not be picked up or in other words, to set the record as read which has been selected in select query.

    Regards

    Sushil

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2007 at 09:18 AM

    Hi Vamsi,

    The UPDATE statement is used to modify the data in a table i.e if u make some changes to the existing content of the table u actually UPDATE the table to make the changes effect.

    QUERY returns the result of the table selected by the SELECT * statement.

    http://www.w3schools.com/sql/sql_update.asp

    Regards

    Santhosh

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2007 at 09:17 AM

    >Query Sql Statement used to select some records from your database

    -


    >Update Sql Statement used to update your database records after your select query fetches records from you DB

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2007 at 09:23 AM
    Add comment
    10|10000 characters needed characters exceeded