Hi,
I am new to ant and before sending mail to this list I explored the issue
on google but didn't get any satisfactory results.
In one of my project, I require to run the below sql task in a different
jvm.
Actually in my build.xml file, I call a junit test using junit task and in
that ta
Sry, the sql function should be without begin and end:
CREATE OR REPLACE FUNCTION make_plpgsql() RETURNS void AS $$
CREATE LANGUAGE plpgsql;
$$ LANGUAGE sql;
Am 04.06.2010 01:13, schrieb Markus Mehrwald:
Hi,
I have a problem with the ant sql task. The task
always gets the following error
Hi,
I have a problem with the ant sql task. The task
always gets the following error:
[sql] Failed to execute: CREATE OR REPLACE FUNCTION make_plpgsql()
RETURNS void AS $ BEGIN CREATE LANGUAGE plpgsql
With the exception: Syntaxerror at "$"
The script looks
mple:
> // SQL defines "--" as a comment to EOL
> // and in Oracle it may contain a hint
> // so we cannot just remove it, instead we must end it
> if (!keepformat && line.indexOf("--") >= 0) {
> sql.append("\n");
> }
>
I used keepformat=
SQLCODE: -104, SQLSTATE:
42601, SQLERRMC: ('TestTable', 'TT1000', 'Common -- Te;N, VERSIONNO)
VALUES;
But if I execute this insert statement from the DB2 command prompt, it is
getting executed successfully.
Can you please help me in finding the reason for this
We found the problem. The parser chokes if there are any spaces after
the delimiter and there was a "go " on one line. Grr...
-Original Message-
From: Gareth Davies
Sent: 16 September 2008 16:35
To: user@ant.apache.org
Subject: ant sql task with keepformat
I'm trying t
I'm trying to use ant's sql task to execute scripts on a Sybase ASE
12.5.1 database. I thought everything was working but realized that
without the 'keepformat' attribute set my SQL files are being munged
(lined endings and comments being stripped) which means stored procs are
being munged on crea
ashish shrivastava wrote:
Thanks Steve ,
Your inputs are great help.
Regards
Ashish Shrivastava
Software Enginner
Impetus Infotech Pvt Ltd
Indore,India
I should add that if you do want to do bulk imports of data, the fastest
way to do it in mysql is to use the LOAD FILE sql command.
I pr
r testing) is to do it in the persistence framework of
your choice, then snapshot either the database files or the entire
vmware/xen image for reuse.
-steve
> Thanks
> Ashish
>
>
> On 1/11/07, Steve Loughran <[EMAIL PROTECTED]> wrote:
>>
>> ashish shrivastava wrote:
, Steve Loughran <[EMAIL PROTECTED]> wrote:
ashish shrivastava wrote:
> I am using ANT for deployment of my product.I need to run different
> SQL's at
> different stages of my deployment, so if i use ANT SQL task it will
> create a
> new DB connection each time.Is there a
ed to run different
> SQL's at
> different stages of my deployment, so if i use ANT SQL task it will
> create a
> new DB connection each time.Is there any way i can share the DB
connection
> between different tasks.(may be putting the connection in Project class
> thru
> my custom S
ashish shrivastava wrote:
I am using ANT for deployment of my product.I need to run different
SQL's at
different stages of my deployment, so if i use ANT SQL task it will
create a
new DB connection each time.Is there any way i can share the DB connection
between different tasks.(may be pu
I am using ANT for deployment of my product.I need to run different SQL's at
different stages of my deployment, so if i use ANT SQL task it will create a
new DB connection each time.Is there any way i can share the DB connection
between different tasks.(may be putting the connection in Pr
IL PROTECTED]
> Inviato: martedì 19 dicembre 2006 14.35
> A: Ant Users List
> Oggetto: Re: Ant-sql task in rel 1.7.0
>
>
> Are you using ant 1.7.0RC1 ?
> If so, try using ant -noproxy
>
> Peter
>
> On 12/19/06, Caleandro <[EMAIL PROTECTED]> wrote:
> > Hi all,
manual is very poor
about the argument?
Thanks,
Vito
> -Messaggio originale-
> Da: Peter Reilly [mailto:[EMAIL PROTECTED]
> Inviato: martedì 19 dicembre 2006 14.35
> A: Ant Users List
> Oggetto: Re: Ant-sql task in rel 1.7.0
>
>
> Are you using ant 1.7.0RC1
Are you using ant 1.7.0RC1 ?
If so, try using ant -noproxy
Peter
On 12/19/06, Caleandro <[EMAIL PROTECTED]> wrote:
Hi all,
Please, I need help about ant task.
A script like this:
Select * from SCHEMA1.Table01;
runs correctly (as is) in ant 1.6.5 but in 1.7.0 it s
Hi all,
Please, I need help about ant task.
A script like this:
Select * from SCHEMA1.Table01;
runs correctly (as is) in ant 1.6.5 but in 1.7.0 it seem to hang-up and loop
indefinitely
till I type a break key on keyboard.
Oracle(9i) server console does not signal any
eastwoj wrote:
yes. same machine .. i'm wondering if the problem might be something to do
with the fact that Ant is using JDBC to execute the statements while sqlplus
uses sqlnet. Maybe ant is reading all 23000 statements into memory and
that's a problem?
this is probably way out of ant's no
happy with that because its not as elegant .. but the time is down
from 15-20 mins to about 4
--
View this message in context:
http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5300179
Sent from the Ant - Users forum at
the machine that you are running this on? CPU speed,
memory?
-Rob A
> -Original Message-
> From: eastwoj [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 12, 2006 12:02 PM
> To: user@ant.apache.org
> Subject: RE: Ant Sql task slow
>
>
> yes. same machine
ext:
http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5295331
Sent from the Ant - Users forum at Nabble.com.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
12, 2006 10:51 AM
> To: user@ant.apache.org
> Subject: RE: Ant Sql task slow
>
>
> around 23,000 insert statements ..
> --
> View this message in context:
> http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5293969
> Sent
around 23,000 insert statements ..
--
View this message in context:
http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5293969
Sent from the Ant - Users forum at Nabble.com.
-
To unsubscribe, e-mail: [EMAIL PROTECTED
How many rows are you inserting? How much data?
-Rob A
> -Original Message-
> From: eastwoj [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 12, 2006 9:39 AM
> To: user@ant.apache.org
> Subject: Ant Sql task slow
>
>
> I'm trying to execute a sql fi
I'm trying to execute a sql file using Ant's sql task via a Maven goal. The
goal passes a file of insert statements to the Ant sql task.
When I run the insert statements in the file in sqlplus, they run in a few
minutes. Running them via the ant task, though .. takes upwards of 15
I am trying to use the Ant SQL task to replace a shell scripting solution but I get
errors on a stored procedure.
Is it possible to define stored procedures via Ant SQL?
In the midst of a stored procedure definition ...
select @querystring = "alter table " + @tm
26 matches
Mail list logo
