Package | Description |
---|---|
nl.cwi.monetdb.embedded.env | |
nl.cwi.monetdb.embedded.mapping | |
nl.cwi.monetdb.embedded.resultset | |
nl.cwi.monetdb.embedded.tables |
Modifier and Type | Method and Description |
---|---|
boolean |
MonetDBEmbeddedConnection.checkIfTableExists(String schemaName,
String tableName)
Check if a table exists in the database.
|
void |
MonetDBEmbeddedConnection.commit()
Commits the current transaction.
|
static MonetDBEmbeddedConnection |
MonetDBEmbeddedDatabase.createConnection()
Creates a connection on the database, set on the default schema.
|
static JDBCEmbeddedConnection |
MonetDBEmbeddedDatabase.createJDBCEmbeddedConnection(String directory)
Creates a JDBC embedded connection on the database, set on the default schema.
|
boolean |
MonetDBEmbeddedPreparedStatement.execute()
Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.
|
void |
MonetDBEmbeddedPreparedStatement.executeAndIgnore()
Like the previous one, but without returning any result.
|
QueryResultSet |
MonetDBEmbeddedPreparedStatement.executeQuery()
Executes the SQL query in this PreparedStatement object and returns QueryResultSet ResultSet object generated by
the query.
|
QueryResultSet |
MonetDBEmbeddedConnection.executeQuery(String query)
Executes a SQL query with a result set.
|
int |
MonetDBEmbeddedPreparedStatement.executeUpdate()
Executes the SQL statement in this PreparedStatement object, which must be an SQL INSERT, UPDATE or DELETE
statement; or an SQL statement that returns nothing, such as a DDL statement.
|
int |
MonetDBEmbeddedConnection.executeUpdate(String query)
Executes a SQL query without a result set, returning the number of rows it affected.
|
boolean |
MonetDBEmbeddedConnection.getAutoCommit()
Retrieves the current auto-commit mode for this connection.
|
abstract void |
AbstractConnectionResult.getColumnDigits(int[] input)
Gets the column digits as an integer array.
|
void |
MonetDBEmbeddedPreparedStatement.getColumnDigits(int[] input) |
abstract void |
AbstractConnectionResult.getColumnNames(String[] input)
Gets the columns names as a string array.
|
void |
MonetDBEmbeddedPreparedStatement.getColumnNames(String[] input) |
abstract void |
AbstractConnectionResult.getColumnScales(int[] input)
Gets the column scales as an integer array.
|
void |
MonetDBEmbeddedPreparedStatement.getColumnScales(int[] input) |
abstract void |
AbstractConnectionResult.getColumnTypes(String[] input)
Gets the columns types as a string array.
|
void |
MonetDBEmbeddedPreparedStatement.getColumnTypes(String[] input) |
static String |
MonetDBEmbeddedDatabase.getDatabaseDirectory()
Gets the database's farm directory.
|
abstract void |
AbstractConnectionResult.getMappings(MonetDBToJavaMapping[] input)
Gets the Java mappings as a MonetDBToJavaMapping array.
|
void |
MonetDBEmbeddedPreparedStatement.getMappings(MonetDBToJavaMapping[] input) |
MonetDBTable |
MonetDBEmbeddedConnection.getMonetDBTable(String tableName)
Retrieves a MonetDB Table in the current schema for further operations.
|
MonetDBTable |
MonetDBEmbeddedConnection.getMonetDBTable(String schemaName,
String tableName)
Retrieves a database table for further operations on it such as appending data.
|
static int |
MonetDBEmbeddedDatabase.getNumberOfConnections()
Gets the current total number of connections to the database.
|
int |
MonetDBEmbeddedSavePoint.getSavepointId()
Retrieves the generated ID for the savepoint that this Savepoint object represents.
|
String |
MonetDBEmbeddedSavePoint.getSavepointName()
Retrieves the name of the savepoint that this Savepoint object represents.
|
String |
MonetDBEmbeddedConnection.getSchema()
Retrieves the current schema set on the connection.
|
static boolean |
MonetDBEmbeddedDatabase.isDatabaseRunningInMemory()
Check if the database is running in-memory.
|
static boolean |
MonetDBEmbeddedDatabase.isSequentialFlagSet()
Checks if the Sequential Flag was set while creating the database.
|
static boolean |
MonetDBEmbeddedDatabase.isSilentFlagSet()
Checks if the Silent Flag was set while creating the database.
|
QueryResultSet |
MonetDBEmbeddedConnection.listTables(boolean listSystemTables)
Performs a listing of the existing tables with schemas.
|
MonetDBEmbeddedPreparedStatement |
MonetDBEmbeddedConnection.prepareStatement(String query)
Starts a prepared statement.
|
void |
MonetDBEmbeddedConnection.releaseSavepoint(Savepoint savepoint)
Removes the given Savepoint object from the current transaction.
|
void |
MonetDBEmbeddedConnection.removeTable(String schemaName,
String tableName)
Deletes a table if exists in the database.
|
void |
MonetDBEmbeddedConnection.rollback()
Rollbacks the current transaction.
|
void |
MonetDBEmbeddedConnection.rollback(Savepoint savepoint)
Undoes all changes made after the given Savepoint object was set.
|
void |
MonetDBEmbeddedConnection.setAutoCommit(boolean autoCommit)
Sets this connection's auto-commit mode to the given state.
|
void |
MonetDBEmbeddedPreparedStatement.setBigDecimal(int idx,
BigDecimal x)
Sets the designated parameter to the given java.math.BigDecimal value.
|
void |
MonetDBEmbeddedPreparedStatement.setBlob(int parameterIndex,
Blob x)
Sets the designated parameter to the given Blob object.
|
void |
MonetDBEmbeddedPreparedStatement.setBoolean(int parameterIndex,
boolean x)
Sets the designated parameter to the given Java boolean value.
|
void |
MonetDBEmbeddedPreparedStatement.setByte(int parameterIndex,
byte x)
Sets the designated parameter to the given Java byte value.
|
void |
MonetDBEmbeddedPreparedStatement.setBytes(int parameterIndex,
byte[] x)
Sets the designated parameter to the given Java array of bytes.
|
void |
MonetDBEmbeddedPreparedStatement.setClob(int i,
Clob x)
Sets the designated parameter to the given Clob object.
|
void |
MonetDBEmbeddedPreparedStatement.setDate(int parameterIndex,
Date x)
Sets the designated parameter to the given java.sql.Date value.
|
void |
MonetDBEmbeddedPreparedStatement.setDate(int parameterIndex,
Date x,
Calendar cal)
Sets the designated parameter to the given java.sql.Date value, using
the given Calendar object.
|
void |
MonetDBEmbeddedPreparedStatement.setDouble(int parameterIndex,
double x)
Sets the designated parameter to the given Java double value.
|
void |
MonetDBEmbeddedPreparedStatement.setFloat(int parameterIndex,
float x)
Sets the designated parameter to the given Java float value.
|
void |
MonetDBEmbeddedPreparedStatement.setInt(int parameterIndex,
int x)
Sets the designated parameter to the given Java int value.
|
void |
MonetDBEmbeddedPreparedStatement.setLong(int parameterIndex,
long x)
Sets the designated parameter to the given Java long value.
|
void |
MonetDBEmbeddedPreparedStatement.setNull(int parameterIndex,
int sqlType)
Sets the designated parameter to SQL NULL.
|
void |
MonetDBEmbeddedPreparedStatement.setNull(int paramIndex,
int sqlType,
String typeName)
Sets the designated parameter to SQL NULL.
|
void |
MonetDBEmbeddedPreparedStatement.setObject(int index,
Object x)
Sets the value of the designated parameter using the given object.
|
void |
MonetDBEmbeddedPreparedStatement.setObject(int parameterIndex,
Object x,
int targetSqlType)
Sets the value of the designated parameter with the given object.
|
void |
MonetDBEmbeddedPreparedStatement.setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
Sets the value of the designated parameter with the given object.
|
Savepoint |
MonetDBEmbeddedConnection.setSavepoint()
Creates an unnamed savepoint in the current transaction and returns the new Savepoint object that represents it.
|
Savepoint |
MonetDBEmbeddedConnection.setSavepoint(String name)
Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that
represents it.
|
void |
MonetDBEmbeddedConnection.setSchema(String newSchema)
Sets the current schema for this connection.
|
void |
MonetDBEmbeddedPreparedStatement.setShort(int parameterIndex,
short x)
Sets the designated parameter to the given Java short value.
|
void |
MonetDBEmbeddedPreparedStatement.setString(int parameterIndex,
String x)
Sets the designated parameter to the given Java String value.
|
void |
MonetDBEmbeddedPreparedStatement.setTime(int index,
Time x)
Sets the designated parameter to the given java.sql.Time value.
|
void |
MonetDBEmbeddedPreparedStatement.setTime(int index,
Time x,
Calendar cal)
Sets the designated parameter to the given java.sql.Time value,
using the given Calendar object.
|
void |
MonetDBEmbeddedPreparedStatement.setTimestamp(int index,
Timestamp x)
Sets the designated parameter to the given java.sql.Timestamp value.
|
void |
MonetDBEmbeddedPreparedStatement.setTimestamp(int index,
Timestamp x,
Calendar cal)
Sets the designated parameter to the given java.sql.Timestamp
value, using the given Calendar object.
|
void |
MonetDBEmbeddedPreparedStatement.setURL(int parameterIndex,
URL x)
Sets the designated parameter to the given java.net.URL value.
|
static void |
MonetDBEmbeddedDatabase.startDatabase(String dbDirectory)
Starts a MonetDB database on the given farm.
|
static void |
MonetDBEmbeddedDatabase.startDatabase(String dbDirectory,
boolean silentFlag,
boolean sequentialFlag)
Starts a MonetDB database on the given farm with debugging parameters if desired.
|
void |
MonetDBEmbeddedConnection.startTransaction()
Begins a transaction.
|
static void |
MonetDBEmbeddedDatabase.stopDatabase()
Stops the database.
|
Modifier and Type | Method and Description |
---|---|
static MonetDBToJavaMapping |
MonetDBToJavaMapping.getJavaMappingFromMonetDBString(String sqlName)
Get the corresponding MonetDBToJavaMapping from MonetDB internal data type.
|
static int |
MonetDBToJavaMapping.getJavaMappingFromMonetDBStringOrdinalValue(String sqlName)
Get the corresponding MonetDBToJavaMapping from MonetDB internal data type.
|
Constructor and Description |
---|
AbstractColumn(String columnType,
String columnName,
int columnDigits,
int columnScale) |
Modifier and Type | Method and Description |
---|---|
boolean |
QueryResultSet.checkBooleanIsNull(int column,
int row)
Tests if a boolean in the result set is a null value.
|
QueryResultRowSet |
QueryResultSet.fetchAllRowValues()
Fetches all rows from the result set.
|
QueryResultRowSet |
QueryResultSet.fetchFirstNRowValues(int n)
Fetches the first N rows from the result set.
|
QueryResultRowSet |
QueryResultSet.fetchResultSetRows(int startIndex,
int endIndex)
Fetch rows from the result set.
|
byte[] |
QueryResultSet.getBlobByColumnIndexAndRow(int column,
int row)
Retrieves a single byte[] value (BLOB) in the result set.
|
byte[] |
QueryResultSet.getBlobByColumnNameAndRow(String columnName,
int row)
Retrieves a single byte[] (BLOB) value in the result set by name.
|
void |
QueryResultSet.getBlobColumnByIndex(int column,
byte[][] input)
Retrieves a byte[] (BLOB) column by index.
|
void |
QueryResultSet.getBlobColumnByIndex(int column,
byte[][] input,
int offset,
int length)
Retrieves a byte[] (BLOB) column by index.
|
void |
QueryResultSet.getBlobColumnByName(String columnName,
byte[][] input)
Retrieves a byte[] (BLOB) column by name.
|
void |
QueryResultSet.getBlobColumnByName(String columnName,
byte[][] input,
int offset,
int length)
Retrieves a byte[] (BLOB) column by name.
|
boolean |
QueryResultSet.getBooleanByColumnIndexAndRow(int column,
int row)
Retrieves a single boolean value in the result set.
|
boolean |
QueryResultSet.getBooleanByColumnNameAndRow(String columnName,
int row)
Retrieves a single boolean value in the result set by name.
|
void |
QueryResultSet.getBooleanColumnByIndex(int column,
boolean[] input)
Retrieves a boolean column by index.
|
void |
QueryResultSet.getBooleanColumnByIndex(int column,
boolean[] input,
int offset,
int length)
Retrieves a boolean column by index.
|
void |
QueryResultSet.getBooleanColumnByName(String columnName,
boolean[] input)
Retrieves a boolean column by name.
|
void |
QueryResultSet.getBooleanColumnByName(String columnName,
boolean[] input,
int offset,
int length)
Retrieves a boolean column by name.
|
byte |
QueryResultSet.getByteByColumnIndexAndRow(int column,
int row)
Retrieves a single byte value in the result set.
|
byte |
QueryResultSet.getByteByColumnNameAndRow(String columnName,
int row)
Retrieves a single byte value in the result set by name.
|
void |
QueryResultSet.getByteColumnByIndex(int column,
byte[] input)
Retrieves a byte column by index.
|
void |
QueryResultSet.getByteColumnByIndex(int column,
byte[] input,
int offset,
int length)
Retrieves a byte column by index.
|
void |
QueryResultSet.getByteColumnByName(String columnName,
byte[] input)
Retrieves a byte column by name.
|
void |
QueryResultSet.getByteColumnByName(String columnName,
byte[] input,
int offset,
int length)
Retrieves a byte column by name.
|
void |
QueryResultSet.getColumnDigits(int[] input) |
void |
QueryResultSet.getColumnNames(String[] input) |
void |
QueryResultSet.getColumnNullMappingsByIndex(int column,
boolean[] input)
Gets the null mapping of a column by index.
|
void |
QueryResultSet.getColumnScales(int[] input) |
void |
QueryResultSet.getColumnTypes(String[] input) |
Date |
QueryResultSet.getDateByColumnIndexAndRow(int column,
int row)
Retrieves a single Date value in the result set.
|
Date |
QueryResultSet.getDateByColumnNameAndRow(String columnName,
int row)
Retrieves a single Date value in the result set by name.
|
void |
QueryResultSet.getDateColumnByIndex(int column,
Date[] input)
Retrieves a Date column by index.
|
void |
QueryResultSet.getDateColumnByIndex(int column,
Date[] input,
int offset,
int length)
Retrieves a Date column by index.
|
void |
QueryResultSet.getDateColumnByName(String columnName,
Date[] input)
Retrieves a Date column by name.
|
void |
QueryResultSet.getDateColumnByName(String columnName,
Date[] input,
int offset,
int length)
Retrieves a Date column by name.
|
BigDecimal |
QueryResultSet.getDecimalByColumnIndexAndRow(int column,
int row)
Retrieves a single BigDecimal value in the result set.
|
BigDecimal |
QueryResultSet.getDecimalByColumnNameAndRow(String columnName,
int row)
Retrieves a single decimal value in the result set by name.
|
void |
QueryResultSet.getDecimalColumnByIndex(int column,
BigDecimal[] input)
Retrieves a BigDecimal column by index.
|
void |
QueryResultSet.getDecimalColumnByIndex(int column,
BigDecimal[] input,
int offset,
int length)
Retrieves a BigDecimal column by index.
|
void |
QueryResultSet.getDecimalColumnByName(String columnName,
BigDecimal[] input)
Retrieves an BigDecimal column by name.
|
void |
QueryResultSet.getDecimalColumnByName(String columnName,
BigDecimal[] input,
int offset,
int length)
Retrieves a BigDecimal column by name.
|
double |
QueryResultSet.getDoubleByColumnIndexAndRow(int column,
int row)
Retrieves a single double value in the result set.
|
double |
QueryResultSet.getDoubleByColumnNameAndRow(String columnName,
int row)
Retrieves a single double value in the result set by name.
|
void |
QueryResultSet.getDoubleColumnByIndex(int column,
double[] input)
Retrieves a double column by index.
|
void |
QueryResultSet.getDoubleColumnByIndex(int column,
double[] input,
int offset,
int length)
Retrieves a double column by index.
|
void |
QueryResultSet.getDoubleColumnByName(String columnName,
double[] input)
Retrieves a double column by name.
|
void |
QueryResultSet.getDoubleColumnByName(String columnName,
double[] input,
int offset,
int length)
Retrieves a double column by name.
|
float |
QueryResultSet.getFloatByColumnIndexAndRow(int column,
int row)
Retrieves a single float value in the result set.
|
float |
QueryResultSet.getFloatByColumnNameAndRow(String columnName,
int row)
Retrieves a single float value in the result set by name.
|
void |
QueryResultSet.getFloatColumnByIndex(int column,
float[] input)
Retrieves a float column by index.
|
void |
QueryResultSet.getFloatColumnByIndex(int column,
float[] input,
int offset,
int length)
Retrieves a float column by index.
|
void |
QueryResultSet.getFloatColumnByName(String columnName,
float[] input)
Retrieves a float column by name.
|
void |
QueryResultSet.getFloatColumnByName(String columnName,
float[] input,
int offset,
int length)
Retrieves a float column by name.
|
void |
QueryResultSet.getIntColumnByIndex(int column,
int[] input)
Retrieves an integer column by index.
|
void |
QueryResultSet.getIntColumnByIndex(int column,
int[] input,
int offset,
int length)
Retrieves an integer column by index.
|
void |
QueryResultSet.getIntColumnByName(String columnName,
int[] input)
Retrieves an integer column by name.
|
void |
QueryResultSet.getIntColumnByName(String columnName,
int[] input,
int offset,
int length)
Retrieves an integer column by name.
|
int |
QueryResultSet.getIntegerByColumnIndexAndRow(int column,
int row)
Retrieves a single integer value in the result set.
|
int |
QueryResultSet.getIntegerByColumnNameAndRow(String columnName,
int row)
Retrieves a single integer value in the result set by name.
|
long |
QueryResultSet.getLongByColumnIndexAndRow(int column,
int row)
Retrieves a single long value in the result set.
|
long |
QueryResultSet.getLongByColumnNameAndRow(String columnName,
int row)
Retrieves a single long value in the result set by name.
|
void |
QueryResultSet.getLongColumnByIndex(int column,
long[] input)
Retrieves a long column by index.
|
void |
QueryResultSet.getLongColumnByIndex(int column,
long[] input,
int offset,
int length)
Retrieves a long column by index.
|
void |
QueryResultSet.getLongColumnByName(String columnName,
long[] input)
Retrieves a long column by name.
|
void |
QueryResultSet.getLongColumnByName(String columnName,
long[] input,
int offset,
int length)
Retrieves a long column by name.
|
void |
QueryResultSet.getMappings(MonetDBToJavaMapping[] input) |
void |
QueryResultSet.getNullMappingByName(String columnName,
boolean[] input)
Gets the null mapping of a column by name
|
short |
QueryResultSet.getShortByColumnIndexAndRow(int column,
int row)
Retrieves a single short value in the result set.
|
short |
QueryResultSet.getShortByColumnNameAndRow(String columnName,
int row)
Retrieves a single short value in the result set by name.
|
void |
QueryResultSet.getShortColumnByIndex(int column,
short[] input)
Retrieves a short column by index.
|
void |
QueryResultSet.getShortColumnByIndex(int column,
short[] input,
int offset,
int length)
Retrieves a short column by index.
|
void |
QueryResultSet.getShortColumnByName(String columnName,
short[] input)
Retrieves a short column by name.
|
void |
QueryResultSet.getShortColumnByName(String columnName,
short[] input,
int offset,
int length)
Retrieves a short column by name.
|
String |
QueryResultSet.getStringByColumnIndexAndRow(int column,
int row)
Retrieves a single String value in the result set.
|
String |
QueryResultSet.getStringByColumnNameAndRow(String columnName,
int row)
Retrieves a single String value in the result set by name.
|
void |
QueryResultSet.getStringColumnByIndex(int column,
String[] input)
Retrieves a String column by index.
|
void |
QueryResultSet.getStringColumnByIndex(int column,
String[] input,
int offset,
int length)
Retrieves a String column by index.
|
void |
QueryResultSet.getStringColumnByName(String columnName,
String[] input)
Retrieves a String column by name.
|
void |
QueryResultSet.getStringColumnByName(String columnName,
String[] input,
int offset,
int length)
Retrieves a String column by name.
|
Time |
QueryResultSet.getTimeByColumnIndexAndRow(int column,
int row)
Retrieves a single Time value in the result set.
|
Time |
QueryResultSet.getTimeByColumnNameAndRow(String columnName,
int row)
Retrieves a single Time value in the result set by name.
|
void |
QueryResultSet.getTimeColumnByIndex(int column,
Time[] input)
Retrieves a Time column by index.
|
void |
QueryResultSet.getTimeColumnByIndex(int column,
Time[] input,
int offset,
int length)
Retrieves a Time column by index.
|
void |
QueryResultSet.getTimeColumnByName(String columnName,
Time[] input)
Retrieves a Time column by name.
|
void |
QueryResultSet.getTimeColumnByName(String columnName,
Time[] input,
int offset,
int length)
Retrieves a Time column by name.
|
Timestamp |
QueryResultSet.getTimestampByColumnIndexAndRow(int column,
int row)
Retrieves a single Timestamp value in the result set.
|
Timestamp |
QueryResultSet.getTimestampByColumnNameAndRow(String columnName,
int row)
Retrieves a single Timestamp value in the result set by name.
|
void |
QueryResultSet.getTimestampColumnByIndex(int column,
Timestamp[] input)
Retrieves a Timestamp column by index.
|
void |
QueryResultSet.getTimestampColumnByIndex(int column,
Timestamp[] input,
int offset,
int length)
Retrieves a Timestamp column by index.
|
void |
QueryResultSet.getTimestampColumnByName(String columnName,
Timestamp[] input)
Retrieves a Timestamp column by name.
|
void |
QueryResultSet.getTimestampColumnByName(String columnName,
Timestamp[] input,
int offset,
int length)
Retrieves a Timestamp column by name.
|
void |
QueryResultSet.mapColumnToObjectByIndex(int column,
Object[] input)
Maps a column to a Java Object representation of the array by index.
|
void |
QueryResultSet.mapColumnToObjectByName(String columnName,
Object[] input)
Maps a column to a Java Object representation of the array by name.
|
Modifier and Type | Method and Description |
---|---|
int |
MonetDBTable.appendColumns(Object[] input)
Appends new rows to the table column-wise.
|
void |
MonetDBTable.getColumnDigits(int[] input) |
void |
MonetDBTable.getColumnNames(String[] input) |
void |
MonetDBTable.getColumnScales(int[] input) |
void |
MonetDBTable.getColumnTypes(String[] input) |
void |
MonetDBTable.getMappings(MonetDBToJavaMapping[] input) |
int |
MonetDBTable.iterateTable(IMonetDBTableCursor cursor)
Iterate over the table using a
IMonetDBTableCursor instance. |
Constructor and Description |
---|
MonetDBTableColumn(String columnType,
String columnName,
int columnDigits,
int columnScale,
String defaultValue,
boolean isNullable) |
Copyright © 2018. All rights reserved.