ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hammer, Paul" <PHam...@classroom.com>
Subject RE: sql task issue
Date Fri, 28 Feb 2003 02:31:11 GMT

Hi Rob,

Things haven't gone as well as hoped on my large test of plsql.
The test first successfully ran multiple .sql files, and
then attempted to run an sql file that began with:

	IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[UpdateCourseIsArchived]') AND

          OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [UpdateCourseIsArchived];
	
	CREATE PROCEDURE UpdateCourseIsArchived
		@courseID int,
		@isArchived bit
	AS
	....

This resulted in the error message:

	BUILD FAILED
	file:D:/ATG/Dynamo5.6.1/Database/iK/dbupdate.xml:117: java.sql.SQLException: [EN
	G--PHAMMER]'CREATE PROCEDURE' must be the first statement in a query batch.

We've had this error before, and solved the problem by placing the semicolon  ";"
on the end of the DROP PROCEDURE... statement.

Do you know of any way we can have the DROP PROC and CREATE PROC in the 
same .sql file?

Paul


-----Original Message-----
From: Anderson, Rob H - VSCM [mailto:Anderson.Rob@vectorscm.com]
Sent: Thursday, February 27, 2003 12:51 PM
To: 'Ant Users List'
Subject: RE: sql task issue


Great. Glad to hear it. I use it to load about 300 packages, triggers, and
procedures and it's been working great for me. Let me know how it goes this
afternoon. 

-Rob Anderson

-----Original Message-----
From: Hammer, Paul [mailto:PHammer@classroom.com]
Sent: Thursday, February 27, 2003 11:57 AM
To: 'Ant Users List'
Subject: RE: sql task issue



Rob A. ,

This new plsql task has passed by first small test.  
This afternoon, I'll be running a much larger test.

Thanks!

Paul

-----Original Message-----
From: Anderson, Rob H - VSCM [mailto:Anderson.Rob@vectorscm.com]
Sent: Wednesday, February 26, 2003 4:51 PM
To: 'Ant Users List'
Subject: RE: sql task issue


It looks like the attachement did not make it. I sent an email from my
hotmail account, with the attachement, to the list. It hasn't bounced yet,
so I guess it is on the way. The latest attachement on the enhancement
request can be downloaded also...

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16945

-Rob A

-----Original Message-----
From: Hammer, Paul [mailto:PHammer@classroom.com]
Sent: Wednesday, February 26, 2003 4:37 PM
To: 'Ant Users List'
Subject: RE: sql task issue



Rob,

I don't understand.  The attached file only contains the following:

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

Is this what you meant to send to me?

Paul


-----Original Message-----
From: Anderson, Rob H - VSCM [mailto:Anderson.Rob@vectorscm.com]
Sent: Wednesday, February 26, 2003 3:22 PM
To: 'Ant Users List'
Subject: RE: sql task issue


Try the attached task. I wrote it with the intention of loading plsql
packages, procedures, and triggers into oracle but I see no reason why you
could not use it for your purposes also. Let me know if it works.



-----Original Message-----
From: Hammer, Paul [mailto:PHammer@classroom.com]
Sent: Wednesday, February 26, 2003 3:02 PM
To: 'Ant Users List'
Subject: sql task issue



I'm new to this mailing list, and glad to be here.

My company is running ant 1.5.1 on Windows NT/2K.  We are
using the sql task to declare stored procedures to 
MS SQL Server 7.0.  These stored procedures work fine. 
The issue is that when the stored procedures are viewed
through the Enterprise Manager intrface, all the comments
and end-of-line chars have been stripped out.  This
makes the result unreadable.

has anyone encoutered this before?  Might there be a
work around for this?

Paul J. Hammer


---------------------------------------------------------------------
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