Hi ,
If this is your database url =jdbc:oracle:thin:@202.54.41.236:1521:abc
Here abc is the service name.
Where is oracle installed ? On the same machine from where you are running
ant ?
If so go this dir structure : ORA_HOME\bin\tnsping
This utility tells whether oracle service is running.
on command prompt
>tnsping abc
If this fails it means Oracle service is not running and hence the exception
in ANT.
Regards
-Sugandha
----- Original Message -----
From: "Cyriaque Dupoirieux" <[EMAIL PROTECTED]>
To: "Ant Users List" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 2:24 PM
Subject: Re: [Target sql]
> Well,
>
> My problem is that I can indicate the database url but I also need
> to specify the service name and I don't know
> how to do this...
>
> (Sorry, I'm not on Oracle expert...)
>
> Regards,
> Cyriaque,
>
>
> Sugandha Shah wrote:
>
> >Hi Cyriaque ,
> >
> >It is not the problem with driver loading .
> >This error means you are not able to access the machine where Oracle is
> >present.Try to ping the machine where Oracle is present.
> >Kindly also check the dburl. Check whether you are able to access the
> oracle
> >service.
> >
> >Regards
> >-Sugandha
> >
> >
> >----- Original Message -----
> >From: "Cyriaque Dupoirieux" <[EMAIL PROTECTED]>
> >To: "Ant Users List" <[EMAIL PROTECTED]>
> >Sent: Wednesday, January 30, 2002 3:26 PM
> >Subject: Re: [Target sql]
> >
> >
> >>My target is like this :
> >> <sql
> >> driver="${wt.pom.jdbc.driver}"
> >> url="${wt.pom.serviceName}"
> >> userid="${wt.pom.dbUser}"
> >> password="${wt.pom.dbPassword}"
> >> src="${rep.db}/sql/ext/cd/Reinit.sql"
> >> classpathref="path.wt.classpath"
> >> print="yes"
> >> />
> >>
> >>The classpath is set and the driver is found...
> >>
> >>Cyriaque,
> >>
> >>
> >>Nico Seessle wrote:
> >>
> >>>----- Original Message -----
> >>>From: "Cyriaque Dupoirieux" <[EMAIL PROTECTED]>
> >>>To: "Liste Ant" <[EMAIL PROTECTED]>
> >>>Sent: Wednesday, January 30, 2002 10:01 AM
> >>>Subject: [Target sql]
> >>>
> >>>
> >>>>Hello,
> >>>>
> >>>> What does mean the following messages with sql target ?
> >>>>
> >>>> java.sql.SQLException: Exception d'E/S: The Network Adapter
> >>>>could not establish the connection
> >>>> or
> >>>> java.sql.SQLException: No suitable Driver for
> >>>>
> >>thalassa:1521:tlse1
> >>
> >>>> My Oracle is not on my machine...
> >>>>
> >>>But your Oracle JDBC-Driver is? And it is in the classpath? Or you
> have
> >>>provided a nested classpath-element to sql?
> >>>
> >>>Nico
> >>>
> >>>
> >>>
> >>>
> >>>--
> >>>To unsubscribe, e-mail:
> >>>
> >><mailto:[EMAIL PROTECTED]>
> >>
> >>>For additional commands, e-mail:
> >>>
> >><mailto:[EMAIL PROTECTED]>
> >>
> >>>
> >>--
> >>Cyriaque Dupoirieux <mailto:[EMAIL PROTECTED]>
> >>PCO Technologies
> >>Burolines - 2 ter rue Marcel Doret
> >>31700 Blagnac
> >>T�l : 05.34.60.44.13 - Fax : 05.34.60.44.10
> >>
> >>
> >>
> >
> >
> >--
> >To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> >For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
> >
> >
>
> --
> Cyriaque Dupoirieux <mailto:[EMAIL PROTECTED]>
> PCO Technologies
> Burolines - 2 ter rue Marcel Doret
> 31700 Blagnac
> T�l : 05.34.60.44.13 - Fax : 05.34.60.44.10
>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
