Hello,
Thank you very much for your reply. My problem is quiet different
from the post you linked to me. The previous error seemed occurring
whatever Kevin did (when committing a simple update). My app works fine
until I don't do anything with it for a while (about 40 minutes).
Contrary to Kevin I only use ODBC as I would use it with any Database
Engine.
BUT...
When testing the session_timeout parameter I tried to
decrease/increase its value and to time the exception triggering. It
seemed matching. That's why I thought the parameter was the problem. But
after some more tests (please read the protocol below) I have to
conclude you are about true. The problem is probably not linked to a
session timeout as the session ID before and after the crash are equal.
I'm sure the light isn't so far :-) Thank you for your help.
Kind regards
Xavier.
Test Protocol :
- When I connect I get the parameters from the DOMAIN.CONNECTPARAMETERS.
The timeout is set to 0 and the session ID is 288711
- I wait for the app to crash but thanks to delphi's exception the app
doesn't terminate so...
- I get the session ID again and now it is : 288711
Dirk Lachowski a écrit :
Xavier CAMIER wrote:
MaxDB 7.6.00.12
Delphi 7.1
ODBC 7.06.00
Hello,
When I run my app but don't use it for a while I get a "[MySQL
MaxDB][SQLOD32 DLL][MaxDB] Degree of derived table does not match
column list; -1200 POS(21) Too few values" error message. I thought
that setting the session_timeout parameter to 0 would solve the
problem but it doesn't. I also thought that querying the database
each minute would be a work around but it isn't.
Does anybody know how to keep and app idle without getting that kind
of message and loosing the sessionid ?
Thanks a lot for your help
Kind regards
Xavier
Hi Xavier,
i don't think that this is a session timeout error. I've a long running
application on V 7.6 (running for some weeks now). I've also set the
session timeout to zero and it works fine for me.
Maybe this can help:
http://lists.mysql.com/myodbc/8929
Cheers
Dirk
-----------------------
Lachowski Datensysteme GmbH
Strassburger Platz 25
D-30853 Langenhagen
Fon: +49 511 725353 71
Fax: +49 511 725353 89
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]