ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joe McGlynn" <mcgl...@onetouch.com>
Subject RE: Ant target using "java" to create PointBase db
Date Sun, 31 Dec 2000 17:55:04 GMT
Perfect, this was the solution!

Merci,
Joe


-----Original Message-----
From: St├ęphane Bailliez [mailto:sbailliez@imediation.com]
Sent: Saturday, December 30, 2000 4:24 PM
To: ant-user@jakarta.apache.org; mcglynn@onetouch.com
Subject: Re: Ant target using "java" to create PointBase db


I don't really know what is your problem..but there should be one in your
command line.
If you have spaces in a value property they will be quoted. For example:
<jvmarg value="classic -Xmx=64M"/> -->  java "-classic -Xmx=64M" : NOT
CORRECT

<jvmarg line="classic -Xmx=64M"/> -->  java -classic -Xmx=64M

<jvmarg value="classic"/>
<jvmarg value="-Xmx=64M"/> -->  java -classic -Xmx=64M

thus I think the following:

<arg line="jdbc:pointbase://localhost/${DBNAME},new ${src.sql} ${dba.uid}
${dba.pwd}" />

should be better than what you have.

Hope it helps.

--
Stephane Bailliez
Software Engineer, Paris - France
iMediation - http://www.imediation.com
Disclaimer: All the opinions expressed above are mine and not those from my
company.


----- Original Message -----
From: "Joe McGlynn" <mcglynn@onetouch.com>
To: <ant-user@jakarta.apache.org>
Sent: Saturday, December 30, 2000 5:54 PM
Subject: Ant target using "java" to create PointBase db


> This is a tough question to ask succinctly, so please bear with me.
>
> I want to use Ant to automate my builds, which include creating a new SQL
> database instance using PointBase (a commercial Java-based ORDBMS).  They
> have a command line utility that will create an "empty" db and execute a
SQL
> script (to create tables and so forth).  I have done this via a DOS BAT
> file, so I'm sure this part works.
>
> I get as far as the PointBase tool creating the new empty database, but it
> never runs the script.  The name of the script is an argument to the
> PointBase utility, which must see all of the other parameters just fine.
At
> this point I am using Ant from within netbeans IDE.
>
> I'm attaching the Ant code below, any suggestions would be hugely
> appreciated.  (I know the classpath here is not done in a very nice way,
but
> this is just scaffolding to get this part of the build to work, I'll
figure
> out how to get Ant to not rely on fixed -CP later)
>
> TIA,
> Joe
>
> ================
>
> <?xml version="1.0"?>
>
> <!--*********************************************************-->
> <!-- Ant build routine for SW Process project SQL database   -->
> <!-- developed by Joe McGlynn, 12/26/00                      -->
> <!-- all rights reserved, distributable under GPL            -->
> <!--*********************************************************-->
>
> <project name="build_database" basedir="." default="all">
>
>     <!--*********************************************************-->
>     <!-- define global properties for this build step            -->
>     <!--*********************************************************-->
>     <property name="src.sql" value="${basedir}\dbsource.sql"/>
>     <property name="dbtarget" value="d:\pb\network\databases"/>
>     <property name="DBNAME" value="swproc"/>
>     <property name="dba.uid" value="public"/>
>     <property name="dba.pwd" value="public"/>
>
>     <target name="init">
>         <tstamp/>
>         <echo message="Begining  database creation on ${TODAY} at
> ${TSTAMP}"/>
>         <echo message="executing from ${basedir}"/>
>     </target>
>
>     <target name="all" depends="init, MakeSchema">
>         <!-- <echo message="Hello ${world}!"/> -->
>     </target>
>
>     <!--*********************************************************-->
>     <!-- Use the PointBase commander utility                     -->
>     <!-- to create an empty database                             -->
>     <!-- and populate it with application tables                 -->
>     <!--*********************************************************-->
>     <target name="MakeSchema" depends="init">
>         <echo message="begining target MakeSchema at ${TSTAMP} using
> ${src.sql}"/>
>         <java classname="com.pointbase.tools.toolsCommander" fork="true">
>             <classpath>
>                 <pathelement
> location="D:\pb\client\classes\pbtools34GA.jar"/>
>                 <pathelement
> location="D:\pb\client\classes\pbclient34GA.jar"/>
>                 <pathelement location="D:\pb\client"/>
>             </classpath>
>             <arg value="com.pointbase.jdbc.jdbcUniversalDriver" />
>             <arg value="jdbc:pointbase://localhost/${DBNAME},new
${src.sql}"
> />
>             <arg value="${dba.uid} ${dba.pwd}" />
>         </java>
>         <echo message="completed target MakeSchema at ${TSTAMP} using
> ${src.sql}"/>
>     </target>
>
>
> </project>


Mime
View raw message