Professional Web Applications Themes

java ResultSet size - MySQL

let's say I did a simple query on a database like show tables; in java, i get a ResultSet how can I get the total number of rows in the ResultSet? i tried getFetchSize(), but it seems it doesn't work (unless i'm missing something) i don't want to do last() and then getRow() i'm sure there's a better method to do that thanks in advance for your help Nicola...

  1. #1

    Default java ResultSet size

    let's say I did a simple query on a database like
    show tables;
    in java, i get a ResultSet
    how can I get the total number of rows in the ResultSet?
    i tried getFetchSize(), but it seems it doesn't work (unless i'm missing
    something)

    i don't want to do
    last()
    and then
    getRow()
    i'm sure there's a better method to do that

    thanks in advance for your help
    Nicola
    monty Guest

  2. #2

    Default Re: java ResultSet size

    As far as I remember, there is no way to directly query the number of
    rows in a resultset.

    Daniel
    Daniel Schneller Guest

  3. #3

    Default Java ResultSet Size

    There is no direct method to get the count . either u should iterate result set or u should use
    rs.last and rs.getRow.
    Unregistered Guest

Similar Threads

  1. Mapping Java ResultSet to Flex
    By Anurag Mishra in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: January 4th, 08:55 AM
  2. file size and JAVA script
    By Frank_Steffenhagen@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 2
    Last Post: January 5th, 10:52 AM
  3. Replies: 5
    Last Post: July 25th, 05:51 PM
  4. resultset.close()
    By xixi in forum IBM DB2
    Replies: 3
    Last Post: July 14th, 05:04 PM
  5. Setting shared pool size and Java pool size on 9i
    By Howard J. Rogers in forum Oracle Server
    Replies: 1
    Last Post: December 11th, 09:17 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139