Hi,
I'm using H2 database on Glassfish.
I've configured a connection pool with the following properties :
<jdbc-connection-pool is-connection-validation-required="true"
datasource-classname="org.h2.jdbcx.JdbcDataSource" connection-
validation-method="meta-data" steady-pool-size="5" res-
type="javax.sql.ConnectionPoolDataSource" description="slenTicket-1.2-
SNAPSHOT JDBC Connection Pool" max-pool-size="50" name="slenTicket-1.2-
SNAPSHOTPool">
<property value="jdbc:h2:./db/slenticketdb;auto_server=true"
name="URL" />
<property value="admin" name="user" />
<property value="password" name="password" />
</jdbc-connection-pool>
When the domain starts, I can't connect to the database with an
external process like SQuirrel SQL Client ?
How to allow other process to connect to a server started database ?
How to set the tcp port ?
Thank you,
Steve
On Oct 8, 8:46 pm, "Thomas Mueller" <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> Of course you could just use the server mode.
>
> > I believe there is a new connection mode that will create and manage
> > the server for you. But I'm not sure how to do that. So I second your
> > question: How do we allow multiple connections to embedded database?
>
> Yes there is a new (experimental) mode that automatically starts a
> server when opening the database. To use it, append ;AUTO_SERVER=TRUE
> to the database URL. You need H2 version 1.1.100 for this feature.
> Example:
>
> jdbc:h2:/data/dbs/test;AUTO_SERVER=TRUE
>
> The first connection will open the database in embedded mode and will
> start a server. Later connections will automatically use the server
> mode. If the first connection is closed the later connections should
> re-connect automatically.
>
> You could try out if that works for you. As I said it's a new feature,
> please tell me if there are some problems with that.
>
> 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
-~----------~----~----~----~------~----~------~--~---
