Re: JDBC driver problem with sql LIMIT

2005-03-30 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 l'eau wrote: > > Using MySql Connect/J (mysql-connector-java-3.1.7.tar) > on Linux Fedora 2. > > I use a Statement object and do the following query: > > String myquery = "SELECT * FROM term WHERE name REGEXP (\'"+ name > +"\') and

JDBC driver problem with sql LIMIT

2005-03-30 Thread l'eau
Using MySql Connect/J (mysql-connector-java-3.1.7.tar) on Linux Fedora 2. I use a Statement object and do the following query: String myquery = "SELECT * FROM term WHERE name REGEXP (\'"+ name +"\') and term_type=\'"+ ontology +"\' LIMIT 20"; table term has 6 columns. MySql

Re: MySQL JDBC driver problem

2003-03-17 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shu-Ping Lin wrote: > Hi, How are you? > > I have a problem to jdbc driver. My paltform is win2000 professional and > MySQL Server's version is 3.23.55. > > I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some > problems to this

MySQL JDBC driver problem

2003-03-16 Thread Shu-Ping Lin
Hi, How are you? I have a problem to jdbc driver. My paltform is win2000 professional and MySQL Server's version is 3.23.55. I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some problems to this jdbc driver version. When i use some method about setting or getting String suc

Re: JDBC driver problem

2002-06-20 Thread Francisco Reinaldo
Which driver are you using? I use mm.mysql-2.0.4-bin.jar Which IDE are you using? If you are using JBuilder 5, you have to go to required library and add one pointing to that file. If you are building a jar file from your classes, you have to make sure that you tell the library to include this JD

Re: JDBC driver problem

2002-06-20 Thread Alec . Cawley
> I have a problem with the installation of the JDBC driver for Mysql. > I have Windows XP and Java2 SDK 1.4.01 > I tried to install the JDBC driver org.gjt.mm.mysql.Driver but every time I > try to connect to my database, I get a ClassNotFoundException: > org.gjt.mm.mysql.Driver error, although

Too big for max_allowed_packet - service problem or JDBC driver problem?

2001-10-19 Thread Peter Bailey
I'm developing a Java application that uses a pool of JDBC connections to store and retrieve data in a MySQL database. I'm using the 3.23.38 Win32 version of MySQL, on Windows 2000 Professional, and the mm.mysql-2.0.4 JDBC driver. I'm using a table with a MEDIUMTEXT field, which the MySQL docume