From user-return-59470-apmail-ant-user-archive=ant.apache.org@ant.apache.org Fri Jan 19 22:39:24 2007
Return-Path: <user-return-59470-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 33557 invoked from network); 19 Jan 2007 22:39:23 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 19 Jan 2007 22:39:23 -0000
Received: (qmail 66309 invoked by uid 500); 19 Jan 2007 22:39:21 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 66274 invoked by uid 500); 19 Jan 2007 22:39:21 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 66250 invoked by uid 99); 19 Jan 2007 22:39:21 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Jan 2007 14:39:21 -0800
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of farid.izem@gmail.com designates 64.233.182.188 as permitted sender)
Received: from [64.233.182.188] (HELO nf-out-0910.google.com) (64.233.182.188)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Jan 2007 14:39:12 -0800
Received: by nf-out-0910.google.com with SMTP id o63so575831nfa
        for <user@ant.apache.org>; Fri, 19 Jan 2007 14:38:51 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=JuF7v/1N7yuuzYEn/k7uABewQDv7I2hhQgLKJ+jPGJC48fTFzawmSIisNpA7NI33Ecuzuu1rfn8d+Pe3v2yPl33o8yuHxpcx670Ht3tOzAvtTO4aAx1w1M7yDX3WZsRZWmpU6ap3sfIE6QdgjbmjlqaTeLYEya3AVAJjUSUBuiw=
Received: by 10.49.8.16 with SMTP id l16mr2964687nfi.1169246330742;
        Fri, 19 Jan 2007 14:38:50 -0800 (PST)
Received: by 10.78.68.4 with HTTP; Fri, 19 Jan 2007 14:38:50 -0800 (PST)
Message-ID: <8f2acb460701191438r98f196fl23f794ff33c32bd4@mail.gmail.com>
Date: Fri, 19 Jan 2007 23:38:50 +0100
From: "Farid Izem" <farid.izem@gmail.com>
To: user@ant.apache.org
Subject: Question about Classpath
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_117554_22736700.1169246330501"
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_117554_22736700.1169246330501
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,

I'm new to ant and i d'like to make a connexion to a mysql database.
To do that, i hava done the following scripts :


<project basedir="/projets/ESE/esepro02" default="mysql">

        <description>
                main project with many futures
        </description>

        <path id="projet.classpath">
            <pathelement location="classes/" />
            <pathelement location="lib/" />
        </path>


        <target name="mysql">
                <sql
                        driver="com.mysql.jdbc.Driver"
                        url="jdbc:mysql//localhost:3306/BROWSE"
                        userid="XXXXX"
                        password="YYYYY"
                ><![CDATA[
                        show tables;
                ]]>
                </sql>
        </target>

</project>

But, i get the following error :

mysql:

BUILD FAILED
/LNXVOL01/projets/ESE/esepro02/build2.xml:19: Class Not Found: JDBC driver
com.mysql.jdbc.Driver could not be loaded

I try adding <classpath refid="projet.classpath" /> in the mysql task
without success, i get the following error :

Buildfile: build2.xml

mysql:

BUILD FAILED
/LNXVOL01/projets/ESE/esepro02/build2.xml:14: Problem: failed to create task
or type classpath
Cause: The name is undefined.
Action: Check the spelling.
Action: Check that any custom tasks/types have been declared.
Action: Check that any <presetdef>/<macrodef> declarations have taken place.

Can anyone help solving this issue with the classpath element.

I'm using ant 1.7.0 and JVM 1.5.0_10-b03



Kind Regards,

Farid

------=_Part_117554_22736700.1169246330501--