scope of a local temporary table in HANA through jdbc

[former_member190457]

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

[BenedictV · Accepted solution]

Hello Vincenzo,

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

Benedict

[lucas_oliveira]

Hi Vincenzo,

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

Best Regards,

Lucas de Oliveira