Skip to Content
avatar image
VINCENZO TURCO

scope of a local temporary table in HANA through jdbc

Jan 31, 2017 at 11:04 AM | 95 Views

hi all

In my HCP Java web app, I need to call PreparedStatements through jdbc to execute SQL calls that involve local temporary tables in HANA. I need to make sure that these temporary tables are not shared across multiple requests done by application's http clients.

What I know is that local temp tables are specific per session. I am not sure if there is a 1:1 mapping between a java.sql.Connection and a HANA session. I'd assume that if I can make sure that each client request is served by a different Connection, then the HANA sessions will be different and local temp tables will not generate interference.

Can anyone confirm?

Thanks

Vincenzo

SAP HANA
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Benedict Venmani Felix
    Feb 02, 2017 at 05:35 PM

    Hello Vincenzo,

    You are right. The local tables are session specific and the table metadata is itself is not available to another session.

    Benedict

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 03, 2017 at 01:45 AM

    Hi Vincenzo,

    As Benedict pointed and the official public documentation shows you are correct.

    Best Regards,

    Lucas de Oliveira

    Add comment
    10|10000 characters needed characters exceeded