Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question number of entry in Session log

More
05 Jan 2018 11:23 #1 by Prashant.Sangle
number of entry in Session log was created by Prashant.Sangle
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
Replied by Thomas BLETON on 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.