Return-Path: Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 57513 invoked by uid 500); 12 Aug 2003 17:28:17 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 57498 invoked from network); 12 Aug 2003 17:28:17 -0000 Received: from ip207-101-87-194.z87-101-207.customer.algx.net (HELO mail.funnygarbage.com) (207.101.87.194) by daedalus.apache.org with SMTP; 12 Aug 2003 17:28:17 -0000 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: RE: SQL Exception when using torque Date: Tue, 12 Aug 2003 13:28:19 -0400 Message-ID: <794AA7B1BE0DB2458F738486D7353943BF5365@mail.funnygarbage.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SQL Exception when using torque Thread-Index: AcNg9iAf9ax9uxTIQuutvfhcf5eqcAAAGABA From: "Russell Simpkins" To: "Apache Torque Users List" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N try to change your torque to use localhost instead of 127.0.0.1 -----Original Message----- From: Parsh Wanath [mailto:parsh@datumsoftware.com] Sent: Tuesday, August 12, 2003 1:28 PM To: Apache Torque Users List Subject: RE: SQL Exception when using torque I am able to connect as mysql -uabc -pabc -hlocalhost abc has all privilages except grant -----Original Message----- From: Mark Lowe [mailto:mark.lowe@talk21.com] Sent: Tuesday, August 12, 2003 12:23 PM To: Apache Torque Users List Subject: Re: SQL Exception when using torque what privileges had abc have? if you're looking at just getting up n=20 running just create the db and the rest should work fine.. i assume that > mysql -u abc -pabc -h localhost works.. sorry if thats not helpful, worth asking though.. cheers mark On Tuesday, August 12, 2003, at 05:21 PM, Parsh Wanath wrote: > Hi, > I am using torque and mysql. I had written some code which is working=20 > fine. > I passes this code to someone and it isnt working. > > When i do (which is trying to create a database) > > ">>>ant -f build-torque.xml create-db" > > i get the following error > > "java.sql.SQLException: Cannot connect to MySQL server on=20 > 127.0.0.1:3306. Is > there a MySQL server running on the machine/port you are trying to=20 > connect > to? (java.net.ConnectException)" > > My properties file looks like > > torque.database.createUrl =3D jdbc:mysql://127.0.0.1:3306/ > torque.database.buildUrl =3D=20 > jdbc:mysql://127.0.0.1:3306/${torque.project} > torque.database.url =3D jdbc:mysql://127.0.0.1:3306/${torque.project} > torque.database.driver =3D com.mysql.jdbc.Driver > torque.database.user =3D abc > torque.database.password =3D abc > torque.database.host =3D 127.0.0.1 > > I am able to connect to mysql using the command > >>>> mysql --user=3Dabc --password=3Dabc --port=3D3306 > > Could any one suggest what is possibly wrong? > > Regards > Parsh > > PS: I did see a message in the list with simillar problem, but i am > consistent with reply > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org > For additional commands, e-mail: torque-user-help@db.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org