Re: How Long is TEXT?

2001-07-11 Thread Kaneda K
At 22:41 10/07/2001 +0200, you wrote: > > after reading the excellent docs, I was just a little confused as to the > > actual length of the TEXT datatypes. Are they really as long as you like? > >See http://www.mysql.com/doc/n/o/node_180.html > > > And does anyone have any tips for indexing (searc

Re: Creating Table with a Default Datetime field

2001-06-28 Thread Kaneda K
At 10:38 27/06/2001 -0700, you wrote: >Sorry, for quoting the manual but this might be just another example where >it could have the answer right away: >Hannes > >http://www.mysql.com/doc/D/A/DATETIME.html On my own mysql version : Date TIMESTAMP default "now()", Works correctly, the date is YY

Log the connections

2001-04-24 Thread Kaneda K
hi All, I have in Tomcat JDBCRealms, A broken pipe SQLException, So I wonder what is wrong in my code. This exception occur only after a long period of time, while sessions should be dead long times ago. So I wonder if the connection Pool I use ( org.ewin packadge ), released correctly the

Re: java.sql.SQLException *SOLVED*

2001-04-05 Thread Kaneda K
At 15:35 30/03/2001 -0800, you wrote: >HI > I am using MySQL 3.23 on Windows 2000 and mm.mysql.jdbc-1.2c but when I > run my servlet it gives me communication link failure error... > please help in solving this error.. > Thanks Update your Driver, This version has a bug (the exception is bad

Re: signal 11, segmentation fault :(

2001-03-28 Thread Kaneda K
I had this segmentationone but that was using java (1.3 form IBM on Red Hat 6.2) and that was an exception that stopped my Web Apps I switch both jdk (I use Sun know) and driver mm...2.0.2 to 2.0.3 and I never have this exception ever since. I hope that helps. At 18:47 27/03/2001 -0800, you wr

Acces And IP Problemes

2001-03-16 Thread Kaneda K
I have a question about MySQL acces: In order to give access to any user on my server I have to give them "localhost', 'myserverName' and 'MyUserIP' entry in both user and db table, I thought I only had to set '%' in the user.Host columns and db.host = '192.168.111.%' to give access to my user