Hi, > I'm using H2 database on Glassfish. > I've configured a connection pool with the following properties... > <property value="jdbc:h2:./db/slenticketdb;auto_server=true" > When the domain starts, I can't connect to the database with an > external process like SQuirrel SQL Client ?
If you get an exception, could you post it please? It should work when using the exact same URL as above jdbc:h2:./db/slenticketdb;auto_server=true however it's sometimes better to use an absolute path, or a path relative to the user home directory (jdbc:h2:~/...). Otherwise you could end up with two databases if the current working directory is different in the two applications. > How to allow other process to connect to a server started database ? It's allowed automatically when using ;auto_server=true (even remote access is allowed - but there is additional security using a randomly generated key that is stored in the .lock.db file in addition to the user password protection). > How to set the tcp port ? You don't need to set it, the port is picked automatically and saved in the .lock.db file. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
