Java Mailing List Archive

http://www.ant-tasks.com/

Apache Ant Archive

» Ant Users List
» Ant Developers List
Login to DB as sys user

Login to DB as sys user

2005-05-26       - By Manas Panda
Reply:     1     2  

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@(protected)
For additional commands, e-mail: user-help@(protected)


©2008 ant-tasks.com - Jax Systems, LLC, U.S.A.