Package com.northconcepts.datapipeline.foundations.jdbc
package com.northconcepts.datapipeline.foundations.jdbc
Database metadata model and code generation.
-
ClassDescriptionDescribes a database (driver, URL, credentials and driver properties), creates JDBC connections to it and loads its table, schema and query metadata.Callbacks fired while
JdbcConnection.loadTables(LoadTablesRequest)runs: atable...method after each table's step and a plural one once the step is done for all tables.One column of a foreign key that references the owning table's primary key, as reported by JDBCgetExportedKeys.One column of aJdbcIndex: its name, position in the index and sort direction.One column of a foreign key: the referencing (foreign key) column and the primary key column it points to, as reported by JDBCgetImportedKeys; a multi-column key has one entry per column.Metadata for a table index and its columns, as reported by JDBCDatabaseMetaData.getIndexInfo.A named SQL query with its parameters and result columns;JdbcConnection.loadQueries()fills in the columns by running it.Whether a query returns many rows or a single row; generated DAO code reads only the first row forONE.Metadata for one result column of aJdbcQuery, read from JDBCResultSetMetaDatabyJdbcConnection.loadQueries().A?parameter of aJdbcQuery: its name, Java and SQL types, and an expression giving the example value bound whenJdbcConnection.loadQueries()runs the query.One page of query results: its rows plus the page number, page size and total row count.A database schema and the catalog it belongs to, as loaded byJdbcConnection.loadCatalogAndSchemas().A named database destination, such as aJdbcTable.A named table or query whose rows can be read with the SQL fromJdbcSource.getQuery().Whether aJdbcSourceis a table or a query.Metadata for a database table or view (name, schema, type, columns, keys and indexes), as loaded byJdbcConnection.loadTables(LoadTablesRequest).Metadata for a column of aJdbcTable, read from JDBCDatabaseMetaDatabyJdbcConnection.loadTables(LoadTablesRequest).The options forJdbcConnection.loadTables(LoadTablesRequest): which tables to load and which of their details (columns, keys, indexes) to load with them.