trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Radu Marias <radumar...@gmail.com>
Subject HammerDB issues
Date Fri, 11 Sep 2015 14:27:29 GMT
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.
Mime
View raw message