19 16:04
> An: user@ant.apache.org
> Betreff: Re: Issue with sql task accessing MySql
>
> Just to get the solution documented this thread, here's what I did.
> This is a winders 7 machine running ant in cygwin. The ant call:
>
>value="update_build_tabl
Just to get the solution documented this thread, here's what I did. This is a
winders 7 machine running ant in cygwin. The ant call:
The bash script:
#!/usr/bin/bash#
ssh myUser@myMachine "mysql -u mySqlUser -pmySqlPassword mySqlDB -e
Thanks Stefan! Took the easy path and outsourced the update to a simple bash
script that ssh's to the MySql Server and runs the SProc there. Thanks for all
your help!
On Wednesday, August 28, 2019, 04:02:17 PM EDT, Stefan Bodewig
wrote:
On 2019-08-28, Eric Fetzer wrote:
> Is there
On 2019-08-28, Eric Fetzer wrote:
> Is there a way to set that version JUST for this call?
I'm afraid there is no way to run the task in a different JVM than
the rest of Ant.
Judging from
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-versions.html
your MySQL Connector requires Java8
Also, any clue what version of Java do I need to use with this? 1.8?
On Wednesday, August 28, 2019, 12:57:34 PM MDT, Eric Fetzer
wrote:
Is there a way to set that version JUST for this call? We're building a
legacy application here that CANNOT upgrade to a newer version of Java...
Is there a way to set that version JUST for this call? We're building a
legacy application here that CANNOT upgrade to a newer version of Java...
Thanks!
On Wednesday, August 28, 2019, 12:28:55 PM MDT, Stefan Bodewig
wrote:
On 2019-08-28, Eric Fetzer wrote:
> Thanks Stefan, a bit
On 2019-08-28, Eric Fetzer wrote:
> Thanks Stefan, a bit better:
> $ ant -f test.xmlBuildfile: test.xml
> main:
> BUILD FAILEDc:\BuildDeployScripts\test.xml:22:
> java.lang.UnsupportedClassVersionError: (com/mysql/jdbc/Driver) bad major
> version at offset=6
> Total time: 0 seconds
You are run
Thanks Stefan, a bit better:
$ ant -f test.xmlBuildfile: test.xml
main:
BUILD FAILEDc:\BuildDeployScripts\test.xml:22:
java.lang.UnsupportedClassVersionError: (com/mysql/jdbc/Driver) bad major
version at offset=6
Total time: 0 seconds
On Wednesday, August 28, 2019, 10:49:54 AM MDT, Stefan B
On 2019-08-28, Eric Fetzer wrote:
> The MySql server I'm accessing upgraded to version 8.0.17:
> So, accordingly, I downloaded the proper driver and linked to it in my task:
>
> BUILD FAILEDc:\BuildDeployScripts\test.xml:22:
> com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Cl
The MySql server I'm accessing upgraded to version 8.0.17:
mysql> select version();+---+| version() |+---+| 8.0.17
|+---+1 row in set (0.00 sec)
So, accordingly, I downloaded the proper driver and linked to it in my task:
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
set feedback off
works for me .. thanks
--
View this message in context:
http://ant.1045680.n5.nabble.com/Output-of-SQL-task-tp1336066p5459886.html
Sent from the Ant - Users mailing list archive at Nabble.com.
-
To
--
View this message in context:
http://ant.1045680.n5.nabble.com/SQL-task-and-iterating-over-results-tp5017227p5017234.html
Sent from the Ant - Users mailing list archive at Nabble.com
Hello,
I have a small script that queries a DB to get some IDs.
I would like to iterate over the result set (using ant 'for' task) without
saving the results to a file.
Can somebody provide some hints?
Thanks
--
View this message in context:
http://ant.1045680.n5.nabble.com/SQ
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:
Hello,
I'm trying to use the rowcountproperty parameter in the sql task.
My ant code looks like:
select * from t_product;
But the db.data.nbLine property is not updated.
Looking at:
http://javasourcecode.org/html/open-source/ant/ant-1.8.1/org/apache/tool
Hello,
I'm trying to use the rowcountproperty parameter in the sql task.
My ant code looks like:
select * from t_product;
But the db.data.nbLine property is not updated.
Looking at:
http://javasourcecode.org/html/open-source/ant/ant-1.8.1/org/apache/tool
n: Laurence Mills-Gahl [mailto:elem...@gmail.com]
> Gesendet: Mittwoch, 1. Dezember 2010 17:45
> An: user@ant.apache.org
> Betreff: sql task output suppressing a column
>
> I am having difficulty with the results of a sql task not being the same as
> the results from the sql query in
-Ursprüngliche Nachricht-
> Von: Laurence Mills-Gahl [mailto:elem...@gmail.com]
> Gesendet: Mittwoch, 1. Dezember 2010 17:45
> An: user@ant.apache.org
> Betreff: sql task output suppressing a column
>
> I am having difficulty with the results of a sql task not being the same as
>
Hmm, sounds like a driver problem (jdbc vs. Native) , not an ant issue.
-Ursprüngliche Nachricht-
Von: Laurence Mills-Gahl [mailto:elem...@gmail.com]
Gesendet: Mittwoch, 1. Dezember 2010 17:45
An: user@ant.apache.org
Betreff: sql task output suppressing a column
I am having difficulty
I am having difficulty with the results of a sql task not being the same
as the results from the sql query in the db environment and I am
wondering if anybody else has seen this behavior.
I have a sql task executing the following query:
SELECT
c.property_value,
center.name,
s.property_value
FROM
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
I am having a difficulty with the SQL task trying to send functions to the
mysql server. No mater what I have tried I get the error message that the
server could not execute 'CREATE FUNCTION...
My sql task is
...
...
The Function is
CREATE FUNCTION
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 pret
)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565)
at
org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535)
antoinell wrote:
>
> Hello,
>
> maybe "SET FOREIGN_KE
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
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
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 comment and sql statement lines.
I've included the error from the cmd prompt and my and tasks below. Any one
know w
I'm trying to build a test suite using an embedded Derby server. In my
build.xml, I have a "sql" task that executes my "create table" sql, and
then I run "junit" to run my tests that use the database. I'm finding
that Derby is giving me an error while
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
tead of C:\oracle\products\ora102010\jdbc\lib\ojdbc14.jar, I've tried the
following: classes12.jar, classes12.zip, classes12dms.jar. But I wasn't
successful with either them.
Thanks for any feedback about the above.
I'll be also interested to know if anyone has been able to use the
Hi there,
I am trying to use ant SQL task to run the following "execute
dbms_java.grant_permission" in an Oracle 10g database but the task is
failing with the following error: ORA-00900: invalid SQL statement.
I guess that the execute dbms_java is not a standard sql statement but
bef
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
AIL PROTECTED]>
wrote:
Hi everyone.
I'm looking for an automated way to execute a set of .sql files inside a
sql task and I do need them to be executed in order. The ant task I've tried
is the following
for an automated way to execute a set of .sql files inside a
> sql task and I do need them to be executed in order. The ant task I've tried
> is the following
>
> driver = "com.mysql.jdbc.Driver"
> password = "root"
>
Hi everyone.
I'm looking for an automated way to execute a set of .sql files inside a
sql task and I do need them to be executed in order. The ant task I've
tried is the following
inclu
either of these but this is what I would try next.
-Andrew
On Thu, May 8, 2008 at 1:52 AM, Kothari, Shivani <[EMAIL PROTECTED]>
wrote:
>
>
> Hi,
>
> I am executing .sql which has procedure with [EMAIL PROTECTED] . This .sql
> is executed from SQL Task through ANT scripts.
Hi,
I am executing .sql which has procedure with [EMAIL PROTECTED] . This .sql
is executed from SQL Task through ANT scripts. This .sql file having
procedure is runnin properly form sql server studio.
Statements in SQL procedure :
SET @PLOT_LINK =
'openForm("ESD_ADM032_FRM_AU
helps you understand what seems to be going on
Thanks,
-nathan
-Original Message-
From: Steve Loughran [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2008 7:46 AM
To: Ant Users List
Subject: Re: issues with SQL task and the PRINT statement in external
.sql files
Nathan Hatta
> > truncated after apostrophe')
> >
> > This will insert data for each value, but it appears in the table like
> > this:
> > 1 Good data.
> > 10 When it
> > 11 Good data, and then It
> >
> > My sql task in build.xml contain
insert data for each value, but it appears in the table like
this:
1 Good data.
10 When it
11 Good data, and then It
My sql task in build.xml contains the following:
DROP DATABASE IF EXISTS ${db.name};
CREATE DATABASE ${db.name} CHARACTER SET utf8;
USE ${db.name};
When I r
Nathan Hattala wrote:
Hello,
So I have been banging my head against a wall it seems because I have
been trying to automate the database build and deployment process for
our software. The goal I have is using ANT and the sql task, to execute
an existing .sql file that was developed and placed
Hello,
So I have been banging my head against a wall it seems because I have
been trying to automate the database build and deployment process for
our software. The goal I have is using ANT and the sql task, to execute
an existing .sql file that was developed and placed in SVN. I am having
an
--- 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&#
br,
Matt
>
> HTH,
> Matt
>
> --- John Shott <[EMAIL PROTECTED]> wrote:
>
> > Steve:
> >
> > Thanks for your informative response and your
> > suspicion that I may have
> > a problem with the size() of my fileset.
> >
> > Si
; 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 create a fileset, then
> created a property
> bas
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 targe
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="/" escapeproces
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&qu
ingapp\build.xml:205: java.sql.SQLException:
No su
itable Driver for jdbc.hsqldb:db/test
Total time: 9 seconds
C:\dl\java\spring\projects\springapp>
--
View this message in context:
http://www.nabble.com/Problem-using-sql-task-with-ant-1.6.5-tf4262377.html#a12596421
Sent from the Ant - User
[EMAIL PROTECTED] wrote:
Do you need to any specific to use sql task in ant 1.6.5? Is there a
work around ?
It says C:\projects\springapp\build.xml:114: Class Not Found: JDBC driver
org.hsqldb.jdb
cDriver could not be loaded
Do you need to any specific to use sql task in ant 1.6.5? Is there a
work around ?
srikrishna
C:\projects\springapp>ant -verbose createTables
Apache Ant version 1.6.5 compiled on June 2 2005
Buildfile: build.xml
Detected Java version: 1.5 in: C:\bea92\jdk150_10\jre
Detected
Mittwoch, 21. März 2007 15:51
>An: Ant Users List
>Betreff: Re: AW: How to silence errors in SQL task or log
>
>You didn't test the ideas. But I have, at least a)
>
> No, a) does not work because the error is not redirected but doubled!
>
> b) sounds too complicat
ecial output could be done with
Jan
>-Ursprüngliche Nachricht-
>Von: Hans Schwaebli [mailto:[EMAIL PROTECTED]
>Gesendet: Mittwoch, 21. März 2007 14:35
>An: Ant Users List
>Betreff: Re: How to silence errors in SQL task or log
>
>Internal, external ... didn't m
Just some ideas ...
a)
b) custom Logger
- if a special output comes, it starts/ends logging
- special output could be done with mailto:[EMAIL PROTECTED]
>Gesendet: Mittwoch, 21. März 2007 14:35
>An: Ant Users List
>Betreff: Re: How to silence errors in SQL task or log
&g
that it is
digging in the dirt deeply because of "by design" stuff. Its not just Ant, but
CruiseControl, CVS and other stuff with such things.
Steve Loughran <[EMAIL PROTECTED]> wrote:
Hans Schwaebli wrote:
> Can anybody tell my why cannot be used for the SQL task?
because
Hans Schwaebli wrote:
Can anybody tell my why cannot be used for the SQL task?
because sql task is not executing an external program
I want to silence the errors if they occur when running the SQL task. But it
didn't work. Any solution? Best would be to log all errors of a certai
Can anybody tell my why cannot be used for the SQL task?
I want to silence the errors if they occur when running the SQL task. But it
didn't work. Any solution? Best would be to log all errors of a certain SQL
task on info level. This flexibility I am mi
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
Thanks Steve ,
Your inputs are great help.
Regards
Ashish Shrivastava
Software Enginner
Impetus Infotech Pvt Ltd
Indore,India
On 1/11/07, Steve Loughran <[EMAIL PROTECTED]> wrote:
ashish shrivastava wrote:
> I am OK with the complexity. I can not group sql task as there are
>
ashish shrivastava wrote:
I am OK with the complexity. I can not group sql task as there are
dependencies on other tasks.
please tell me how to achieve it.
ahh. when I said complexity, I meant "nobody in the ant team wants to
write the code to do connection pooling as there is l
I am OK with the complexity. I can not group sql task as there are
dependencies on other tasks.
please tell me how to achieve it.
Thanks
Ashish
On 1/11/07, Steve Loughran <[EMAIL PROTECTED]> wrote:
ashish shrivastava wrote:
> I am using ANT for deployment of my product.I ne
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
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
this problem, and if so how do I solve it?
Angus
--
View this message in context:
http://www.nabble.com/SQL-task---creating-tablespace-in-Oracle-problem-tf2196872.html#a6079797
Sent from the Ant - Users forum at Nabble.com.
---
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
I just looked at the source for the sql task. Ant will read the file
line by line and execute the statements sequentially as they appear in
the file, without loading the entire file into memory. The sql task will
certainly not be as fast as a native application like sqlplus. What are
the specs of
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]
That is a lot. Are you running both sqlplus and Ant's sql task on the
same machine? In other words is there any difference in the network
between where you are running the two.
-Rob A
> -Original Message-
> From: eastwoj [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July
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
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 -
specific charset...
Thanks Jan,
Eitan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 5:39 PM
To: user@ant.apache.org
Subject: AW: SQL task - how to set collation (working with MySQL)
Can you give an command line example for MySQL?
Jan
Can you give an command line example for MySQL?
Jan
>-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
PROTECTED]
Sent: Tuesday, June 27, 2006 5:34 PM
To: user@ant.apache.org
Subject: AW: SQL task - how to set collation (working with MySQL)
>I wanted to know whether (and how) I can instruct ANT to use a
>specific collation with the SQL task (specifically - when using MySQL).
Hhmm ... rea
>I wanted to know whether (and how) I can instruct ANT to use a
>specific collation with the SQL task (specifically - when using MySQL).
Hhmm ... really an Ant related question or more SQL related?
Jan
-
To unsubscr
Hi
I wanted to know whether (and how) I can instruct ANT to use a specific
collation with the SQL task (specifically – when using MySQL).
Thanks
.
-Rob A
> -Original Message-
> From: Gareth Reakes [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 18, 2006 1:17 AM
> To: Ant Users List
> Subject: Re: postgres stored procedure sql task problem
>
> Hey Rob,
>
> Thanks for help. The problem is this work
help,
Gareth
Anderson, Rob (Global Trade) wrote:
Can you post the portion of your build.xml that produces the error you
mention below.
-Rob A
-Original Message-
From: Gareth Reakes [mailto:[EMAIL PROTECTED] Sent: Tuesday,
May 16, 2006 9:15 AM
To: Ant Users List
Subject: postgres stored
:
Since Ant is not throwing the exception, I don't think there is a
problem with your usage of the sql task. I would suggest asking in a
postgresql forum.
Sorry I cannot offer more help.
-Rob A
-Original Message-
From: Gareth Reakes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 16, 2006
Since Ant is not throwing the exception, I don't think there is a
problem with your usage of the sql task. I would suggest asking in a
postgresql forum.
Sorry I cannot offer more help.
-Rob A
> -Original Message-
> From: Gareth Reakes [mailto:[EMAIL PROTECTED]
> Sent: T
t the portion of your build.xml that produces the error you
mention below.
-Rob A
-Original Message-
From: Gareth Reakes [mailto:[EMAIL PROTECTED] Sent: Tuesday, May
16, 2006 9:15 AM
To: Ant Users List
Subject: postgres stored procedure sql task problem
Hi all,
Apologies if this en
Sent: Tuesday, May
16, 2006 9:15 AM
To: Ant Users List
Subject: postgres stored procedure sql task problem
Hi all,
Apologies if this ends up being a duplicate - It seems this email
was not registered
I am having a problem sucking in a stored procedure. I works
fine on the command lin
Message-
From: Gareth Reakes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 16, 2006 9:15 AM
To: Ant Users List
Subject: postgres stored procedure sql task problem
Hi all,
Apologies if this ends up being a duplicate - It seems this
email was not registered
I am having a problem sucking
Hey,
I have tried both referencing it but file with the src attribute and
by putting in the sql tag. The file works with the -f option on the
command line with psql (also with redirection in).
Cheers,
Gareth
Scot P. Floess wrote:
Sorry sounds like smart alec question...but there is not
Hi all,
I am having a problem sucking in a stored procedure. I works fine on
the command line to psql but gives the error
org.postgresql.util.PSQLException: ERROR: unterminated dollar-quoted
string at or near
$update_track_rating_average$
DECLARE
current_average_rating
Can you post the portion of your build.xml that produces the error you
mention below.
-Rob A
> -Original Message-
> From: Gareth Reakes [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 16, 2006 9:15 AM
> To: Ant Users List
> Subject: postgres stored procedure sql task prob
I seem to remember having some issue creating stored procs and tables,
etc defined in a file with the task. I think what I had to do is
escape each line like:
create proc foo; \
... \
...
Of course disregard the terrible markup above ;)
Its been quite a few years so I don't remember all the
1 - 100 of 172 matches
Mail list logo
