[Gvsig_english] Ordering a FLyrVect

[erwan bocher]

Hi,

I'd like to order a FLyrVect from a field. I use this :


         SelectableDataSource rsSel = lyrVect.getRecordset();

        String sql ="select * from "+ "countries"+ " order by gid asc;";

        DataSource ds = rsSel.getDataSourceFactory().executeSQL(sql,
DataSourceFactory.MANUAL_OPENING);


However I obtain an error.

Log trace :

com.hardcode.gdbms.engine.instruction.TableNotFoundException:
com.hardcode.gdbms.engine.data.NoSuchTableException: countries
    at com.hardcode.gdbms.engine.instruction.TableListAdapter.getTables(
TableListAdapter.java:53)
    at com.hardcode.gdbms.engine.instruction.SelectAdapter.getTables(
SelectAdapter.java:27)
    at com.hardcode.gdbms.engine.data.DataSourceFactory.getDataSource(
DataSourceFactory.java:1336)
    at com.hardcode.gdbms.engine.data.DataSourceFactory.executeSQL(
DataSourceFactory.java:1668)
    at org.sigle.reso.erwan.io.h2.H2.WriteToH2(H2.java:310)
    at tests.Tests.main(Tests.java:62)
Caused by: com.hardcode.gdbms.engine.data.NoSuchTableException: countries
    at
com.hardcode.gdbms.engine.data.DataSourceFactory.createRandomDataSource(
DataSourceFactory.java:1023)
    at
com.hardcode.gdbms.engine.data.DataSourceFactory.createRandomDataSource(
DataSourceFactory.java:946)
    at com.hardcode.gdbms.engine.instruction.TableListAdapter.getTables(
TableListAdapter.java:43)
    ... 5 more

Thanks.

R1.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20061020/e6e8d533/attachment.htm