Hi, > I am running with 1.2.37 and the SESSIONS table is in the INFORMATION_SCHEME > of the connected database. Am I looking at incorrect data?
There is *also* a table called INFORMATION_SCHEMA.SESSIONS, but that's not the table I'm talking about. I'm talking about PUBLIC.SESSION. As you already know, there is an in-memory database "management_db_<port>" for each TCP server. This database has a PUBLIC.SESSIONS table. You need to open that database within the server, not the client. Maybe add ;IFEXISTS=TRUE to the database URL to ensure you don't create a new database without knowing. For me, the database URL is: jdbc:h2:tcp://localhost/mem:management_db_9092;ifexists=true (user sa, and password empty unless you set the password when starting the TCP server). 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.
