Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Topic-icon Question number of entry in Session log

More
05 Jan 2018 11:23 #1 by Prashant.Sangle
Prashant.Sangle created the topic: number of entry in Session log
Hi,

Is there any way to know, how many number of session entry available in session log sessionLogs.h2.db file?

Regards,
Prashant Sangle
More
05 Jan 2018 14:31 #2 by Thomas BLETON
Thomas BLETON replied the topic: number of entry in Session log
Yes : this file is the Runtime's default log database.
You can connect to this database using any Jdbc SQL editor, you can even reverse it into a Metadata from the Designer :)

Simply use the Jdbc URL and User that are defined in the Runtime's engineParameters.xml file.
Default URL: jdbc:h2:tcp://localhost:42100/sessions/internalDb/sessionLogs
Default User: sa
Default Password: (none)

Then simply count rows in the LOGS.STB_LOG_SESSION_SESS table.