Hello people I heard that the OracleDataStore was now brand new and nice, so I decided to try it out. However, I got into some trouble trying to put some data from a shapefile into the database.
So, I'd like to ask some questions: 1. Is Oracle still officially "unsupported" (meaning we don't get to expect too much out of it)? 2. I'm using geotools 2.5-SNAPSHOT, is that really the recommended place for trying out things with Oracle? 3. Just to make sure: is this the correct maven pom snippet to use? <dependency> <groupId>ojdbc</groupId> <artifactId>ojdbc</artifactId> <version>14</version> </dependency> 4. If everything I did was correct, then.. I ended up finding some issues and couldn't get things to work: 4.1 It always fails when I try to create a table (e.g., when creating a schema) that has String (VARCHAR) columns. Actually, we tracked it down to the class org.geotools.data.oracle.SqlStatementEnconder, which simply translates Strings to VARCHAR. But Oracle seems to require a size parameter, only accepting SQL statements with something like VARCHAR(10), etc. It may also be a good idea to use VARCHAR2, since that is what Oracle recommends. Anyway: am I missing something or is this really happening to everybody else? 4.2 After solving that we were able to create a schema and see tables being created OK in the Oracle database. However, we still got into some trouble: although everything seems to be there, we keep getting a SchemaNotFoundException when trying to get the FeatureSource back, I don't know exactly why. Even stranger, calling OracleDataStore.getTypeNames() gives me back 4292 (!) type names even for an empty DataStore (4293 after the successful creation of a schema). Any ideas? Thanks for any help Milton -- Milton Jonathan Grupo GIS e Meio Ambiente Tecgraf/PUC-Rio Tel: +55-21-3527-2502 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
