oltpbench icon indicating copy to clipboard operation
oltpbench copied to clipboard

NuoDB hacks

Open bryanosborne opened this issue 6 years ago • 0 comments

PR related to Issue #306 . Information included not intended to provide a fix, only to illuminate issue.

Connection string issue:

NuoDB connection string construction needs a schema name (from NuoDB):

Properties properties = new Properties();
properties.put("user", user);
properties.put("password", password);
properties.put("schema", "hello");
dbConnection = DriverManager.getConnection(DATABASE_URL + dbName, properties);

Changes to BenchmarkModule.java reflect a workaround to facilitate this, but best solution is probably a new configuration parameter (per A. Pavlo).

Other peripheral items included in this PR found in experimenting with NuoDB and oltpbench:

Included an example config file for chbenchmark running on NuoDB that may be of help to folks.

Changes to chbenchmark-nuodb-ddl.sql prevent error in database creation due to foreign key constraint.

Changes to queries were just to add semicolon terminators, except Q15 which I honestly don't remember changing.

bryanosborne avatar Jan 04 '20 18:01 bryanosborne