And the code is like this:
select ID from OPERATIONPLANHEADER
On 4 August 2011 09:20, Miras Bastien wrote:
> I'm trying to use the rowcountproperty parameter in the sql task.
>
> My ant code looks like:
> driver="oracle.jdbc.driver.OracleDriver"
> url=" jdbc:oracle:thin:@localhost:11522:TINSTA"
>
Hi,
I would think that the bugger here is the "commit;" line.
I think commit is something that the SQL task can do for you.
Regards,
Antoine
mtbvang wrote:
Removing the "SET FOREIGN_KEY_CHECKS=0" resolved the issue in my create table
statement. Now I'm getting pretty much the same error in m
Removing the "SET FOREIGN_KEY_CHECKS=0" resolved the issue in my create table
statement. Now I'm getting pretty much the same error in my insert test data
script. The strange thing is, when I embed this sql between the
tags it runs, but when I specify a file using
the src attribute of transaction
Thanks Antoine, that was it. It was a no brainer that I didn't see. Much
appreciated.
Vang
mtbvang wrote:
>
> Hi,
>
> I am getting the following error when using the
> /mysql-connector-java-5.1.10-bin.jar in an Ant 1.7 SQL task. For some
> reason a ? is being placed at the beginning of my com
Hello,
maybe "SET FOREIGN_KEY_CHECKS=0" is not valid for a JDBC connection.
There are some vendor specific SQL instructions which are not valid
inside JDBC.
The ant sql task is a wrapper around JDBC.
Maybe the task would need to be extended somehow to allow this kind of
settings.
Regards,
Ant
When I populate the database manually from the command line using:
mysql -uroot -p mydb < mydb.sql
...everything works as it should. The value is not truncated as it is
when run by Ant. This leads me to believe it is caused by Ant or Java.
Thanks,
Alex
On Tue, 2008-04-08 at 12:16 -0500, David
--- John Shott <[EMAIL PROTECTED]> wrote:
> Matt:
>
> Thanks for your quick response ... I had been
> unaware of the
> task/condition and will begin
> reading up on it
> immediately as that is clearly a useful feature in
> cases such as this one.
>
> I particularly appreciate the fact that y
Matt:
Thanks for your quick response ... I had been unaware of the
task/condition and will begin reading up on it
immediately as that is clearly a useful feature in cases such as this one.
I particularly appreciate the fact that you and Steve have both taken
the time to look into my particu
: SQL task and resource collections ...
Steve:
Thanks for your informative response and your suspicion that I may have
a problem with the size() of my fileset.
Since I can't seem to find a simple method of trying to test the size of
my fileset, in advance of my call of the sql task, I&#
--- Matt Benson <[EMAIL PROTECTED]> wrote:
> Pardon the top post, all.
>
> We have had trouble here and there with the
> difference
> between "no resources specified" (an error to be
> reported) and "no resources found" (usu. ignore and
> continue). This sounds like that kind of situation
> and
Pardon the top post, all.
We have had trouble here and there with the difference
between "no resources specified" (an error to be
reported) and "no resources found" (usu. ignore and
continue). This sounds like that kind of situation
and I will try to look into it.
As for your question about an e
Steve:
Thanks for your informative response and your suspicion that I may have
a problem with the size() of my fileset.
Since I can't seem to find a simple method of trying to test the size of
my fileset, in advance of my call of the sql task, I've now tried to
modify my target to first crea
John Shott wrote:
Ant community:
I'm trying to upgrade my build.xml to be ant 1.7.0 compatible and seem
to be stumbling on changes in the SQL task related to resource collections.
I have been trying:
keepformat="true" delimiter="/" escapeprocessing="false"
print="true"
Hello,
sorry, this is not an Ant problem at all.
Look for an Oracle mailing list.
Regards,
Antoine
Original-Nachricht
Datum: Thu, 31 Aug 2006 06:52:34 -0700 (PDT)
Von: Angus Rose <[EMAIL PROTECTED]>
An: user@ant.apache.org
Betreff: SQL task - creating tablespace in Oracle prob
t: 27 June 2006 17:49
To: Ant Users List
Subject: RE: SQL task - how to set collation (working with MySQL)
Sure.
If I use the console for example, I use:
mysql -u[user] -p[password] --default-character-set=[charset]
This causes the console client to use the corresponding charset, and by that -
>-Ursprüngliche Nachricht-
>Von: Eitan Gur [mailto:[EMAIL PROTECTED]
>Gesendet: Dienstag, 27. Juni 2006 18:38
>An: Ant Users List
>Betreff: RE: SQL task - how to set collation (working with MySQL)
>
>I think it is an Ant related question, as I only want to know
>
I think it is an Ant related question, as I only want to know how to tell Ant
to use a specific collation -
I know how to do this in other clients. For me, Ant is just another client, and
I would like to specify a parameter...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PR
coding=xxx on the command line to force the default
encoding, if required.
Hope this helps
Keith
-Original Message-
From: Patrick Martin [mailto:[EMAIL PROTECTED]
Sent: 04 May 2006 15:41
To: Ant User
Subject: Re: SQL task output encoding
I might be wrong on this:
>>>>&g
I might be wrong on this:
Java Reader and Writer always use Unicode by default
On 5/4/06, Patrick Martin <[EMAIL PROTECTED]> wrote:
Hello,
I'd like to know which encoding is used by the SQL task when outputing
to a file. I believe it is unicode but I need to be sure...
has an encoding attri
Thanks for your tip...will try that for sure.
Regards,
Vik.
From: "Anderson, Rob (Global Trade)" <[EMAIL PROTECTED]>
Reply-To: "Ant Users List"
To: "Ant Users List"
Subject: RE: SQL Task: errors loading oracle Packages that contain stored
procedures.
D
You could also try the task available from Incanto:
http://incanto.sourceforge.net/usage-sqlplus.html
-Andrew
On 3/17/06, Anderson, Rob (Global Trade) <[EMAIL PROTECTED]> wrote:
>
> Those statements...
> @ggov_applications.spc
> @ggov_applications.bdy
>
> are not standard sql, they are specific
Those statements...
@ggov_applications.spc
@ggov_applications.bdy
are not standard sql, they are specific to oracle's sqlplus. IMHO, Your
best option is to create a fileset, then run each file through the sql
task using the task from ant-contrib.
-Rob Anderson
> -Original Message-
> Fr
I'm a little grumpy today. I apologize. -Rob A
> -Original Message-
> From: Matt Benson [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 17, 2006 11:41 AM
> To: Ant Users List
> Subject: RE: sql task
>
> --- "Anderson, Rob (Global Trade)"
> <[EM
--- "Anderson, Rob (Global Trade)"
<[EMAIL PROTECTED]> wrote:
> First of all, posting the same question several
> times is annoying. Try
> not to do that.
Didn't annoy me at all--I saw the same subject several
times in a row from the same poster, and deleted every
one without reading any of them.
First of all, posting the same question several times is annoying. Try
not to do that.
It looks like the first thing you tried should have worked. Are you
using the right Driver? My sql tasks use the Oracle driver that is in
ojdbc14.jar. Also, try putting the jar file in $ANT_HOME/lib rather than
Shouldn't the last entry you tried be jdbc:oracle:thin:@localhost:1521:harshal
and not jdbc:oracle:thin:@localhosthost:1521:harshal with 2 host
-Original Message-
From: Harshal Chavda [mailto:[EMAIL PROTECTED]
Sent: Friday, March 17, 2006 11:23 AM
To: user@ant.apache.org
Subject: sql ta
/t
>-Original Message-
>From: Rizwan Merchant [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 25, 2005 9:28 PM
>To: 'Ant Users List'
>Subject: RE: sql task sp_dboptions problem
>
>Hmmm...that looks like a good idea. Thanks...
>
>-Original Messag
Hmmm...that looks like a good idea. Thanks...
-Original Message-
From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 3:06 PM
To: Ant Users List
Subject: RE: sql task sp_dboptions problem
we... (more than one way to skin a cat)
if the
ng about selectively executing only some
parts of the file, but it would get messy quite quick!
/t
>-Original Message-
>From: Rizwan Merchant [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 25, 2005 9:00 PM
>To: 'Ant Users List'
>Subject: RE: sql task sp_dboptio
2005 2:51 PM
To: Ant Users List
Subject: RE: sql task sp_dboptions problem
wouldn't this work?
>-Original Message-
>From: Moran Ben-David [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 25, 2005 8:43 PM
>To: 'Ant Users List'
>Subject: RE: sql task s
wouldn't this work?
>-Original Message-
>From: Moran Ben-David [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 25, 2005 8:43 PM
>To: 'Ant Users List'
>Subject: RE: sql task sp_dboptions problem
>
>Sorry Razwan,
>
>I am not familiar w
...
-Original Message-
From: Moran Ben-David [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 2:43 PM
To: 'Ant Users List'
Subject: RE: sql task sp_dboptions problem
Sorry Razwan,
I am not familiar with the task enough to help you on that. However,
one thing I can suggest is th
DROP DATABASE ${the.database.i.wanted.to.pass};
Moran
> -Original Message-
> From: Rizwan Merchant [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 25, 2005 1:47 PM
> To: 'Ant Users List'
> Subject: RE: sql task sp_dboptions problem
>
>
> Hi Moran,
From: Moran Ben-David [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 12:14 PM
To: 'Ant Users List'
Subject: RE: sql task sp_dboptions problem
Sounds like you're issue is with the SQL Server connection properties.
Query Analyzer tends to have different defaults for the con
Sounds like you're issue is with the SQL Server connection properties.
Query Analyzer tends to have different defaults for the connection settings
than your Ant initiated connections.
Look up the error in a sql site like "www.sqlmag.com", I'm sure there will
be an explanation like set AutoCommit o
Don't worry about it. Everyone makes mistakes. Glad to hear you have it working
now.
-Rob Anderson
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
> Sent: Monday, January 03, 2005 6:11 AM
> To: user@ant.apache.org
> Subjec
locally unidentified bug prompting me to ask this
group for help.
--
Galen
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, December 30, 2004 12:39 PM
> > To: Ant Users List
&g
Send the relevant portion of your build.xml.
-Rob A
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 30, 2004 12:39 PM
> To: Ant Users List
> Subject: Re: SQL task and the delimiter and 1.6.2.
>
>
> &quo
gt; > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, December 30, 2004 11:57 AM
> > To: Ant Users List
> > Subject: Re: SQL task and the delimiter and 1.6.2.
> >
> >
> > Okay,
> >
> > I'm havi
In this case your delimiter is "go".
-Rob Anderson
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 30, 2004 11:57 AM
> To: Ant Users List
> Subject: Re: SQL task and the delimiter and 1.6.2.
>
>
> O
Okay,
I'm having the same type of issue with SQLServer. I've mucked around
with different combinations of delimiters but two statements in the
same file being executed against SQLServer seem to fail.
create view dbo.t1_v1
as
select * from t1
go
create view dbo.t1_v2
as
select * from
That makes perfect sense, I was able to send the o/p to a file now I
just need to filter and load the file.
Thanks Rob.
ANil
-Original Message-
From: Anderson, Rob (Global Trade) [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 30, 2004 11:46 AM
To: Ant Users List
Subject: RE: Sql
Anil, You may be able to accomplish what you need by using the output attribute
of the task to specify an output file for the sql statement, then use the
task to load the value contained in the output file into a property,
then use the ant-contrib task to test the value of the property.
-Rob
"Jacob, Anil - MWT" <[EMAIL PROTECTED]> writes:
> I have an sql task which checks the records in 3 tables. Is there a way
> I can set a property if the value in any of the tables is > 0? This
> property will be used for other tasks.
>
> Anil
Here is the path I would try:
The ant-contrib has a m
"Velagapudi, Murali" <[EMAIL PROTECTED]> writes:
> try with delimiter="/" and replace ; with /
> it works fine for me on oracle.
Arghh!!!
No sooner did I send the message than I found it out.
But no matter. I truly appreciate the reply.
--
Galen Boyer
-
try with delimiter="/" and replace ; with /
it works fine for me on oracle.
thanks,
Murali
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, December 30, 2004 1:52 PM
To: user@ant.apache.org
Subject: SQL task and the delimiter and 1.6.2.
"Anderson, Rob (Global Trade)" wrote:
> Try setting the escapeprocessing attribute to false.
This I already did on your previous recommendation.
--
Jack J. Woehr # We have gone from the horse and buggy
Senior Consultant # to the moon rocket in one lifetime, but
Purematrix, Inc. # there h
Try setting the escapeprocessing attribute to false.
-Rob Anderson
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 05, 2004 4:27 PM
> To: Ant Users List
> Subject: Re: Sql Task -- quote marks
>
>
> Bill Rich wrote
Bill Rich wrote:
> If your problem with the quote marks is in the ant script you can use "e;
No, it's in a separate .sql file ...
--
Jack J. Woehr # We have gone from the horse and buggy
Senior Consultant # to the moon rocket in one lifetime, but
Purematrix, Inc. # there has not been a c
50 matches
Mail list logo
