Hi Ming, Have you tried overriding the non transactional methods in the SsccTransactionalTable? These appear to call the base class, so HTable.java. If you provide an override method you should be able to control what data is returned and force it through the SSCC coprocessor. Within the region we can make it behave like a DP@ transaction, so the DTM is not involved. This will improve efficiency and we'll probably want all IDU operations to behave in this manner.
Regards, Sean -----Original Message----- From: ovis_p...@sina.com [mailto:ovis_p...@sina.com] Sent: Tuesday, July 21, 2015 10:49 PM To: dev <dev@trafodion.incubator.apache.org> Subject: how to make select go through DTM in sqlci? hi, all, This is Ming from ShangHai. I am trying to make SSCC pass the SQL regression test. The SQL regression queries are all run through sqlci. So all queries are in 'autocommit' mode, if no explicit 'begin/commit' is invoked? As per Joanie's help, she modified the generator to let all singleton IDU operation go through DTM if the DTM is in SSCC mode. But I find SELECT in sqlci is till bypassing the DTM and invoke native Hbase API directly. How can I force the select go through DTM as well? Any help will be appreciated, like which file to look at and which function, so I can study and test.HBase-trx will still remain the current behavior, so singleton IDU will bypass DTM and rely on HBase's per row transaction protection. thanks,Ming