Hi,

I'm trying to run HammerDB TPC-C from this tutorial http://hammerora.sourceforge.net/hammerdb_quickstart_trafodion.pdf

I have this environment:

CentOS release 6.7 (Final)
Ambari 2.1.1
HDP 2.2
trafodion-20150828_0830
HammerDB-2.18
java version "1.7.0_79"

On Schema Build I get errors when stored procedures are created.

This is from the hammerdb logs:

Vuser 1:CREATING TPCC STORED PROCEDURES
Vuser 1:Failed to create library /home/trafodion/HammerDB-2.18/NEWORDER.jar

This is what I see in the UI (attached is also a screenshot):

loading history file ... 0 events added
Main console display active (Tcl8.6.0 / Tk8.6.0)
The xml in config.xml is well-formed, applying variables
Error in Virtual User 1: [Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[1382] JAR or DLL file /home/trafodion/HammerDB-2.18/NEWORDER.jar not found. [2015-09-11 07:50:53]À€ç¿™À€éŽˆç»„ç¿™À€éŽ„组翙À€éŽ€ç»„ç¿™À€é 组翙À€éç»„ç¿™À€éŒ¸ç»„ç¿™À€å¦èšç¿™À€ìªˆÊŒÀ€À€ì¹°Ê‰À€À€é 组翙À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€Õ€Ë®À€À€ìŸ ̅À€À€À€À€À€À€À€À€À€À€ï¿¿ï¿¿À€À€ì« ï¿¿ À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€é°À€À€À€ì²Ê‰À€À€îˆ°Ò»À€À€éŸ¼ç«ç¿™À€ë¾°Ç´À€À€å–€ÒÀ€À€ç½Ë—À€À€ì²Ê‰À€À€é’€ç»„ç¿™À€ãµç«ç¿™À€é‘ 组翙À€ìµÊ‰À€À€é°ç»„
(executing the statement)
(HammerDB-2.18) 1 % 

By looking in the tpcc schema I see some tables are created and are populated with data:

>>set schema tpcc;

--- SQL operation complete.
>>get tables;

Tables in Schema TRAFODION.TPCC
===============================

CUSTOMER
DISTRICT
HISTORY
ITEM
NEW_ORDER
ORDERS
ORDER_LINE
STOCK
WAREHOUSE

The file '/home/trafodion/HammerDB-2.18/NEWORDER.jar' exists, attached is the NEWORDER.java

When trying to create the stored procedure from sqlci I get this:

set schema tpcc;
create library testrs file '/home/trafodion/HammerDB-2.18/NEWORDER.jar';
create procedure NEWORD()
       language java
       parameter style java
       external name 'NEWORDER.NEWORD'
       dynamic result sets 1
       library testrs;

*** ERROR[11239] No compatible Java methods named 'NEWORD' were found in Java class 'NEWORDER'.

*** ERROR[1231] User-defined routine TRAFODION.TPCC.NEWORDER could not be created.

Is there an API change on methods for stored procedures in the latest trafodion and hammerdb uses the older syntax? This is the method:

public static void NEWORD (int no_w_id, int no_max_w_id, int no_d_id, int no_c_id, int no_o_ol_cnt, BigDecimal[] no_c_discount, String[] no_c_last, String[] no_c_credit, BigDecimal[] no_d_tax, BigDecimal[] no_w_tax, int[] no_d_next_o_id, Timestamp tstamp, ResultSet[] opres)   
throws SQLException

Also If I disable "Build Java Stored Procedures Locally" from hammerdb I  get:

Vuser 1:CREATING TPCC INDEXES
Vuser 1:Creating Index CUSTOMER_I2...
Vuser 1:Failed to Create Index

--
And in the end, it's not the years in your life that count. It's the life in your years.