Hi,
I've checked some of the threads regarding the AUTO_SERVER=TRUE
setting, but I still can't use it.
What I've done?
My JBoss AS 5.1 is configured to use H2 as persistence layer
(DefaultDS).
Here are the most important settings:
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:h2:file:${jboss.server.data.dir}/databases/jms/
JMS;AUTO_SERVER=TRUE;MVCC=TRUE</connection-url>
<driver-class>org.h2.jdbcx.JdbcDataSource</driver-class>
This works very good and fast (w/o the MVCC=TRUE did not work)
Unfortunately every time JBoss is started the H2 Server listens on a
different port (this info is in the JMS.lock.db) but the remote
application doen't know it.
First question: How can I configure a default port for it?
Second question: How can I connect to this server?
I've tried to connect using Java appl. with following settings
DB_DRIVER = "org.h2.Driver";
DB_URL = "jdbc:h2:tcp://localhost:51466/JMS";
I've tried instead "org.h2.Driver" also "org.h2.jdbcx.JdbcDataSource"
I've tried instead "localhost" also the hostname /IP address.
The error message is always the same:
Falscher Benutzer Name oder Passwort Wrong user name or password
[28000-160]
I've also tried to recreate the JMS database with and w/o user/
password and I've used the same user/password in both applications.
Tia
Br
Josef
--
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.
