Return-Path: 
 <ant-user-return-17276-qmlist-jakarta-archive-ant-user=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-ant-user-archive@apache.org
Received: (qmail 99361 invoked from network); 11 Feb 2002 09:40:38 -0000
Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131)
  by daedalus.apache.org with SMTP; 11 Feb 2002 09:40:38 -0000
Received: (qmail 15287 invoked by uid 97); 11 Feb 2002 09:40:13 -0000
Delivered-To: qmlist-jakarta-archive-ant-user@jakarta.apache.org
Received: (qmail 15213 invoked by uid 97); 11 Feb 2002 09:40:12 -0000
Mailing-List: contact ant-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:ant-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:ant-user-subscribe@jakarta.apache.org>
List-Help: <mailto:ant-user-help@jakarta.apache.org>
List-Post: <mailto:ant-user@jakarta.apache.org>
List-Id: "Ant Users List" <ant-user.jakarta.apache.org>
Reply-To: "Ant Users List" <ant-user@jakarta.apache.org>
Delivered-To: mailing list ant-user@jakarta.apache.org
Received: (qmail 15202 invoked from network); 11 Feb 2002 09:40:12 -0000
Message-ID: <AA203E4C7649D511A4C300508BCDF0D17237E1@BUILDFP1>
From: Euan Guttridge <EGuttridge@buildonline.com>
To: 'Ant Users List' <ant-user@jakarta.apache.org>
Subject: RE: Sql task ignoring classpath
Date: Mon, 11 Feb 2002 09:44:08 -0000
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Thanks Adam.. this obviously solved the problem.

-----Original Message-----
From: Adam Murdoch [mailto:adammurdoch_ml@yahoo.com]
Sent: 08 February 2002 20:16
To: Ant Users List
Subject: RE: Sql task ignoring classpath




> -----Original Message-----
> From: Euan Guttridge [mailto:EGuttridge@buildonline.com]
> Sent: Saturday, 9 February 2002 3:47 AM
> To: 'ant-user@jakarta.apache.org'
> Subject: Sql task ignoring classpath
>
>
> Hi,
>
> Ant seems to be refusing to recognise my system classpath (W2K).
> I am using
> a jdbc:odbc driver in an SQL task, the driver is in the system classpath,
> tested and confirmed. Even with the optional classpath attribute
> in the SQL
> task I still get the not found error:
>
>
> D:\build_folder\ux_dev02\ant_buildfiles\dev2_to_staging2.xml:26: Class Not
> Found
> : JDBC driver sun.jdbc.odbc.JbdcOdbcDriver could not be loaded
>
>
> <target name="sql">
>  <sql
>     driver="sun.jdbc.odbc.JbdcOdbcDriver"
                            ^^^^

Should be Jdbc, not Jbdc.

Also, you don't need rt.jar in the classpath - you get that for free from
the JVM.


>     url="jdbc:odbc:label_db"
>     userid=""
>     password=""
>  >
> select * from *;
> <classpath>
>  <pathelement location="d:\jdk_1.2.2\jre\lib\rt.jar"/>
> </classpath>
> </sql>
> </target>
>
>
> Thanks..
>
> --
> To unsubscribe, e-mail:   <mailto:ant-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
<mailto:ant-user-help@jakarta.apache.org>


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

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