java interface with mysql

2001-06-07 Thread Dacian Herbei
Hi, I found something peculiar that happens when I try to use more then one databases at the same time via java. I wrote my own "driver" which is very basic. I attached the error log and the files maybe someone can give me an explanation. If I open only one

mysql jdbc driver

2001-05-31 Thread Dacian Herbei
Hi, I'm using mm.mysql driver version 2.0.4 and jdk.1.3. Actually I'm trying to us it because it keeps on giving me Not suitable driver error. For test I used the JDBCBench.java. try { Class.forName("org.gjt.mm.mysql.Driver");

add index on text

2001-04-01 Thread Dacian Herbei
Hi Can anyone help me? I'm trying to put an index on a text column named invariant. I tried this command : alter table cinvariant add index (invariant); I got this: ERROR 1170: BLOB column 'invariant' used in key specification without a key length ok so I tried this alter tabl

tinyint issue

2001-03-27 Thread Dacian Herbei
Hi, I wonder if anyone had a problem like this one. I have created a table with one field autoincrement. The field is tinyint(4). whenever I try to introduce more then 127 records it refuses to introduce them. I tried with tinyint(5) 6.. and so on. It works only with integer.

query speed issues

2001-03-16 Thread Dacian Herbei
Hi, I have some huge databases generated from text file of a dictionary. I would like to know if I make a query based on a field which was not metion as a key at the creation of the table. Is the speed of the query affected by the size of the records and by the number of fields a rec