Re: Connection Properties

[Thomas Mueller]

Hi,

> Is there any way to access the value of a connection property via H2's SQL
> grammar?

Yes, most settings can be read using:

select * from information_schema.settings

Regards,
Thomas

[Jon Freedman]

In this case I'm trying to access a property I've passed through

[Thomas Mueller]

Hi,

> In this case I'm trying to access a property I've passed through

Sorry I don't understand.

Regards,
Thomas

[Jon Freedman]

We're using commons-dbcp BasicDataSource and calling #addConnectionProperty to see appName which SqlServer displays as ProgramName when running sp_who2

Ideally I'd like to be able to query that value using SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'appName' rather than using reflection to access connectionProperties within BasicDataSource

[Thomas Mueller]

Hi,

I don't know how commons-dbcp works internally. Maybe it ignores it, because H2 doesn't support it, or H2 ignores it? If that's the case I guess there is no way to exact the setting as it never arrieved in H2. But you could set a session variable in the database URL, as follows:

    jdbc:h2:~/test;init=set @abc='123'

and then query the setting using

    select @abc;

Regards,

Thomas

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/Sxa6ZKiIfwYJ.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

[Jon Freedman]

A few years later, but more details:

My property is passed into org.h2.Driver#connect inside the info Properties object.

org.h2.engine.ConnectionInfo#readProperties ignores this.

org.h2.engine.Engine#openSession could be modified to handle these and set them as properties

Cheers

Jon

To unsubscribe from this group, send email to h2-database+unsubscribe@googlegroups.com.

[Thomas Mueller Graf]

Hi,

If you have a patch (with test case) then we can have a look at it.

Regards,

Thomas

To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscribe@googlegroups.com.

To post to this group, send email to h2-da...@googlegroups.com.

Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.