Leonardo,
Earlier you said that a statement without a parameter ('?') works, but
one with a parameter doesn't.
In both cases, are you still using a PreparedStatement?
-Mark
yes, it is always a preparedstatement.
If you need more details (or you want me to try something else)
Are you using a streaming connection?
ehm... how do I know?
My conn string is
jdbc:mysql://192.168.0.253:3000/LETSPARTY1?autoReconnect=yes
where 192.168.0.253 is a machine on my LAN...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I have also weird results:
I access data by ID, which is a primary key in the table.
Some times (again, very random behaviour) I get 4 rows back
(instead of just 1) and the data I get is always
1275749989
This happens with random IDs.
the code to check this is:
[..]
ResultSet rs =
Dude. I wouldn't post your server ip here. ouch.
Well, it's a LAN address!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A non-streaming connection will place the resultset in memory. With large
tables you can run out of memory and the application will stop.
I get only 1 record per time (accessing by key), so I don't think
it could be an issue.
Thank you anyway!
--
MySQL General Mailing List
For list
of days...
-Messaggio originale-
Da: Leonardo Francalanci [mailto:[EMAIL PROTECTED]
Inviato: martedì 22 giugno 2004 15.09
A: Mysql
Oggetto: R: connectorJ huge table problem
I have also weird results:
I access data by ID, which is a primary key in the table.
Some times (again, very
Leonardo Francalanci [EMAIL PROTECTED] wrote on 22/06/2004
14:26:54:
A non-streaming connection will place the resultset in memory. With
large
tables you can run out of memory and the application will stop.
I get only 1 record per time (accessing by key), so I don't think
it could be
It looks as if you are being over-complex anyway. Isn't what you want
SELECT * FROM PARTITIONED_B ORDER BY RAND() LIMIT 1 ;
which picks a single random record.
No, I have to know which is the ID I pick before doing the select
(because I splitted my data, and when I access the splitted
What happens if you use a nightly snapshot of Connector/J from
http://downloads.mysql.com/snapshots.php?
I tried, but I still have the same problem:
java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 6
at
Next time you come over, maybe you can help hold him or take the shot.
He's such a pain to take pictures of, he walks right up to the camera.
On Tue, 2004-06-22 at 09:50, Leonardo Francalanci wrote:
It looks as if you are being over-complex anyway. Isn't what you want
SELECT * FROM
Next time you come over, maybe you can help hold him or take the shot.
He's such a pain to take pictures of, he walks right up to the camera.
Mmmh... my English is very bad... I can't understand...
is it a joke or just a mistake?
--
MySQL General Mailing List
For list archives:
to:
Subject: R: R: R: connectorJ huge
table problem
06/22/2004 10:18
Richard F. Rebel wrote:
Next time you come over, maybe you can help hold him or take the shot.
He's such a pain to take pictures of, he walks right up to the camera.
Yeah, I also have problems taking snapshots of my cat... use FEL to
pre-flash so he won't blink when you take the actual
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Leonardo Francalanci wrote:
What happens if you use a nightly snapshot of Connector/J from
http://downloads.mysql.com/snapshots.php?
I tried, but I still have the same problem:
java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 6
14 matches
Mail list logo