Return-Path: 
 <user-return-50348-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 67808 invoked from network); 27 May 2005 13:44:58 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 27 May 2005 13:44:58 -0000
Received: (qmail 67719 invoked by uid 500); 27 May 2005 13:44:48 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 67676 invoked by uid 500); 27 May 2005 13:44:47 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 67662 invoked by uid 99); 27 May 2005 13:44:47 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from lapis.wpds.com (HELO lapis.wpds.com) (216.103.245.66)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 27 May 2005 06:44:47 -0700
Received: from wpdslajolla.unigold (unverified [216.103.244.29])
	by lapis.wpds.com (SurgeMail 2.1c7) with ESMTP id 2082851
	for <user@ant.apache.org>; Fri, 27 May 2005 06:51:44 -0700
Received: by localhost with Internet Mail Service (5.5.2653.19)
	id <KG5BD6LN>; Fri, 27 May 2005 06:42:30 -0700
Message-ID: <EC41DD8A52BBD7118FA800A0C9E56BB2179935@localhost>
From: "Shatzer, Larry" <Larry.Shatzer@MIROtechnologies.com>
To: 'Ant Users List' <user@ant.apache.org>
Subject: RE: Login to DB as sys user
Date: Fri, 27 May 2005 06:42:21 -0700
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain
X-Server: High Performance Mail Server - http://surgemail.com
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

I don't know about the sql task, but if you have a sql file, and use sqlplus
(with an exec task), put this at the top of the file that needs to be run.

CONNECT sys/password@database as sysdba
                              ^^^^^^^^^
That part is needed.


-----Original Message-----
From: Manas Panda [mailto:manas.panda@gmail.com] 
Sent: Thursday, May 26, 2005 6:39 AM
To: user@ant.apache.org
Subject: Login to DB as sys user


Hi All,
I have an requirement for which I have to login to database as "sys"
user and also I have to use "sql" task. Is there any way in ANT so
that I can login as "sys" user.I am using following task

<sql
driver="oracle.jdbc.driver.OracleDriver"
classpath="${classes12_jar}"
url="${DB_URL}"
src="@{file}"
userid="sys"
password="xyz"
onerror="continue"
keepformat="true"
print="yes">
</sql>

while executing above task it throws error " java.sql.SQLException:
ORA-28009: connection to sys should be as sysdba or sysoper"

Thanks in advance

Manas

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org