Re: exec unix script not working for me

2009-07-22 Thread David Weintraub
On Wed, Jul 22, 2009 at 12:04 PM, Amy Davis wrote: > That was it! I use JEdit to edit my unix script file, but neglected to use > the unix line separator under utilities => buffer options. > The error messages I was getting did not lead me to the real problem. > Thanks so much! I've spent a lot of

Re: exec unix script not working for me

2009-07-22 Thread Amy Davis
ing that change to my unix script file, each of the following 3 options now work. This does not work: - Original Message From: David Weintraub To: Ant Users List Sent: Tuesday, July 21, 2009 7:46:28 PM Subject: Re: exec unix script not workin

Re: exec unix script not working for me

2009-07-21 Thread glenn opdycke-hansen
exit 1 > > fi > > ORACLE_HOME=/u00/oracle/oracle/product/10.2.0/db_1 > > export ORACLE_HOME > > /u00/oracle/oracle/product/10.2.0/db_1/bin/sqlplus -L > username/passw...@sidname @${deployScriptPath}/MasterDeployScript.sql > > ${deployScriptPath}/SQLDeploy.ou

Re: exec unix script not working for me

2009-07-21 Thread David Weintraub
]; then >    echo "The MasterDeployScript.sql file path is required." >    exit 1 > fi > ORACLE_HOME=/u00/oracle/oracle/product/10.2.0/db_1 > export ORACLE_HOME > /u00/oracle/oracle/product/10.2.0/db_1/bin/sqlplus -L > username/passw...@sidname @${deployScriptPath}

Re: exec unix script not working for me

2009-07-21 Thread David Weintraub
eployScriptPath}" ]; then >    echo "The MasterDeployScript.sql file path is required." >    exit 1 > fi > ORACLE_HOME=/u00/oracle/oracle/product/10.2.0/db_1 > export ORACLE_HOME > /u00/oracle/oracle/product/10.2.0/db_1/bin/sqlplus -L > username/passw...@sidna

Re: exec unix script not working for me

2009-07-21 Thread Amy Davis
t.sql > ${deployScriptPath}/SQLDeploy.out - Original Message From: David Weintraub To: Ant Users List Sent: Tuesday, July 21, 2009 12:04:48 PM Subject: Re: exec unix script not working for me If you put a Shebang in your shell script, and you have the executable bit on in the mode, you d

Re: exec unix script not working for me

2009-07-21 Thread David Weintraub
If you put a Shebang in your shell script, and you have the executable bit on in the mode, you don't have to specify the shell. HOWEVER, if you do use the shell, you need to put the full directory name where your script can be found: By the way, is ${sql.deploy.script} a directory

Re: exec unix script not working for me

2009-07-21 Thread robert lazarski
ript file is being pulled from SVN into TeamCity's work area when > the build is run. Its from there that I'm trying to execute the script. Hmm, try: > > - Original Message > From: robert lazarski > To: Ant Users List > Sent: Tuesday,

Re: exec unix script not working for me

2009-07-21 Thread Amy Davis
-- From: robert lazarski To: Ant Users List Sent: Tuesday, July 21, 2009 9:25:56 AM Subject: Re: exec unix script not working for me On Tue, Jul 21, 2009 at 11:21 AM, Amy Davis wrote: > > I'm having trouble getting a unix script to execute through my ant script. > What am I

Re: exec unix script not working for me

2009-07-21 Thread robert lazarski
On Tue, Jul 21, 2009 at 11:21 AM, Amy Davis wrote: > > I'm having trouble getting a unix script to execute through my ant script. > What am I doing wrong? > > /u01/ossint/TeamCityBuildAgent/work/ba331bf4546cf0c1/sql/build.xml:62: > Execute failed: java.io.IOException: Cannot run program "runSqlP

exec unix script not working for me

2009-07-21 Thread Amy Davis
I'm having trouble getting a unix script to execute through my ant script. What am I doing wrong? Attempt 1 ant script snippet: Attempt 1 verbose output: [if] copy [copy] Copying 1 file to /u01/ossint/TeamCityBuildAgent/work/ba331bf4546cf0c1/sql/deployment/r1-0 [if] chmod