JDBCDataStore>>InsertSQL produces invalid Syntax
------------------------------------------------

                 Key: GEOT-1993
                 URL: http://jira.codehaus.org/browse/GEOT-1993
             Project: GeoTools
          Issue Type: Bug
          Components: data h2
            Reporter: Christian Mueller
             Fix For: 2.6-M0, 2.5-RC0


The following code does not append "," to the sql String. Inserting the line 
commented with  // FIX  resolves this issue

        for (PrimaryKeyColumn col : key.getColumns() ) {
            //only include if its non auto generating
            if ( !(col instanceof AutoGeneratedPrimaryKeyColumn ) ) {
                try {
                    Object value = getNextValue(col, key, cx);
                    dialect.encodeValue( value, col.getType(), sql );
                    sql.append(","); // FIX
                } 
                catch( Exception e ) {
                    throw new RuntimeException( e );
                }
            }
        }
        sql.setLength(sql.length() - 1);

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

-------------------------------------------------------------------------
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-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to