ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antoine Levy-Lambert" <anto...@antbuild.com>
Subject Re: Using <sql> task to create SQLServer stored procs
Date Mon, 07 Jul 2003 09:04:49 GMT
You need to do :
<sql keepformat="true" ...
Antoine
----- Original Message -----
From: "Chris Doran" <cdoran@pts.com>
To: "Ant Users List" <user@ant.apache.org>
Sent: Monday, July 07, 2003 10:54 AM
Subject: Re: Using <sql> task to create SQLServer stored procs


> Hi Antoine
>
> This is really just a question about whitespace. My ant build runs without
> error, fetching sql script files from VisualSourceSafe and deploying them
> via an sql task. It just so happens that each script creates a stored
> procedure. The stored procedures all work fine after the ant deployment -
> it's just that the cr/lf's are missing when they are viewed through
> Microsoft's Enterprise Manager.
>
> So the question is 'Is it reasonable to expect these formatting characters
> to be preserved' ? After following Rob's link below, it looks like there's
> an attempt to do this in the source in SQLExec.java using the keepformat
> attribute, but this defaults to 'false.' Not sure how to make this 'true'.
>
> Thanks
> Chris
>
> At 19:34 04/07/2003 +0200, you wrote:
> >Hi Chris,
> >can you explain a bit more what the problem is :
> >- sample build.xml,
> >- error output,
> >- output from ant -verbose
> >- what should be corrected in your view,
> >Antoine
> >----- Original Message -----
> >From: "Chris Doran" <cdoran@pts.com>
> >To: "Ant Users List" <user@ant.apache.org>
> >Sent: Friday, July 04, 2003 6:37 PM
> >Subject: RE: Using <sql> task to create SQLServer stored procs
> >
> >
> > > I've now had a chance to try this, but the problem still exists.
> > >
> > > At 10:21 02/07/2003 -0700, you wrote:
> > > >This issue has been fixed in ant 1.6 beta. Download a nightly build
and
> >your
> > > >problem should be resolved. Here is the link to the bug in
bugzilla...
> > > >
> > > >http://nagoya.apache.org/bugzilla/show_bug.cgi?id=10719
> > > >
> > > >-Rob A
> > > >
> > > >-----Original Message-----
> > > >From: Chris Doran [mailto:cdoran@pts.com]
> > > >Sent: Wednesday, July 02, 2003 9:15 AM
> > > >To: user@ant.apache.org
> > > >Subject: Using <sql> task to create SQLServer stored procs
> > > >
> > > >
> > > >Hi All
> > > >
> > > >I've written a build.xml that retrieves several sqlserver scripts
from a
> > > >VisualSourceSafe repository. Each of these creates a stored procedure
> >that
> > > >contains microsoft specific wrapper code to drop the stored proc if
it
> > > >already exists before recreating it. In essence each script contains
> > > >batches that are separated by the text 'GO'.
> > > >
> > > >Setting the src task delimiter attribute to 'GO' ensures each script
runs
> > > >correctly.
> > > >
> > > >However, when I view my stored procs via sqlserver's enterprise
manager,
> > > >each stored proc appears as a single line, making it difficult to
read.
> > > >
> > > >Any way I can maintain the cr/lf's in the original script files ?
> > > >
> > > >Thanx
> > > >
> > > >
> > > >---------------------------------------------------------------------
> > > >To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> > > >For additional commands, e-mail: user-help@ant.apache.org
> > > >
> > > >---------------------------------------------------------------------
> > > >To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> > > >For additional commands, e-mail: user-help@ant.apache.org
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> > > For additional commands, e-mail: user-help@ant.apache.org
> > >
> > >
> >
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> >For additional commands, e-mail: user-help@ant.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>



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


Mime
View raw message