The problem was not in the code I presented, but the value of ind.toStringID
() that had some garbage in addition to the ID of the feature.
On Fri, Feb 17, 2012 at 3:48 PM, Joao Lobo <[email protected]> wrote:
> problem solved
>
>
> On Fri, Feb 17, 2012 at 3:06 PM, Joao Lobo <[email protected]> wrote:
>
>> I followed
>> this<http://docs.geotools.org/latest/userguide/library/data/featuresource.html>tutorial
>> that explains how can you update data in database, but is not working
>> in my case.
>>
>> 1. I have a method to pass parameters to connect to database:
>>
>> public Map getParams() {
>>> Map params = new HashMap();
>>> params.put("dbtype", "postgis");
>>> params.put("host", "localhost");
>>> params.put("port", new Integer(5432));
>>> params.put("schema", "urbanenvironment");
>>> params.put("database", "ypenburg");
>>> params.put("user", "postgres");
>>> params.put("passwd", "postgres");
>>> return params;
>>> }
>>
>>
>> 2. Create a DataStore (pgDataStore) and try to implement the various
>> steps of the transaction in accordance with the example in the tutorial.
>> - *u**e_inf_landuse* is the name of the table that I modified on the
>> database
>> - *Function* is the table column that i want to change in ue_inf_landuse
>> table
>> - The String function corresponds to the field that I want to change in the
>> column function
>>
>> /**
>>>
>>> * Ligar a base de dados
>>>
>>> */
>>>
>>> Map params = getParams();
>>>
>>> try {
>>>
>>> pgDataStore = DataStoreFinder.getDataStore(params);
>>>
>>> SimpleFeatureStore store = (SimpleFeatureStore)
>>>> pgDataStore.getFeatureSource("ue_inf_landuse");
>>>
>>> Transaction transaction = new DefaultTransaction("Teste");
>>>
>>> store.setTransaction(transaction);
>>>
>>> FilterFactory ff =
>>>> CommonFactoryFinder.getFilterFactory(GeoTools.getDefaultHints());
>>>
>>> Filter filter = ff.id
>>>> (Collections.singleton(ff.featureId(ind.toStringID())));
>>>
>>>
>>>> SimpleFeatureType featureType = store.getSchema();
>>>
>>> try {
>>>
>>> store.modifyFeatures("function", function, filter);
>>>
>>> transaction.commit();
>>>
>>> } catch (Exception ex) {
>>>
>>> transaction.rollback();
>>>
>>> }
>>>
>>> } catch (IOException ex) {
>>>
>>> Exceptions.printStackTrace(ex);
>>>
>>> }
>>>
>>>
>> --
>> Com os melhores cumprimentos,
>>
>> João Lobo
>>
>
>
>
> --
> Com os melhores cumprimentos,
>
> João Lobo
>
--
Com os melhores cumprimentos,
João Lobo
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
GeoTools-GT2-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
