DbUtils Class

Show Source

Provides static methods used to initialize a database, copy data from one database to another, find/remove duplicates records, etc.

Constructors

There are no public constructors.

Static Methods

initSchema( Database database, String schema ) returns void

Show Source

initSchema( Database database, String schema, String tableSpace ) returns boolean

Used to execute SQL statements and populate a database with table, views, triggers, etc. If the target database does not exist, an attempt is made to create a new database. Currently only supports PostgreSQL and H2.

database	Connection info for the database
schema	String containing SQL statements. Assumes individual statements are delimited with a semicolon.
tableSpace	Default tablespace used to store tables, views, etc. If null, will use the default database tablespace. This option only applies to PostgreSQL

Show Source

getColumns( String tableName, Database sourceDB ) returns LinkedHashMap<String, Boolean>

Show Source

executeBatch( ArrayList<String> statements, Connection conn ) returns void

Show Source

copyTable( String tableName, String where, Database sourceDB, Database destDB, int pageSize, int numThreads ) returns void

Used to transfer records between 2 databases for a given table.

Show Source

findMismatch( String tableName, Database sourceDB, Database destDB, int pageSize, long offset, AtomicLong rowID ) returns void

Used to find mismatched between the 2 databases for a given table.

Show Source

deleteDuplicates( String tableName, Database database, Long startRow, Long endRow, int pageSize, int numThreads ) returns void

Used to find and delete duplicates in a given table.

Show Source

getJson( Recordset rs ) returns JSONObject

Returns a JSON representation of a record in a Recordset

Show Source

getJson( javaxt.sql.Record record ) returns JSONObject

Show Source

getJson( javaxt.sql.Field[] fields ) returns JSONObject

Show Source

getJson( String sql, Connection conn, boolean separateRowsAndColumns ) returns String

Show Source