I'm trying to understand this error:
java.sql.SQLException: Server connection failure during transaction.
Attempted reconnect 3 times. Giving up.
the java program is trying to connect to MySQL (5.0.19 under Mac OSX/
PPC), with user=root, from localhost.
the grant privileges seems to be ok (I'm
Ports closed?
Wrong ports configured?
I don't think so, since even with "telnet localhost 3306" or "telnet
127.0.0.1 3306" I'm able to see the server prompt..
and I'm using the standard MySQL port for sure (it's a clean
installation); and there are no firewall active...
any other suggesti
Wild stab in the dark here - Java I/O permissions not set correctly
on your
machine to allow it? If I recall, Java's sandbox feature means you
have to
supply a permissions file for I/O. Perhaps that file already exists
on the
other machine that works?
I don't know so much Java, but I didn'
does the "lock table" on MySQL (I'm using 5.0.22 or 5.0.45) works
even for a cached result?
this is my scenario, (I'm using MyIsam tables)
thread 1:
LOCK TABLE foo WRITE;
thread 2:
SELECT * FROM foo ;
(locked)
thread 1:
UNLOCK TABLES;
thread 2:
result of SELECT * ..
and that's is, IMHO, co
Hi.
I need to have a cardinal number near each data, when I submit a query:
for example, if my table is:
+-+
| example |
+-+
| cat |
| dog |
| horse |
I'd like to have, with a "select" statement..
+-+---+
| example |
>It's not clear from your description whether the numbers are
>associated with the records in the table or with the records returned
I'm trying to choose a subset only of the select result...
(without having any informations about the db/data structure)
>should be handling in whatever you're
>IMHO, The Right Thing to do this, is to create the additional data in
>your application (as you said you won't change the table).
(...)
thank you!
>If you want this with SQL for sure, using user-defined variables will
>work:
cool. sorry, but I'm still learning, since I'm into MySQL from a fe
>No you can't, but check out LIMIT.
Ops, but I did it!
Using a variable and a temporary table as Benjamin and Keith wrote in the
prev. messages
ciao ciao!
MAS!
--
I love MySQL :-)
-
Befor
This is the first public release for "my_gui".
my_gui.py is a simple Grafic User Interface for MySql.
It can be used as a Python module to create your own MySQL interface.
Sorry, no documentation yet
download it at http://www.prosa.it/projects/projects
MAS
