Return-Path: 
 <user-return-41387-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 49362 invoked from network); 25 Feb 2004 21:19:08 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 25 Feb 2004 21:19:08 -0000
Received: (qmail 13106 invoked by uid 500); 25 Feb 2004 21:18:47 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 13034 invoked by uid 500); 25 Feb 2004 21:18:45 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Subscribe: <mailto:user-subscribe@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 13019 invoked from network); 25 Feb 2004 21:18:45 -0000
Received: from unknown (HELO relay.t-online-com.de) (62.156.147.74)
  by daedalus.apache.org with SMTP; 25 Feb 2004 21:18:45 -0000
Received: from antbuild.com (internet-cafe-167.sapinternetcafe.de
 [155.56.24.167])
	by relay.t-online-com.de (SMTPSVC(1.0.0.1)) with ESMTP id 4E4EC150029
	for <user@ant.apache.org>; Wed, 25 Feb 2004 21:55:00 +0100 (CET)
Message-ID: <403D10B6.5070108@antbuild.com>
Date: Wed, 25 Feb 2004 22:16:38 +0100
From: =?ISO-8859-1?Q?Antoine_L=E9vy-Lambert?= <antoine@antbuild.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.6b) Gecko/20031205 Thunderbird/0.4
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Ant Users List <user@ant.apache.org>
Subject: Re: WindowsXP - JDBC and property files
References: <F3E4AE30B8A9C84FBC868F4F3348D46356A60D@pgas-mail.pgas.pgas.com>
In-Reply-To: <F3E4AE30B8A9C84FBC868F4F3348D46356A60D@pgas-mail.pgas.pgas.com>
X-Enigmail-Version: 0.82.4.0
X-Enigmail-Supports: pgp-inline, pgp-mime
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Mario Manfre wrote:

>I've run across a problem where it seems like on an XP machine the property files variables are padded.
>
>  
>
Hi,

I do not think that property files are padded on Windows XP, but you 
need to remove any trailing blanks in the value part of property files 
contents when the
properties are going to be used by the SQLExec task.

right
dbuser=johnsmith<crlf>

wrong
dbuser=johnsmith<space><crlf>

Now I do not have experience with Windows XP. Why do you say that 
property files are padded on Windows XP ?
Are you talking about property files generated automatically by, say 
Microsoft SQL server ?
If you are bothered by this problem, you might want to see if you can 
using <replaceregexp> (ant task) remove trailing blanks in your property 
file,
then load the property file.
To check the values of your properties, use <echo 
message="&lt;${my.property}&gt;"/>

If the content of my.property appears followed by spaces before the > 
sign, then  yes, your property file has trailing spaces and the values 
are not adequate
to be used in the sqlexec task.

Cheers,

Antoine

>I have a file user.properties which contains the following..
>
>jdbc-connect-db=TestDB1
>db.user=TestUser
>db.user.password=Testing_01 
>jdbc-connect=jdbc:microsoft:sqlserver://SQL-DB:1433;databasename=${jdbc-connect-db}
>dbDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver
>
>
>when I run my ant script from windows2000 all is well, when I run it on XP I get a sql login fail error for user 'TestDB1                         '
>
>If i change the above to look like
>
>   <property name="db.user" value="TestUser" />  
>   <property name="db.user.password" value="Testing_01" /> 
>
>everything works fine. Is there something simply not installed properly on the machine (maybe) or is this a known issue? If so any ideas for a work around.
>
>Mario Manfre
>  
>




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