* are defined in the dbtune table.
*/
if (LOGGER.isLoggable(Level.FINE)) {
System.out.println("\n--> Creating a table using DBMS Default Keyword");
}
SeColumnDefinition[] tmpCols = new SeColumnDefinition[] { new SeColumnDefinition(
"tmp", SeColumnDefinition.TYPE_STRING, 5, 0, true) };
table.create(tmpCols, testData.getConfigKeyword());
if (LOGGER.isLoggable(Level.FINE)) {
System.out.println(" - Done.");
}
SeColumnDefinition[] colDefs = new SeColumnDefinition[7];
/*
* Define the columns and their attributes for the table to be created. NOTE:
* The valid range/values of size and scale parameters vary from one database to
* another.
*/
boolean isNullable = true;
colDefs[0] = new SeColumnDefinition("INT32_COL",
SeColumnDefinition.TYPE_INTEGER, 10, 0, isNullable);
colDefs[1] = new SeColumnDefinition("INT16_COL",
SeColumnDefinition.TYPE_SMALLINT, 4, 0, isNullable);
colDefs[2] = new SeColumnDefinition("FLOAT32_COL",
SeColumnDefinition.TYPE_FLOAT, 5, 2, isNullable);
colDefs[3] = new SeColumnDefinition("FLOAT64_COL",
SeColumnDefinition.TYPE_DOUBLE, 15, 4, isNullable);
colDefs[4] = new SeColumnDefinition("STRING_COL",
SeColumnDefinition.TYPE_STRING, 25, 0, isNullable);
colDefs[5] = new SeColumnDefinition("DATE_COL", SeColumnDefinition.TYPE_DATE,
1, 0, isNullable);
colDefs[6] = new SeColumnDefinition("INT64_COL",
SeColumnDefinition.TYPE_INTEGER, 10, 0, isNullable);
table.addColumn(colDefs[0]);
table.addColumn(colDefs[1]);
table.addColumn(colDefs[2]);