ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Miras Bastien <bmi...@yahoo.com>
Subject Sql task and rowcountproperty
Date Thu, 04 Aug 2011 08:27:00 GMT
Hello,

I'm trying to use the rowcountproperty parameter in the sql task.

My ant code looks like:
<sql
                            driver="oracle.jdbc.driver.OracleDriver"
                            url=" jdbc:oracle:thin:@localhost:11522:TINSTA"
                            userid="${db.user}"
                            password="${db.pwd}" 
                            rowcountproperty="db.data.nbLine">
                            select * from t_product;
</sql>
But the db.data.nbLine property is not updated.

Looking at:
http://javasourcecode.org/html/open-source/ant/ant-1.8.1/org/apache/tools/ant/taskdefs/SQLExec.java.html#line.797

it seems rowcountproperty give a count of updated rows only.
Is it the feature expected?
In this case, how can I get the row number using a SELECT statement?

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