Hi, There is an in-memory "management_db_<port>" for each TCP server. A TCP server can server multiple databases. To connect to it, you need to know the "managementPassword", which is the password you need to set using the -tcpPassword setting. The user name is an empty string. See also TcpServer.initManagementDb and TcpServer.shutdown. You can get the sessions, database URLs, user names, and time of connection.
Regards, Thomas On Thu, Feb 14, 2013 at 4:32 PM, Josef Hopfgartner <[email protected]>wrote: > I would need this feature for logging. > It would be interesting to see as many or even more information as in > V$SESSION in Oracle. > > Actually, I've created a Libreoffice Base document which is configured to > use H2 tcp server with parameter "INIT=Call do_sync()" > This H2 has configured linked tables to query different databases. > Those queries are quite costly and I don't need the results to be up to > date. > > So, the H2 alias "do_sync()" logs and checks, how up to date the query > results are. > If necessery, it does some queries again. > > Best regards, > Josef > > PS: Here is the alias definition: > void query(Connection conn) throws SQLException { > java.lang.String sql = ""; > sql = "select count(*) from PUBLIC.LOGGER where ZEIT > > CURRENT_TIMESTAMP - 0.5 and SYNCED = true"; > java.sql.ResultSet tmpRes = conn.createStatement().executeQuery(sql); > while (tmpRes.next()) { > Long i = tmpRes.getLong(1); > String s = "false"; > if (i == 0) { > sql = "create temporary table t1 as select knd_nr, knd_kurz from > konz9999.knd_so"; conn.createStatement().execute(sql); > sql = "merge into t1 key (knd_nr) select knd_nr, knd_kurz from > mdg.kunden where length(knd_kurz) > 1"; conn.createStatement().execute(sql); > sql = "merge into kontrakte.knd_so key (knd_nr) select knd_nr, > knd_kurz from t1"; conn.createStatement().execute(sql); > //sql = "delete from kontrakte.knd_so where knd_nr not in (select > knd_nr from t1)"; conn.createStatement().execute(sql); > > sql = "create temporary table t2 as select * from konz9999.art"; > conn.createStatement().execute(sql); > sql = "merge into kontrakte.art key (art_nr) SELECT * from t2"; > conn.createStatement().execute(sql); > //sql = "delete from kontrakte.art where art_nr not in (SELECT > art_nr from t2)"; conn.createStatement().execute(sql); > > sql = "create temporary table t3 as select * from > konz9999.mit_so"; conn.createStatement().execute(sql); > sql = "merge into kontrakte.mit_so key (mit_nr) SELECT * from t3"; > conn.createStatement().execute(sql); > //sql = "delete from kontrakte.mit_so where mit_nr not in (SELECT > mit_nr from t3)"; conn.createStatement().execute(sql); > > sql = "create temporary table t4 as SELECT ANR, MATCH, ANRBEZ1, > ANRBEZ2, cast(NETTO as decimal(65535,255)) as NETTO from m2.tklager"; > conn.createStatement().execute(sql); > sql = "merge into kontrakte.tklager key (anr) SELECT * from t4"; > conn.createStatement().execute(sql); > sql = "delete from kontrakte.tklager where anr not in (SELECT anr > from t4)"; conn.createStatement().execute(sql); > > sql = "drop table if exists t1,t2,t3,t4"; > conn.createStatement().execute(sql); > s = "true"; > } > sql = "INSERT INTO PUBLIC.LOGGER VALUES (current_timestamp, > session_id(), " + s + " )"; conn.createStatement().execute(sql); > break; > } > } > > > > > Am Dienstag, 12. Februar 2013 15:46:20 UTC+1 schrieb Noel Grandin: >> >> Not possible at the moment, I'm afraid. >> >> Doesn't sound that hard to add. >> Start with org.h2.server.TcpServerThread, propogate the information down >> to org.h2.engine.Session, and then expose it from there to >> org.h2.table.MetaTable. >> >> What do you need it for? >> >> On 2013-02-12 15:56, Josef Hopfgartner wrote: >> > Hello, >> > >> > does anybody know if it is already possible to display the active >> > session's client IP-address in an H2 TCP server? >> > >> > Regards, >> > Josef >> > -- >> > You received this message because you are subscribed to the Google >> > Groups "H2 Database" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an email to h2-database...@**googlegroups.com. >> > To post to this group, send email to [email protected]. >> > Visit this group at >> > http://groups.google.com/**group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en>. >> >> > For more options, visit >> > https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>. >> >> > >> > >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
