Hi, Thomas: Sorry for pasting the wrong code, i simply erase the database's name from the real code... Let's say: jdbc:h2:mem:testdb;MULTI_THREADED=1
Yes, as you proposed, i just wanna to share the same database (with database name) to several threads in the application. The question is: whether it's possible to monitor the database "testdb" condition from an external tool? I tried to connect to "testdb" during the execution of the application, using: "java -cp h2-1.1.107.jar org.h2.tools.Server" It seems I am able to login "testdb" from the prompted browser page, however, the latest "testdb" content modification can't be obtained. Regards ye On 10 Feb, 2009, at 8:38 PM, Thomas Mueller wrote: > > Hi, > >> jdbc:h2:mem:;MULTI_THREADED=1 > > This will create a separate database for each connection. Is this what > you want? In that case you can only have one connection per database. > See also http://www.h2database.com/html/features.html#database_url and > http://www.h2database.com/html/features.html#memory_only_databases > > If you want to share the same database, you need to give it a name > as in: > > jdbc:h2:mem:test1;MULTI_THREADED=1 > > Regards, > Thomas > > > -- Ye Huang, Department of Informatics University of Fribourg / Pérolles 2 - Bld de Pérolles 90 1700 Fribourg, Switzerland e-mail: [email protected], [email protected] http://diuf.unifr.ch/people/huangy/ Office: +41 26 429 65 95 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. 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 -~----------~----~----~----~------~----~------~--~---
