HELP!! java.lang.OutOfMemoryError

Discussion in 'Java' started by wneumann@awne.de, Jul 21, 2004.

  1. Guest

    Hi all,

    in a java-application i've got the following problem:

    In a JPanel with several JTextFields i start a sql-query to a address
    table. This query will be started
    on the CaretUpdate-Event, because i want to get the result when ever i
    change the field-contents.

    This query runs on 8 fields in a very good performance (e.g. on name,
    city,street,phonenumber ...), but if
    i change the entry for the areacode the performance is really terrible
    (about 20 sec) and after 4 or 5 queries
    i get the java.lang.OutOfMemoryError!!??
    The resultset contains as max. 7000 records, but i think that's not the
    problem, because if i ask for
    all addresses in the 'name-field' there are no problems.

    Do you have any idea what's wrong ??

    On the CaretChangedEvent the following code will be started:

    private void getAddress(){
    ....

    String command = "SELECT FIELDLIST FROM ADDRESS WHERE NAME LIKE
    'W%' ORDER BY NAME" // that works!!

    String command = "SELECT FIELDLIST FROM ADDRESS WHERE AEREACODE
    LIKE '04%' ORDER BY NAME" // that do'nt work!!

    }

    The evironment :
    Java 1.4.0.13
    OS Windows 2000
    SQL mySQL 4.0.13 nt

    th.i.a
    Wolfgang
    , Jul 21, 2004
    #1
    1. Advertising

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. Ian Suttle
    Replies:
    2
    Views:
    2,287
    Wolfram Rittmeyer
    Aug 27, 2003
  2. Xiaopeng Xiong

    java.lang.OutOfMemoryError problem

    Xiaopeng Xiong, Nov 14, 2003, in forum: Java
    Replies:
    3
    Views:
    428
    Xiaopeng Xiong
    Nov 15, 2003
  3. ckumar
    Replies:
    15
    Views:
    6,228
    ckumar
    Feb 26, 2005
  4. Cathy  Hui
    Replies:
    7
    Views:
    13,653
    John C. Bollinger
    Jun 6, 2005
  5. Goofball
    Replies:
    9
    Views:
    750
    Goofball
    Nov 8, 2006
Loading...

Share This Page