On 4 August 2011 09:20, Miras Bastien <[email protected]> wrote:
> 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?
Would
select rownum, * from t_product;
do what you need?
Andy.
--
http://www.justgiving.com/AndyStevens-Bikeathon2011
Raising money for Leukaemia Research
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
