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.
