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

RE: Driver problem

2001-11-22 Thread Venu
Hi Satish, > -Original Message- > From: K. Satish Kumar [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 22, 2001 10:55 PM > To: [EMAIL PROTECTED] > Cc: Apparsamy perumal > Subject: Driver problem > > > Hi! > > This is Satish. I am using your my

Driver problem

2001-11-22 Thread K. Satish Kumar
Hi! This is Satish. I am using your mysql software for administering my database. We have developed an application using VB as the front end and mysql as the back end on all the windows plaforms(NT, 95,98,2000,ME). The problem where we are facing is while installing the driver. It works fine w

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

Re: driver problem

2001-08-01 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Uwe Heldt writes: >> Hi Venu, >> >> it ' s hard to send you sample code. The database access is coded over more >> then one class which dynamicly build sql statements. The only thing i know >> is, that first a simple

Re: driver problem

2001-07-30 Thread Sinisa Milivojevic
Uwe Heldt writes: > Hi Venu, > > it ' s hard to send you sample code. The database access is coded over more > then one class which dynamicly build sql statements. The only thing i know > is, that first a simple select is performed. After that one update on the > same table row and then a select

Re: driver problem

2001-07-29 Thread Uwe Heldt
CTED]> Sent: Sunday, July 29, 2001 5:44 PM Subject: RE: driver problem > Hi ! > > Can you please send us the reproducible sample code ? So that we can figure > out the things. > > Thanks in advance > Venu > > > -Original Message- > > From: Uwe Heldt [m

RE: driver problem

2001-07-29 Thread Venu A
Hi ! Can you please send us the reproducible sample code ? So that we can figure out the things. Thanks in advance Venu > -Original Message- > From: Uwe Heldt [mailto:[EMAIL PROTECTED]] > Sent: Sunday, July 29, 2001 6:28 AM > To: [EMAIL PROTECTED] > Subject: driver probl

driver problem

2001-07-29 Thread Uwe Heldt
Hi all, i have a problem with the mysql driver. I have developed some java classes to read and write from the database. These classes uses very simple sql statements like insert or update. But sometimes (50%) when i perform a update a got the following exception. java.sql.SQLException: Communi