ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Doran <cdo...@pts.com>
Subject Re: Using <sql> task to create SQLServer stored procs
Date Mon, 07 Jul 2003 09:35:19 GMT
Oops...

Thanks Antoine

At 11:04 07/07/2003 +0200, you wrote:
>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


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


Mime
View raw message