Re-Hi, I'm using the wrong tcp port on the remote URL !!!
Sorry. Thanks, Steve On Dec 1, 8:59 pm, golgoth14 <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
