ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard Brunelle <binarydream...@gmail.com>
Subject Re: ant sql query weirdness
Date Tue, 17 Nov 2009 18:18:13 GMT
I added some targets and set onerror="continue":

here is the complete code:


<target name="printAccountsData">
        <echo message="PRINT accounts DATA USING: ${db.driver} ${db.url}"/>
        <sql driver="${db.driver}"
             url="${db.url}"
             userid="${db.user}"
             password="${db.pw}"
             onerror="continue"
             print="true">
            <classpath refid="master-classpath"/>

            SELECT * FROM accounts;

        </sql>
    </target>

    <target name="printUsStatesData">
        <echo message="PRINT us_states DATA USING: ${db.driver} ${db.url}"/>
        <sql driver="${db.driver}"
             url="${db.url}"
             userid="${db.user}"
             password="${db.pw}"
             onerror="continue"
             print="true">
            <classpath refid="master-classpath"/>

            SELECT * FROM us_states;

        </sql>
    </target>

    <target name="printUserTypesData">
        <echo message="PRINT user_types DATA USING: ${db.driver}
${db.url}"/>
        <sql driver="${db.driver}"
             url="${db.url}"
             userid="${db.user}"
             password="${db.pw}"
             onerror="continue"
             print="true">
            <classpath refid="master-classpath"/>

            SELECT * FROM user_types;

        </sql>
    </target>

    <target name="printUsersData">
        <echo message="PRINT users DATA USING: ${db.driver} ${db.url}"/>
        <sql driver="${db.driver}"
             url="${db.url}"
             userid="${db.user}"
             password="${db.pw}"
             onerror="continue"
             print="true">
            <classpath refid="master-classpath"/>

            SELECT * FROM users;

        </sql>
    </target>

<target name="printData" depends="printUsStatesData,
                                      printAccountsData,
                                      printUserTypesData,
                                      printUsersData">
        <echo message="PRINT DATA USING: ${db.driver} ${db.url}"/>
    </target>



====================

Here is the output ... it still only prints data from the first target, but
if I run each target individually, it prints the data appropriately for each
target.

# ant -v printData
Apache Ant version 1.7.1 compiled on June 27 2008
Buildfile: build.xml
Detected Java version: 1.5 in:
/System/Library/Frameworks/JavaVM.framework/Versions/1.5.0/Home
Detected OS: Mac OS X
parsing buildfile /Users/richard/Projects/lotterymagic/build.xml with URI =
file:/Users/richard/Projects/lotterymagic/build.xml
Project base dir set to: /Users/richard/Projects/lotterymagic
[antlib:org.apache.tools.ant] Could not load definitions from resource
org/apache/tools/ant/antlib.xml. It could not be found.
 [property] Loading /Users/richard/Projects/lotterymagic/build.properties
