15 messages in com.mysql.lists.plusplusConnection always on and field names
FromSent OnAttachments
Wolfram Arnold06 Jul 2005 01:15 
Chris Frey06 Jul 2005 03:39 
Wolfram Arnold06 Jul 2005 08:22 
Warren Young06 Jul 2005 10:51 
Warren Young06 Jul 2005 10:52 
Chris Frey06 Jul 2005 12:42 
Warren Young06 Jul 2005 13:50 
Chris Frey06 Jul 2005 15:25 
Warren Young06 Jul 2005 19:23 
Chris Frey07 Jul 2005 19:11 
Warren Young07 Jul 2005 23:25 
Brian Farmer14 Jul 2005 06:58 
Warren Young14 Jul 2005 11:49 
Ankur G35 Saxena16 Jul 2005 19:20 
Warren Young18 Jul 2005 05:05 
Subject:Connection always on and field names
From:Ankur G35 Saxena (g35r@gmail.com)
Date:07/16/2005 07:20:53 PM
List:com.mysql.lists.plusplus

Hi,

I am using mysql++ very lightly..connect to a DB, run a select/insert/update and use the result set. Now I have 2 things I want to do...One I want to figure how to keep the connection always on and be able to check if the connection has disconnected and if so, then connect to the db again.

Is it a big overhead to keep connecting every 1/2 a sec or so? If it is then I would like to have this feature where I can probably set a idle time out and be able to check of the connection is down.

Also how do I get how many filed are returned by a select * from query. I know how to get how many rows, but the col number and names, how do I get that?

I have few other questions which I will send in a seperate email once I am alittle clear as to what I want to do.

Thanks a ton

AS