Oracle dialect selects wrong column from ALL_SEQUENCES
------------------------------------------------------
Key: GEOT-3972
URL: https://jira.codehaus.org/browse/GEOT-3972
Project: GeoTools
Issue Type: Bug
Components: jdbc-oracle plugin
Affects Versions: 2.7.2
Environment: Both oracle 10 & 11
Reporter: Niels
Assignee: Andrea Aime
In /jdbc-oracle/src/main/java/org/geotools/data/oracle/OracleDialect.java,
method getSequenceForColumn(..) is tried to locate a sequence for a specific
table column. The USER_SEQUENCES is queried first, if nothing is found, a
similar query is executed on ALL_SEQUENCES.
If the query returns results the sequence is available. Next, the code tries
identifying the sequence owner by retrieving the column "OWNER".
This is invalid in oracle 10 or 11, as the column is named SEQUENCE_OWNER.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Cloud Services Checklist: Pricing and Packaging Optimization
This white paper is intended to serve as a reference, checklist and point of
discussion for anyone considering optimizing the pricing and packaging model
of a cloud services business. Read Now!
http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
