ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan.Mate...@rzf.fin-nrw.de
Subject AW: AW: Problem with sql (with a distant oracle server)
Date Fri, 05 Jul 2002 07:52:16 GMT
The following works for me:

<project name="test" default="main" basedir=".">
    <property name="jdbc.driver" value="oracle.jdbc.driver.OracleDriver" />
    <property name="db.host" value="z011019" />
    <property name="db.name" value="campus"  />
    <property name="db.user" value="mat"     />
    <property name="db.pwd"  value="matmat"  />
    <property name="db.url"
value="jdbc:oracle:thin:@${db.host}:1521:${db.name}" />

    <target name="main">
        <sql driver="${jdbc.driver}" url="${db.url}" userid="${db.user}"
password="${db.pwd}">
            select * from nachrichten;
        </sql>
    </target>

</project>


But I had to place the classes12.zip as Jar-file in the ant\lib-directory
(e.g. oracle817.jar), so Ant could instantiate the driver class.


mit freundlichen Grüßen
Jan Matèrne 

RZF NRW 
Sachgebiet 314-P Methodenberatung 
Internet:	jan.materne@rzf.fin-nrw.de 


> -----Ursprüngliche Nachricht-----
> Von:	Cyriaque Dupoirieux [SMTP:cyriaque.dupoirieux@pcotech.fr]
> Gesendet am:	Freitag, 5. Juli 2002 09:43
> An:	Ant Users List
> Betreff:	Re: AW: Problem with sql (with a distant oracle server)
> 
> 
> Jan.Materne@rzf.fin-nrw.de wrote:
> 
> >Try the SQL-Task:
> >
> I already use the sql task of ant...
> 
> >
> >
> >Executes a series of SQL statements via JDBC to a database. Statements
> can
> >either be read in from a text file using the src attribute or from
> between
> >the enclosing SQL tags.
> >
> >So SQL is on your client machine. 
> >Is this enough?
> >
> I don't know ?
> 
> >
> >
> >
> >mit freundlichen Grüßen
> >Jan Matèrne 
> >
> >RZF NRW 
> >Sachgebiet 314-P Methodenberatung 
> >Internet:	jan.materne@rzf.fin-nrw.de 
> >
> >
> >>-----Ursprüngliche Nachricht-----
> >>Von:	Cyriaque Dupoirieux [SMTP:cyriaque.dupoirieux@pcotech.fr]
> >>Gesendet am:	Freitag, 5. Juli 2002 09:31
> >>An:	Liste Ant
> >>Betreff:	Problem with sql (with a distant oracle server)
> >>
> >>Hello everybody,
> >>   
> >>        I have a problem to execute sql files with ant and I wonder if 
> >>the sql files need to be on the server or if ant is able to
> >>    execute local sql files to a distant server (I installed an Oracle 
> >>client on my machine...)
> >>
> >>    Can you help me ?
> >>
> >>    Regards,
> >>Cyriaque,
> >>
> >>-- 
> >>Cyriaque Dupoirieux <mailto:Cyriaque.Dupoirieux@pcotech.fr>
> >>PCO Technologies
> >>Burolines - 2 ter rue Marcel Doret
> >>31700 Blagnac
> >>Tél : 05.34.60.44.13 - Fax : 05.34.60.44.10
> >>
> >
> 
> -- 
> Cyriaque Dupoirieux <mailto:Cyriaque.Dupoirieux@pcotech.fr>
> PCO Technologies
> Burolines - 2 ter rue Marcel Doret
> 31700 Blagnac
> Tél : 05.34.60.44.13 - Fax : 05.34.60.44.10
> 
> 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message