SCHEMA PRIVILEGES

Hi all. First of all I would like the developers and community for such a wonderful DBMS. I can honestly say that, as far as my developing and teaching needs goes, H2 drives a much more pleasant developing / testing experience than what the other big and well established databases (both open source

Re: SCHEMA PRIVILEGES

Thomas, Thanks for the fast response and keep on the good work with h2. Cheers, On Jul 31, 3:31 pm, Thomas Mueller wrote: > Hi, > > The current "access right" functionality is limited, and it is planned > to improve this area. See also the roadmap. Schema privileges also > belong in this catego

Alias concat column name

en achieve Alias with JDBC I have checked the doc and not sure how to set ALIAS_COLUMN_NAME and where to set it. I am using netbeans 6.9.1 IDE Many thanks in advance Anthony -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post

Re: Alias concat column name

Many Thanks On Oct 1, 7:02 am, Thomas Mueller wrote: > Hi > > 1) You need to use || instead of &: > > SELECT SURNAME || '  ' || FORENAME AS FULLNAME FROM EMPLOYEE_DATA > > I didn't know & can be used to concatenate text in MS Access. I will > add a feature request. > > 2) Alias column names: > S

Re: Huge Performance difference during data import between vers. 118 and 144 - SOLVED?

Many Many Thanks chris that was very useful. Did as you suggest and wow Thanks for that Menkaura On Apr 25, 10:04 pm, Chris Schanck wrote: > Resurrecting a thread from the dead is always fun... > > We use H2 in our product as a small JDBC backend suitable for development > before deployment ov

Unique Database/Catalog Name

Hi, Is there a way to get a unique database or catalog name? eg: jdbc:h2:mem:abc/test -> catalog name=test jdbc:h2:mem:xyz/test -> catalog name=test But abc/test and xyz/test are different databases and they have the same catalog name. So why do I need a unique database name? I'm implementing a

DatabaseEventListener#init(url) - URL is null

abase startup. Or is there an easier way to get a Database Connection within a DatabaseEventListener? Thanks, Anthony -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com.

Re: DatabaseEventListener#init(url) - URL is null

I can call startup script by adding INIT=RUNSCRIPT FROM 'blah.sql' in the connection string. But still interesting to see why the URL is null On May 2, 5:21 pm, Anthony wrote: > Hi, > > I've implemented a DatabaseEventListener; When thedatabaseengine > calls Database

Re: How to manually migrate from 1.1.127 to 1.2.147 ?

word", oldDBSQLPath, null, false); System.out.println( String.format("Created %s using %s", newDBPath, oldDBSQLPath)); } You'll need these two jars in the classpath: http://h2database.com/h2mig_pagestore_addon.jar and h2-1.2.147.jar With h

Re: Unique Database/Catalog Name

Answering my own question.. I was able to get the database name using Internal H2 API String databaseName = ((Session) ((JdbcConnection)conn).getSession()).getDatabase().getName(); On May 2, 1:20 pm, Anthony wrote: > Hi, > > Is there a way to get a unique database or catalog nam

SHOW COLUMNS FROM does not support schema - bug?

ig problem once you know the issue, I can rewrite the statement to SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='S1' AND TABLE_NAME='T1' It just caught me out because it didn't work as I expected to. Regards, Anthony -- You received this mes

AlterTableAlterColumn removes Trigger for old table then init new Trigger

tracks of when a table is last accessed, the behaviour above is causing the Trigger to record incorrect information. Is this behaviour by design? I don't mind dropping of the Trigger but the fact that it's passing table names like TEMP_TABLE_2_0 seems incorrect to me. Anthony -- You rec

Re: DatabaseEventListener#init(url) - URL is null

s is in the Server's classpath. Regards, Anthony On May 6, 11:28 pm, Thomas Mueller wrote: > Hi, > > I can't reproduce the problem. In my test case, the database URL is > correct. I wonder if the database event listener is the right tool for > what you need. By the way, the s

Re: SHOW COLUMNS FROM does not support schema - bug?

T SCHEMA S1; SHOW COLUMNS FROM T1; Regards, Anthony On May 10, 3:11 am, Thomas Mueller wrote: > Hi, > > Which version of H2 do you use? This should work since version 1.3.154, see > alsohttp://www.h2database.com/html/changelog.html"MySQL compatibility: > SHOW COLUMN FOR

Re: Unique Database/Catalog Name

Hi, In my application, it create databases for users on demand and each user can have multiple databases. eg: jdbc:h2:mem:/ After understanding the behaviour of H2 Database, there's no reason, why I can't implement it as jdbc:h2:mem:- Thanks for your help. Anthony On May 1

Re: AlterTableAlterColumn removes Trigger for old table then init new Trigger

ableAlterColumn#copyData() 1. create new temp table 2. #cloneTableStructure() (without triggers) 3. #checkViews() //get views 4. #checkTriggers() //get triggers 5. DROP TABLE oldTable CASCADE 6. renameSchemaObject for newTable 7. execute the triggers 8. execute the views Regards Anthony On

Re: Problem with Embedded H2

What connection string did you used to connect to H2 from your application? Anthony On May 14, 10:42 am, Vinícius wrote: > Hello people, I'm with a small problem in my application. I have a > application with H2 in embedded mode and I want that the application > run on a flash d

node.js driver

Hi everyone I am looking for a node.js driver to use with H2. I am aware of the postgresql driver but it does not have all the features as H2 native. Does anyone know of a node.js driver. Many thanks in advance. Anthony -- You received this message because you are subscribed to the Google

Re: H2 and Lazarus?

I have the same question On Thursday, June 14, 2012 9:05:29 PM UTC+1, Lizard Lizard wrote: > > Just wondering, does anyone have any experience connecting H2 and > Lazarus, the "don't call it a freeware Delphi clone, but it's a > freeware Delphi clone" RAD tool? > > There's some generic ODBC con

[h2] JSON support

more developer are implementing some form of ajax web base systems such a feature can only improve our productivity. Any thought on the will be appreciated. Anthony -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

Re: [h2] JSON support

? What does it mean? If > you want to query data contained inside json fragment (or xml) decompose it > to relations and voila. > On Jul 19, 2013 12:51 PM, "Anthony" > > wrote: > >> I notice that JSON support is way down on priority 2 list. Surely this >> sho

Re: [h2] JSON support

overhead. In my search I came across a few projects in this area eg JSONiq, JaQL, JSonQuery, ObjectPath, UnQL. They are young, but maybe a temp solution for now. Thanks all for your feedback. If anyone know of a better way please reply. Regards Anthony. On Saturday, July 20, 2013 6:24

[h2] Csv should support setEscapeWhenNeeded(boolean)

lue)) { value = escapeDelimiter + value + escapeDelimiter; } or something like this Should I create an issue for this problem? Kind regards, Anthony -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

Re: [h2] Csv should support setEscapeWhenNeeded(boolean)

Hi, I looked at the possible options but I still miss the option to escape fields only when needed for the writer instead of always escaping all fields as shown in my example above. Anthony On Saturday, January 18, 2014 4:32:51 PM UTC+1, Noel Grandin wrote: > > You can control the del

Open Source Office Suite using H2 database Released

http://www.joeffice.com <http://www.joeffice.com> http://www.joeffice.org <https://lh4.googleusercontent.com/-rYkeFMKRFZY/UZzoZ4O0vrI/AKo/fa-XqWQ7PEc/s1600/database.png> Best regards, Anthony Goubard -- You received this message because you are subscribed to the