Hi,
The connection pool of the Glassfish domain use the mixed mode with
this url : jdbc:h2:./db/slenticketdb;auto_server=true
This means the server listen on a tcp port choosen by itself, right ?
The tcp port is stored into a .lock.db file like :
#FileLock
#Mon Dec 01 18:42:53 CET 2008
id=11df3a544e507109f9dbe0d9fbc5f3856e04e20ed14
method=file
server=10.37.129.2\:49578
When a client like SQuirrel SQL must be connected to the database
server,
it should use the remote tcp url like : jdbc:h2:tcp://
10.37.129.2:49578/slenticketdb
But the following exception occurs :
org.h2.jdbc.JdbcSQLException: Wrong user name or password [8004-100]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.message.Message.getSQLException(Message.java:149)
at org.h2.server.TcpServer.checkKeyAndGetDatabaseName(TcpServer.java:
479)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:94)
at java.lang.Thread.run(Thread.java:613)
at org.h2.engine.SessionRemote.done(SessionRemote.java:493)
at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:111)
at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:316)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer
(SessionRemote.java:227)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:221)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:103)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:87)
at org.h2.Driver.connect(Driver.java:57)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection
(SQLDriverManager.java:133)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute
(OpenConnectionCommand.java:97)
at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand
$SheetHandler.run(ConnectToAliasCommand.java:279)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run
(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:613)
I'm sure about the username and the password :)
Do you see what I am trying to do ?
Thanks,
Steve
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
