Url Syntax for invoking adminitrative task on mysql database

[David <ac...@yahoo.es>]

Dear memebers,

I am using the following task for invoking some administrative task on mysql
database, but I guess the syntax is not properly for the
  <sql
    classpathref ="db.driver.classpath"
    driver   ="${db.driver}"
    url      ="${db.admin.url}"
    userid   ="${db.admin.username}"
    password ="${db.admin.password}"
    src      ="${sql.dir}/create-database-${db.driver.name}.sql"
    print    ="true"
    output   ="${build.log.dir}/db.out"
  />

where:
db.admin.url = jdbc:mysql://localhost:3306

If I run this, I get the following error:

BUILD FAILED

P:\SLZ\AMENA-CC\build.xml:276: java.sql.SQLException: No suitable Driver for
jdbc:mysql://localhost:3306

Total time: 1 second

So, probably I am making some mistake on the url definition, do you have any
idea about how to define for sucha administrative task?

the script file look like this:

-- creates the database (called 'cac'), (sans relations)
-- for MySQL 4.1 or later

CREATE DATABASE cac;
USE cac;
-- creates the default dev user and grants a set of privileges to said
user...
GRANT USAGE ON  *.* TO dev@'localhost' IDENTIFIED BY 'dev00';
GRANT ALL PRIVILEGES ON *.* TO 'dev'@'localhost' IDENTIFIED BY 'dev00'
-- GRANT DROP ON   *.* TO dev@'localhost';
-- GRANT SELECT ON *.* TO dev@'localhost';
-- GRANT INSERT ON *.* TO dev@'localhost';
-- GRANT UPDATE ON *.* TO dev@'localhost';
-- GRANT DELETE ON *.* TO dev@'localhost';
-- GRANT CREATE ON *.* TO dev@'localhost';
-- GRANT REFERENCES ON *.* TO dev@'localhost';
-- GRANT INDEX ON *.* TO dev@'localhost';
-- GRANT ALTER ON *.* TO dev@'localhost';
-- GRANT CREATE TEMPORARY TABLES ON *.* TO dev@'localhost';
-- GRANT LOCK TABLES ON *.* TO dev@'localhost';
-- GRANT EXECUTE ON *.* TO dev@'localhost';

Thanks,

David


************************* AVISO LEGAL *************************
Este mensaje y sus documentos anexos son privados y confidenciales y estan dirigidos exclusivamente a sus
destinatarios. Si por error, ha recibido este mensaje y no se encuentra entre los destinatarios, por favor, no use,
informe, distribuya, imprima o copie su contenido por ningun medio. Le rogamos lo comunique al remitente y borre 
todo su contenido.
La empresa no asume ningun tipo de responsabilidad legal por el contenido de este mensaje. Cualquier opinion 
manifestada en el pertenece solo al autor y no representa necesariamente la opinion de la compañía salvo que 
expresamente se especifique lo contrario.
************************* DISCLAIMER **************************
This message and its attached files may contain confidential and/or privileged information. If you are not the addressee
or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message
or any other information herein.  If you have received this message in error, please notify the sender immediately by reply
e-mail and delete this message.
The company does not assume any legal responsability for the contents of this message. Any opinion contained in it belongs
exclusively to its author and does not necessarily represent the company's opinion unless it is specifically expressed on the
contrary.

Re: Url Syntax for invoking adminitrative task on mysql database

[Ray Tayek <rt...@comcast.net>]

At 10:51 AM 11/29/2005, you wrote:
>... BUILD FAILED P:\SLZ\AMENA-CC\build.xml:276: 
>java.sql.SQLException: No suitable Driver for jdbc:mysql://localhost:3306 ...

i had this (but for very different reasons) with mysql 5. updating to 
the most recent driver fixed it.

thanks


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org