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

On Friday, 20 July 2012 16:58:35 UTC+1, Thomas Mueller Graf wrote:
>
> 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
>
>
>
>
>
>
> "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
>>
>>
>> On Friday, 13 July 2012 18:32:04 UTC+1, Thomas Mueller wrote:
>>>
>>> Hi, 
>>>
>>> > In this case I'm trying to access a property I've passed through 
>>>
>>> Sorry I don't understand. 
>>>
>>> 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 [email protected].
>> To unsubscribe from this group, send email to 
>> [email protected].
>> For more options, visit this group at 
>> http://groups.google.com/group/h2-database?hl=en.
>>
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to