Re: Connection problem after long idle periods

David Logan wrote: Michael Lai wrote: I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I can access the database from my JSPs with no problem except for one small issue. After a long delay (usually overnight), when someone first tries to access the database, I would get

Connection problem after long idle periods

I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I can access the database from my JSPs with no problem except for one small issue. After a long delay (usually overnight), when someone first tries to access the database, I would get the following error: Communications

Re: images with mysql

I am now having a database storing images of chinese characters for research purpose. I wrote a program to store and retrieve them. My images are of type ppm. This is how I designed my table: mysql describe poor; +++--+-+-+---+ | Field | Type

Re: images with mysql

it might be quicker.. B. At 18:34 20-03-2003 +, Lai Liu-yuan wrote: I am now having a database storing images of chinese characters for research purpose. I wrote a program to store and retrieve them. My images are of type ppm. This is how I designed my table: mysql describe poor

Re: This query shouldn't be wrong, but mysql says it is???

I reread the mysql manual again, and found the little piece I've missed : version 4!! That's the problem. Thanks for your reply. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

This query shouldn't be wrong, but mysql says it is???

Hi. Here is my table design, my query and the error: mysql describe poor; +++--+-+-++ | Field | Type | Null | Key | Default | Extra | +++--+-+-++ | cc | char(2)

store an array of double to mysql, How?

Hi. I am writing a program to do pattern recognition. I decide to use mysql to store the features calculated. The features are stored as an array of double in my c program. But now I do think about it, I don't know how. I've searched the internet, none really fit my problem. Is there a way to

Is mysql_real_escape_string for blob storage?

Hi, everyone. I use blob to store image data in mysql. I use mysql_real_query to store it, but did not use mysql_real_escape_string to process it before hand. Then I saw in the document that this is needed. But I am testing the data stored by reading them out to do some processing, there seems

Re: Is mysql_real_escape_string for blob storage?

Thanks for your reply. But, what then is the role of mysql_real_query? In document, it says You must use mqsql_real_query for queries that contain binary data? - Before posting, please check: http://www.mysql.com/manual.php

what's wrong with this query?

Please help me with the following c code: sprintf(update, update chrc set center='); len = 24; memcpy(update+len, center, 128); len += 128; sprintf(update+len, ', var='); len += 8;