FID failed in oracle
---------------------
Key: GEOT-3670
URL: https://jira.codehaus.org/browse/GEOT-3670
Project: GeoTools
Issue Type: Bug
Components: jdbc, jdbc-oracle plugin
Affects Versions: 2.7.1
Reporter: jie yan
1) create the following schema:
String tspec = "geom:LineString:srid=4326,name:String";
SimpleFeatureType roadType = DataUtilities.createType("road", tspec);
ds.createSchema(roadType);
2) SQL dialect:
CREATE TABLE ROAD ( FID INTEGER PRIMARY KEY, GEOM MDSYS.SDO_GEOMETRY, NAME
VARCHAR2(255) );
3) [sqlplus] desc road result:
FID NOT NULL NUMBER(38)
GEOM MDSYS.SDO_GEOMETRY
NAME VARCHAR2(255)
4) when insert a new feature:
the result of getNextValues() is integer 1 at JDBCDataStore.java(1396),
but failed to convert Integer to BigDecimal at PreparedStatementSQL.java(135)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense..
http://p.sf.net/sfu/splunk-d2d-c1
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
