APPLICATION_ID scalar function

[GoogleCodeExporter]

Feature request:
 Add an APPLICATION_ID() scalar function to H2

In some cases it would be very useful to have an application_id.

As for example in DB2:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.r
tn.doc/doc/r0011856.html

application_id is useful when application establishes several connections to 
database and session_id in that case is useless.

And it would be also very cool to implement some functions to set/get variables 
scoped by APPLICATION_ID, it would be very useful in triggers

Original issue reported on code.google.com by kua...@gmail.com on 11 Mar 2011 at 4:31

[GoogleCodeExporter]

Hi,

Is this the session id? H2 already supports that:

http://h2database.com/html/functions.html#session_id

If not, please explain what is the difference.

Also, what exactly is your use case?

Original comment by thomas.t...@gmail.com on 11 Mar 2011 at 7:17

[GoogleCodeExporter]

How would you set the application_id? Could you provide a patch?

Original comment by thomas.t...@gmail.com on 28 Mar 2011 at 7:08

[GoogleCodeExporter]

Resolving as "won't fix" until there is a clear use case.

Original comment by thomas.t...@gmail.com on 28 Mar 2011 at 7:08

• Changed state: WontFix