Found a solution, when starting the Console, if I edit h2.bat to include -Dcom.sun.management.jmxremote
Then it works Strange thing though is that you don't have specify these options to jetty, but connecting to local pid still works "out of the box". I tried looking at the source code for jetty, but could not find out how they do this, but might be something like in this link: https://forums.oracle.com/forums/thread.jspa?threadID=1174370 Tor On 8 apr, 02:10, Tor Pedersen <[email protected]> wrote: > I've been looking into H2 (version 1.3.164) and testing out JMX, and.. > well... I can't seem to get this working > > I've loaded H2 using the h2.bat in the /bin directory of the > installation on windows, with JRE 1.6. This loads the Console in my > browser, I have then connected to a database with url: > jdbc:h2:c:\temp\h2test\hibernate;JMX=TRUE;DB_CLOSE_DELAY=600 (last > one to keep the database, and thus also the jmx stats, open while > poking around) > It loads and I can do queries etc... > > I then load Jconsole, ask to connect to the local process > (org.h2.utils.Console) by pid, and I then get a connection refused > message... and despite several retries, no dice... > > Is there a (remote) connection url for the jmx service I need to use > instead? > > When listing the Information_Schema.Settings the JMX setting is not > listed at all, while the DB_CLOSE_DELAY shows up with value 600, along > with all the other options (with default settings) > > I've googled -- 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.
