[Geotools-devel] [JIRA] (GEOT-5178) JDBC datastrore initialization should use prepared statements

[Sampo Savolainen (JIRA)]

Title: Message Title

Sampo Savolainen created an issue   GeoTools / GEOT-5178 JDBC datastrore initialization should use prepared statements Issue Type: Improvement Assignee: Unassigned Components: jdbc, jdbc-oracle plugin Created: 02/Aug/15 2:45 PM Environment: GeoServer with tens of featuretypes backed by multiple oracle datastores Priority: Low Reporter: Sampo Savolainen When Geotools initializes a feature backed by a jdbc datastore, it needs to load metadata regarding the features. These queries are done by concatenating string variables to otherwise fixed SQL queries. This is both dangerous and slow. The strings may contain control characters that affect the query and the database needs to create a new execution plan for each query even though the basic query is fixed. Using prepared statements and injecting parameters via PreparedStatement.setString() fixes both issues. Add Comment   This message was sent by Atlassian JIRA (v6.5-OD-08-001#65007-sha1:1fc9846)

------------------------------------------------------------------------------

_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel