RE: sql triggers, stored procedures, packages, format preserved

2003-04-04 Thread Anderson, Rob H - VSCM
I did find an issue that is preventing some packages from loading into
Oracle. I have attached a diff -u that fixes it (one line, pretty self
explanatory). Please commit it. 

-Rob A

-Original Message-
From: Steve Loughran [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 1:43 PM
To: Ant Developers List
Subject: Re: sql triggers, stored procedures, packages, format preserved



- Original Message -
From: Anderson, Rob H - VSCM [EMAIL PROTECTED]
To: 'Ant Developers List' [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 13:04
Subject: RE: sql triggers, stored procedures, packages, format preserved


 Steve, My build process will rely heavily on this task to load packages,
 procedures, triggers, view, types, and apply grants in Oracle9i. I agree
 that some tests are needed and I will look into creating some. Thanks,

 -Rob Anderson


It is in there, via an FTP to a unix box where patch works reliably. We need
expanded documentation and testing, now. The task could also do with a
switch to turn on property expansion.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Index: SQLExec.java
===
RCS file: 
/home/cvspublic/ant/src/main/org/apache/tools/ant/taskdefs/SQLExec.java,v
retrieving revision 1.51
diff -u -r1.51 SQLExec.java
--- SQLExec.java14 Mar 2003 09:24:41 -  1.51
+++ SQLExec.java4 Apr 2003 01:38:05 -
@@ -375,6 +375,7 @@
 }
 try {
 statement = conn.createStatement();
+statement.setEscapeProcessing(false);
 
 
 PrintStream out = System.out;


Re: sql triggers, stored procedures, packages, format preserved

2003-04-04 Thread Stefan Bodewig
On Thu, 3 Apr 2003, Rob H. Anderson [EMAIL PROTECTED]
wrote:

 one line, pretty self explanatory

self explaining?  Yes.

I'm just not sure whether we want to do that unconditionally.

Stefan


RE: sql triggers, stored procedures, packages, format preserved

2003-03-13 Thread Anderson, Rob H - VSCM
Steve, My build process will rely heavily on this task to load packages,
procedures, triggers, view, types, and apply grants in Oracle9i. I agree
that some tests are needed and I will look into creating some. Thanks,

-Rob Anderson

-Original Message-
From: Steve Loughran [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 9:02 AM
To: Ant Developers List
Subject: Re: sql triggers, stored procedures, packages, format preserved



- Original Message -
From: Anderson, Rob H - VSCM [EMAIL PROTECTED]
To: 'Ant Developers List' [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 08:41
Subject: RE: sql triggers, stored procedures, packages, format preserved


 The diff -u is now the latest attachement to the bug.

got it.

I am willing to commit these changes, but am not going to be in a position
to test them.

What would be really nice long term would be some tests that used, say hsql
as a sql server. But short term, let me know what breaks.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


RE: sql triggers, stored procedures, packages, format preserved

2003-03-12 Thread Anderson, Rob H - VSCM
Pretty please :)

-Original Message-
From: Anderson, Rob H - VSCM [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 1:27 PM
To: '[EMAIL PROTECTED]'
Subject: sql triggers, stored procedures, packages, format preserved


Committers, Can we get this in the next release? Please :) I guess we will
need to update the documentation for the sql task also. 

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

Robert Anderson
Software Configuration Management
Vector SCM
503-450-6514
[EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]