JDBC and Array Processing

Discussion in 'Java' started by Ryan Gaffuri, Aug 16, 2004.

  1. Ryan Gaffuri

    Ryan Gaffuri Guest

    How do I get the jdbc to use array processing when executing SQL? When
    I use Oracle and Oracle's 'sqlplus' tool, I can set the arraysize
    manually. This affects how many rows are retrieved from Oracle at a
    time.
     
    Ryan Gaffuri, Aug 16, 2004
    #1
    1. Advertisements

  2. Ryan Gaffuri

    Oscar kind Guest

    Ryan Gaffuri <> wrote:
    > How do I get the jdbc to use array processing when executing SQL? When
    > I use Oracle and Oracle's 'sqlplus' tool, I can set the arraysize
    > manually. This affects how many rows are retrieved from Oracle at a
    > time.


    This is called a fetch size in JDBC. See the method setFetchSize(int) in
    the interface java.sql.Statement. This method determmines the maximum
    number of rows fetched in one go from the database.

    If you want to limit the total number of rows retrieved, use the method
    setMaxRows(int) from the same interface.


    --
    Oscar Kind http://home.hccnet.nl/okind/
    Software Developer for contact information, see website

    PGP Key fingerprint: 91F3 6C72 F465 5E98 C246 61D9 2C32 8E24 097B B4E2
     
    Oscar kind, Aug 16, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Betty
    Replies:
    1
    Views:
    10,288
    Juha Laiho
    May 21, 2005
  2. Jesus M. Salvo Jr.
    Replies:
    2
    Views:
    4,515
    robert
    Feb 11, 2006
  3. Bruce
    Replies:
    4
    Views:
    967
    Bjorn Abelli
    Mar 25, 2006
  4. Ken North
    Replies:
    0
    Views:
    566
    Ken North
    Apr 17, 2004
  5. Hubert Hung-Hsien Chang
    Replies:
    2
    Views:
    751
    Michael Foord
    Sep 17, 2004
  6. Mara Guida

    const and array of array (of array ...)

    Mara Guida, Sep 2, 2009, in forum: C Programming
    Replies:
    3
    Views:
    832
    David RF
    Sep 3, 2009
  7. Tom
    Replies:
    3
    Views:
    412
    salsablr
    Dec 20, 2004
  8. Tuan  Bui
    Replies:
    14
    Views:
    794
    it_says_BALLS_on_your forehead
    Jul 29, 2005
Loading...