Examples of org.geotools.jdbc.AutoGeneratedPrimaryKeyColumn

org.geotools.jdbc.AutoGeneratedPrimaryKeyColumn
Represents a column of a primary key whose values are auto generated by the database.
This class does not generate new values for the key, relying on the database to do so.
@author Justin Deoliveira, OpenGEO @source $URL$

                            columnType = Thread.currentThread().getContextClassLoader().loadClass(
                                    md.getColumnClassName(i));
                        } catch (ClassNotFoundException e) {
                            columnType = Object.class;
                        }
                        columns.add(new AutoGeneratedPrimaryKeyColumn(columnLabel, columnType));
                    }
                }
            } catch (SQLException e) {
                String from = "'" + table + "'";
                if (schema != null) {

View Full Code Here

            while (next) {
                String columnName = result.getString("ColumnName").trim();
                int ordinal = tableMetadata.ordinal(columnName);
                Class<?> columnClass = tableMetadata.columnClass(ordinal);
                if (tableMetadata.isAutoIncrement(ordinal)) {
                    columns.add(new AutoGeneratedPrimaryKeyColumn(columnName, columnClass));
                }
                next = result.next();
            }
        } catch (SQLException e) {
        } finally {

View Full Code Here

            while (next) {
                int ordinal = Integer.parseInt(result.getString("ColumnPosition").trim());
                String columnName = result.getString("ColumnName").trim();
                Class<?> columnClass = tableMetadata.columnClass(ordinal);
                if (tableMetadata.isAutoIncrement(ordinal)) {
                    columns.add(new AutoGeneratedPrimaryKeyColumn(columnName, columnClass));
                } else {
                    columns.add(new NonIncrementingPrimaryKeyColumn(columnName, columnClass));
                }
                next = result.next();
            }

View Full Code Here

                    String columnName = md.getString("COLUMN_NAME").trim();
                    int ordinal = tableMetadata.ordinal(columnName);
                    if (ordinal >= 0) {
                        Class<?> columnClass = tableMetadata.columnClass(ordinal);
                        if (tableMetadata.isAutoIncrement(ordinal)) {
                            columns.add(new AutoGeneratedPrimaryKeyColumn(columnName, columnClass));
                        } else {
                            columns
                                    .add(new NonIncrementingPrimaryKeyColumn(columnName,
                                            columnClass));
                        }

View Full Code Here

            run("CREATE MULTISET TABLE \"ft3_geometry_idx\""
                    + " (id INTEGER NOT NULL, cellid INTEGER NOT NULL) PRIMARY INDEX (id)");
//                    + " (id INTEGER NOT NULL, cellid INTEGER NOT NULL)");
            run("CREATE HASH INDEX ft3_geometry_idx_idx (cellid) ON ft3_geometry_idx ORDER BY (cellid);");
            TeradataDialect d = new TeradataDialect(null);
            PrimaryKeyColumn col = new AutoGeneratedPrimaryKeyColumn("id", null);
            d.installTriggers(getDataSource().getConnection(),"ft3","geometry","ft3_geometry_idx",Arrays.asList(col));
            
            runSafe("DELETE FROM sysspatial.tessellation WHERE f_table_name = 'ft3'");
            run("INSERT INTO sysspatial.tessellation VALUES (" 
                    + "'geotools',"

View Full Code Here

TOP

Related Classes of org.geotools.jdbc.AutoGeneratedPrimaryKeyColumn

org.geotools.data.teradata.TeradataDialectTest$DialectTestSetup

org.geotools.data.teradata.TeradataPrimaryKeyFinder

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.