oltpbench icon indicating copy to clipboard operation
oltpbench copied to clipboard

Nuodb - Helps!

Open renatofritola opened this issue 4 years ago • 0 comments

I need help using Oltpbench with Nuodb.

I'm trying to run tpcc but the error occurs as below:

./oltpbenchmark -b tpcc -c config/tpcc_config_nuodb.xml --create=true --load=true --execute=true -s 5
18:08:42,061 (DBWorkload.java:270) INFO  - ======================================================================

Benchmark:     TPCC {com.oltpbenchmark.benchmarks.tpcc.TPCCBenchmark}
Configuration: config/tpcc_config_nuodb.xml
Type:          NUODB
Driver:        com.nuodb.jdbc.Driver
URL:           jdbc:com.nuodb://localhost:48004/tpcc
Isolation:     TRANSACTION_SERIALIZABLE
Scale Factor:  2.0

18:08:42,064 (DBWorkload.java:271) INFO  - ======================================================================
18:08:42,099 (DBWorkload.java:533) INFO  - Creating new TPCC database...
Exception in thread "main" java.lang.RuntimeException: Unexpected error when trying to create the tpcc database
        at com.oltpbenchmark.api.BenchmarkModule.createDatabase(BenchmarkModule.java:249)
        at com.oltpbenchmark.DBWorkload.runCreator(DBWorkload.java:837)
        at com.oltpbenchmark.DBWorkload.main(DBWorkload.java:534)
Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to any host [localhost:48004]. Errors are [Connection failed: No suitable transaction engine found for database=tpcc]
        at com.nuodb.jdbc.Driver.connect(Driver.java:133)
        at com.nuodb.jdbc.Driver.connect(Driver.java:101)
        at com.nuodb.jdbc.Driver.connect(Driver.java:96)
        at com.nuodb.jdbc.Driver.connect(Driver.java:63)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
        at com.oltpbenchmark.api.BenchmarkModule.makeConnection(BenchmarkModule.java:114)
        at com.oltpbenchmark.api.BenchmarkModule.createDatabase(BenchmarkModule.java:245)
        ... 2 more

Has anyone done it and can you send me a configuration example?

renatofritola avatar Nov 08 '20 21:11 renatofritola