Build sequence for target(s) `printData' is [printUsStatesData,
printAccountsData, printUserTypesData, printUsersData, printData]
Complete build sequence is [printUsStatesData, printAccountsData,
printUserTypesData, printUsersData, printData, dropUsStatesTable,
createUserTypesTable, createUsStatesTable, createAccountsTable,
createUsersTable, createTables, build, deploywar, dropUserTypesTable,
loadUsStatesData, loadAccountsData, loadUserTypesData, loadUsersData,
loadData, clearUsStatesData, usage, clearUserTypesData, buildtests, tests,
undeploy, stop, dropAccountsTable, list, start, install, clearUsersData,
clearAccountsData, clearData, dropUsersTable, dropTables, clean, shutdownDb,
dbTests, deploy, reload, ]

printUsStatesData:
     [echo] PRINT us_states DATA USING: com.mysql.jdbc.Driver jdbc:mysql://
mysql.binarydream.us/lotterymagic
      [sql] connecting to jdbc:mysql://mysql.binarydream.us/lotterymagic
      [sql] Loading com.mysql.jdbc.Driver using AntClassLoader with
classpath
/Users/richard/Projects/lotterymagic/war/WEB-INF/lib/commons-logging.jar:/Users/richard/Projects/lotterymagic/war/WEB-INF/lib/jstl.jar:/Users/richard/Projects/lotterymagic/war/WEB-INF/lib/junit-3.8.2.jar:/Users/richard/Projects/lotterymagic/war/WEB-INF/lib/servlet-api.jar:/Users/richard/Projects/lotterymagic/war/WEB-INF/lib/spring-test.jar:/Users/richard/Projects/lotterymagic/war/WEB-INF/lib/spring-webmvc.jar:/Users/richard/Projects/lotterymagic/war/WEB-INF/lib/spring.jar:/Users/richard/Projects/lotterymagic/war/WEB-INF/lib/standard.jar:/usr/local/tomcat/lib/servlet-api.jar:/Users/richard/Projects/lotterymagic/war/WEB-INF/classes
      [sql] Executing commands
      [sql] SQL:  SELECT * FROM us_states
      [sql] Processing new result set.
      [sql] us_state_id,name,code,lottery,games
      [sql] 1,Alabama,AL,0,0
      [sql] 2,Alaska,AK,0,0
      [sql] 3,American Samoa,AS,0,0
      [sql] 4,Arizona,AZ,1,1
      [sql] 5,Arkansas,AR,1,1
      [sql] 6,California,CA,1,1
      [sql] 7,Colorado,CO,1,1
      [sql] 8,Connecticut,CT,1,1
      [sql] 9,Delaware,DE,1,3
      [sql] 10,District of Columbia,DC,1,2
      [sql] 11,Federated States of Micronesia,FM,0,0
      [sql] 12,Florida,FL,1,1
      [sql] 13,Georgia,GA,1,2
      [sql] 14,Guam,GU,0,0
      [sql] 15,Hawaii,HI,0,0
      [sql] 16,Idaho,ID,1,3
      [sql] 17,Illinois,IL,1,1
      [sql] 18,Indiana,IN,1,1
      [sql] 19,Iowa,IA,1,3
      [sql] 20,Kansas,KS,1,4
      [sql] 21,Kentucky,KY,1,2
      [sql] 22,Louisiana,LA,1,1
      [sql] 23,Maine,ME,1,5
      [sql] 24,Marshall Islands,MH,0,0
      [sql] 25,Maryland,MD,1,1
      [sql] 26,Massachusetts,MA,1,1
      [sql] 27,Michigan,MI,1,1
      [sql] 28,Minnesota,MN,1,2
      [sql] 29,Mississippi,MS,0,0
      [sql] 30,Missouri,MO,1,1
      [sql] 31,Montana,MT,1,3
      [sql] 32,Nebraska,NE,1,2
      [sql] 33,Nevada,NV,0,0
      [sql] 34,New Hampshire,NH,1,6
      [sql] 35,New Jersey,NJ,1,1
      [sql] 36,New Mexico,NM,0,2
      [sql] 37,New York,NY,1,1
      [sql] 38,North Carolina,NC,1,4
      [sql] 39,North Dakota,ND,1,3
      [sql] 40,Northern Mariana Islands,MP,0,0
      [sql] 41,Ohio,OH,1,1
      [sql] 42,Oklahoma,OK,1,2
      [sql] 43,Oregon,OR,1,1
      [sql] 44,Palau,PW,0,0
      [sql] 45,Pennsylvania,PA,1,1
      [sql] 46,Puerto Rico,PR,1,0
      [sql] 47,Rhode Island,RI,1,2
      [sql] 48,South Carolina,SC,1,1
      [sql] 49,South Dakota,SD,1,3
      [sql] 50,Tennessee,TN,1,1
      [sql] 51,Texas,TX,1,1
      [sql] 52,Utah,UT,0,0
      [sql] 53,Vermont,VT,1,5
      [sql] 54,Virgin Islands,VI,1,1
      [sql] 55,Virginia,VA,1,2
      [sql] 56,Washington,WA,1,1
      [sql] 57,West Virginia,WV,1,3
      [sql] 58,Wisconsin,WI,1,1
      [sql] 59,Wyoming,WY,0,0
      [sql]
      [sql] 0 rows affected
      [sql] 0 rows affected
      [sql] Committing transaction
      [sql] 1 of 1 SQL statements executed successfully

printAccountsData:
     [echo] PRINT accounts DATA USING: com.mysql.jdbc.Driver jdbc:mysql://
mysql.binarydream.us/lotterymagic
      [sql] connecting to jdbc:mysql://mysql.binarydream.us/lotterymagic
      [sql] Loading com.mysql.jdbc.Driver using a cached AntClassLoader.
      [sql] Executing commands
      [sql] SQL:  SELECT * FROM accounts
      [sql] Processing new result set.
      [sql] 0 rows affected
      [sql] Committing transaction
      [sql] 1 of 1 SQL statements executed successfully

printUserTypesData:
     [echo] PRINT user_types DATA USING: com.mysql.jdbc.Driver jdbc:mysql://
mysql.binarydream.us/lotterymagic
      [sql] connecting to jdbc:mysql://mysql.binarydream.us/lotterymagic
      [sql] Loading com.mysql.jdbc.Driver using a cached AntClassLoader.
      [sql] Executing commands
      [sql] SQL:  SELECT * FROM user_types
      [sql] Processing new result set.
      [sql] 0 rows affected
      [sql] Committing transaction
      [sql] 1 of 1 SQL statements executed successfully

printUsersData:
     [echo] PRINT users DATA USING: com.mysql.jdbc.Driver jdbc:mysql://
mysql.binarydream.us/lotterymagic
      [sql] connecting to jdbc:mysql://mysql.binarydream.us/lotterymagic
      [sql] Loading com.mysql.jdbc.Driver using a cached AntClassLoader.
      [sql] Executing commands
      [sql] SQL:  SELECT * FROM users
      [sql] Processing new result set.
      [sql] 0 rows affected
      [sql] Committing transaction
      [sql] 1 of 1 SQL statements executed successfully

printData:
     [echo] PRINT DATA USING: com.mysql.jdbc.Driver jdbc:mysql://
mysql.binarydream.us/lotterymagic

BUILD SUCCESSFUL
Total time: 0 seconds
Richard P. Brunelle
Solutions Architect
BinaryDream



On Mon, Nov 16, 2009 at 11:05 AM, glenn opdycke-hansen
<glennoph@gmail.com>wrote:

> What is the output from verbose?  ant -v ...
>
> On Mon, Nov 16, 2009 at 08:29, Scot P. Floess <sfloess@nc.rr.com> wrote:
>
> >
> > I see you have onerror set to stop.  What happens if you don't set that
> > attribute?  It defaults to abort if not set...
> >
> >
>

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