origine-
De : huanggaofeng [mailto:[EMAIL PROTECTED]
Envoyé : 27 avril 2005 08:50
À : mysql@lists.mysql.com
Objet : java.lang.OutOfMemoryError
I have too many databases,when i select it by client ,but it has error .
the error message is : java.lang.OutOfMemoryError
how i can to resolve it.
-
gerald_clark wrote:
>huanggaofeng wrote:
>
>
>
>>I have too many databases,when i select it by client ,but it has error .
>>
>>the error message is : java.lang.OutOfMemoryError
>>
>>how i can to resolve it.
>>
>>
>>
>>
>&
huanggaofeng wrote:
(B
(B>I have too many databases,when i select it by client ,but it has error .
(B>
(B>the error message is : java.lang.OutOfMemoryError
(B>
(B>how i can to resolve it.
(B>
(B>
(B>
(BYou might try a java list.
(B
(B
(B--
(BMySQL General
I have too many databases,when i select it by client ,but it has error .
(B
(Bthe error message is : java.lang.OutOfMemoryError
(B
(Bhow i can to resolve it.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John McCaskey wrote:
| The problem is not the memory on the database server, but on the client
| running the JDBC connection. Seems that when you retrieve the result it
| is trying to store everything in memory at once.
|
| Here is some info from the m
eStatement("Select
> logid,timestamp,Timestamp2,Tag from Table1");
> Resultset rs = pst.executeQuery(); //getting
> java.lang.outOfMemoryError here, even before retrieving the resultset
> below.
> While (rs.next())
> {
> //check something, do something
elect
logid,timestamp,Timestamp2,Tag from Table1");
Resultset rs = pst.executeQuery(); //getting
java.lang.outOfMemoryError here, even before retrieving the resultset
below.
While (rs.next())
{
//check something, do something..
}
... Tried the same thing above doing
