3 messages in com.mysql.lists.javaHanging of Update Query at Server!!
FromSent OnAttachments
Shomal Bafna18 Oct 2002 22:40 
Mark Matthews19 Oct 2002 06:27 
Shomal Bafna19 Oct 2002 09:30 
Subject:Hanging of Update Query at Server!!
From:Shomal Bafna (shom@yahoo.com)
Date:10/18/2002 10:40:22 PM
List:com.mysql.lists.java

Hello,

This is my first mail to the lists. I am facing a rather amusing problem with the MySQL Server versions 3.23.41 and 3.23.47.

The 41 version as found on a Mandrake Linux 8.1 Installation Disc installed on a AMD Duron 1100 and 47 version of Mandrake 8.2 on a Intel PIII 500.

The 41 acts a backup server of 47. All the tables are now of BDB Type. Well 'now' bcuz they were MyISAM type earlier and on finding support for BDB i changed the table types to BDB.

Coming to the problem i send a set of SQL Queries in sequence thru JDBC using JDBC Driver mm.mysql-2.0.7 in 41 version and mm.mysql.jdbc-1.2c in 47 version (Comments Please!). Prior to changing my tables to BDB types these queries worked very well but after table type change the queries in 41 version using mm.mysql-2.0.7 would hang on executing at server. And the java application would cease to run as its waiting for a reply from mysql server.

All gurus please give your inferences. Since this being my first mail i am not aware of the lists rules. I hope the list understands.

Is it a problem with drivers or mysql server or with linux version if not these then what?.

regards Shomal

===== shomal