Howdy,

I'm using geotools in an application where end users are wanting to add
feature types that they've created from database views but unfortunately the
JDBC drivers (I've found this with both Oracle and SQL Server so far) aren't
listing any columns as primary keys for the views so I'm unable to properly
track which rows a user has selected since I end up with a feature type that
has a NullFIDMapper.

I looked at knocking something together with the previous version of the
geotools Oracle driver (by extending the OracleDataStore and overriding
buildFIDMapperFactory to return a custom FIDMapperFactory that builds the
FIDMapper with the columns the user specified), but it doesn't look like
it'll be possible to do it with newer versions of the Oracle driver and now
I've found the same issue with the SQL Server driver.

So, I was wondering if there's an "official" way to handle a situation like
this (i.e. being able to specify what columns to use for fid generation if
there is no primary key) with the jdbc-ng based drivers.

Thanks,
Shaun
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Geotools-gt2-users mailing list
Geotools-gt2-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

Reply via email to