[h2] Issue with MODE=MSSQLServer and [] quoted schema/table names

2017-08-22 Thread Jon Freedman
Given the following SQL run against the connection string jdbc:h2:mem:;MODE=MSSQLServer;IGNORECASE=TRUE CREATE SCHEMA dbo; CREATE TABLE dbo.foo ( date date NOT NULL, value numeric(28,9) NOT NULL, PRIMARY KEY ( date ) ); We end up with a table which can be addressed in the fo

[h2] Re: Connection Properties

2017-01-23 Thread 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 On Friday

Re: Connection Properties

2012-07-17 Thread 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 re

Re: Connection Properties

2012-07-12 Thread Jon Freedman
In this case I'm trying to access a property I've passed through On Tuesday, 26 June 2012 19:56:13 UTC+1, Thomas Mueller wrote: > > 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 * f

Connection Properties

2012-06-21 Thread Jon Freedman
Is there any way to access the value of a connection property via H2's SQL grammar? I'm trying to write a unit test to verify that the appName connection property is correctly being passed through commons-db's BasicDataSource -- You received this message because you are subscribed to the Googl