Re: varchar and java string in sql query ?

2003-02-21 Thread Max Morawski
Jianping Zhu wrote: I and using mysql-jdbc to do some program. I can insert record to my db by following code: - stmt.executeUpdate("insert into apidbusers values('id', 'jp','zhu','em1','jian180')"); --

Re: Connect to Mysql from java(linux)

2003-01-29 Thread Max Morawski
vim m wrote: Hi: I am new to Mysql. I have installed mysql3.23.55 on linux RH7.1. Now mysql is running successfully on my system. When I try connecting thru java(mysql-connector-java-3.0.1) I am getting an Access Denied error. It says mysql@machinename access denied. Now i tried from command li

Re: Newbie: MySQL + Java + web?

2003-01-03 Thread Max Morawski
Brynley wrote: Anyhow - basically it appears he writes some Java code that contains a MySQL query (which I'm still not sure how is done - but I think I can nut it out) and then "calls" that piece of Java code from within the browser (via HTML) - it is this part that has me bamboozled. Seach f

Re: Ok, i want to restart the mysql

2002-11-08 Thread Max Morawski
Fajar Priyanto wrote: Hmm, thanks all.. But, before I remove the mysql installation, I want to restart it first so that it reads my.cnf file, and see if it corrects the problem. How do I restart the mysql from command prompt? I'm using RH6.2 without XWindows. /etc/init.d/mysqld restart Max

Re: Unable to connect to MySQL using java

2002-10-20 Thread Max Morawski
Muhammad Farhan wrote: HI, I am trying to connect to MySQL using java. I have placed mm.mysql drivers in "jakarta-tomcat/lib" folder. but whenever i try to connect to mysql, i receive this error: Cannot connect to MySQL server on . Is there a MySQL server running on the machine/port you are t

Re: MySQL newbie installation question

2002-10-18 Thread Max Morawski
CM Miller wrote: Very new to MySQL and I've done a search on google.com, but really couldn't find the answer that I am looking for. Where should I install MySQL? I'm running RH 7.3 and I've installed the tgz file under my directory /home/CMMiller, is this right, or anywhere else? I see it is a

Re: JDBC problems

2002-10-18 Thread Max Morawski
mysql,query Lee Denny wrote: I'm trying to use the mm.mysql JDBC drivers on windows NT I've just downloaded the mysql-connector-java-2.0.14.zip file and extracted it into my jdk1.2.2/jre/lib/ext folder. You need to put .jar file (ie. mysql-connector-java-x.x.x-beta-bin.jar) into jre/lib/ext

Compressed JDBC protocol

2002-10-15 Thread Max Morawski
mysql,query Hello! Maybe I've missed something in the docs... how can I turn compression on using JDBC with Connector/J? Or is it turned on by default? If so, how can I check if it's on or off? Regards, Max - Before postin

Re: ERROR 1146

2002-09-22 Thread Max Morawski
hans schneidhofer wrote: >hi list, >trying to do my first steps with mysql, i have done the following : >mysql> USE mysql; >Reading table information for completion of table and column names >You can turn off this feature to get a quicker startup with -A > >Database changed >mysql> INSERT INTO my

Re: Hans Needs Help :D

2002-09-13 Thread Max Morawski
The solution that works best with all broken rpm dependiences is to use --force --nodeps (verify with the man page). HTH, Max spam filter pass: sql,query - Before posting, please check: http://www.mysql.com/manual.php

Re: mysql console buzzer problem

2002-08-16 Thread Max Morawski
Victoria Reznichenko wrote: >Max, >Friday, August 16, 2002, 11:36:19 AM, you wrote: > >MM> I can't find a way to turn off buzzer (PC speaker) in mysql console. Am >MM> I missing something or is it impossible and I should report user >MM> interface bug to bugs mailing list? > >Option --no-beep f

Re: mysql console buzzer problem

2002-08-16 Thread Max Morawski
Mikhail Entaltsev wrote: >>It's making loud noise on each error. It is *extremely* annoying. >> >> >Try to use these ways: >1. -s, --silent option in mysql console. I don't know what does it mean (in >doculmentation I found only "Be more silent."), but may be it will help you. > No change. >

Re: mysql console buzzer problem

2002-08-16 Thread Max Morawski
Mikhail Entaltsev wrote: >What's wrong with your PC speaker in mysql console?! >I am using the same version and have no problem with it. > > It's making loud noise on each error. It is *extremely* annoying. Max - Before pos

mysql console buzzer problem

2002-08-16 Thread Max Morawski
Hello! I can't find a way to turn off buzzer (PC speaker) in mysql console. Am I missing something or is it impossible and I should report user interface bug to bugs mailing list? mysql console version : 11.18 distribution 3.23.51 System: Windows 2000 Max --