On Thursday 03 June 2004 16:30, Priya Soparkar wrote:
> The Avalon Logkit documentation states that the log -target for logging
> messages can be file or database. I am still unable to find the target
> settings for database logging in logkit.xml.
As we have pointed out earlier, logkit.xml is not part of LogKit. Someone else
has made the mapping, and I can't comment on how it is supposed to work.
Digging around in LogKit I found that you need the SQL tables to exist
already, which can be set up with SQL code below.
To do it the 'native way' through code, you need to establish the DataSource,
create column info instances, and the name of the table. The code could look
like;
DefaultDataSource dataSource = new DefaultDataSource( m_connectString,
m_userName, m_userPassword );
ColumnInfo[] columns =
{
new ColumnInfo( "TIME", ColumnType.TIME, null ),
new ColumnInfo( "PRIORITY", ColumnType.PRIORITY, null ),
new ColumnInfo( "CATEGORY", ColumnType.CATEGORY, null ),
new ColumnInfo( "HOSTNAME", ColumnType.STATIC, "host.mydomain.com" ),
new ColumnInfo( "MESSAGE", ColumnType.MESSAGE, null )
};
DefaultJDBCTarget target = new DefaultJDBCTarget( dataSource, "log_entrys",
columns );
I hope this information can provide you some steps forward, but I suspect one
need to look into the JMeter's LogKit adaption to config fiels, whatever way
it is done.
Cheers
Niclas
The tables that need to be created for this....
CREATE TABLE LOG_ENTRYS
(
TIME DATETIME NOT NULL,
PRIORITY VARCHAR(10) NOT NULL,
CATEGORY VARCHAR(64) NOT NULL,
MESSAGE VARCHAR(255) NOT NULL,
THROWABLE VARCHAR(255),
HOSTNAME VARCHAR(255)
);
DROP TABLE LOG_ENTRYS2;
DROP TABLE LOG_ENTRYS2_PRIORITY_SET;
DROP TABLE LOG_ENTRYS2_CATEGORY_SET;
CREATE TABLE LOG_ENTRYS2_PRIORITY_SET
(
ID INT PRIMARY KEY,
NAME VARCHAR(255) NOT NULL
);
CREATE TABLE LOG_ENTRYS2_CATEGORY_SET
(
ID INT PRIMARY KEY,
NAME VARCHAR(255) NOT NULL
);
CREATE TABLE LOG_ENTRYS2
(
TIME DATETIME NOT NULL,
PRIORITY INT NOT NULL REFERENCES LOG_ENTRYS2_PRIORITY_SET(ID),
CATEGORY INT NOT NULL REFERENCES LOG_ENTRYS2_CATEGORY_SET(ID),
MESSAGE VARCHAR(255) NOT NULL,
THROWABLE VARCHAR(255),
HOSTNAME VARCHAR(255)
);
--
+------//-------------------+
/ http://www.bali.ac /
/ http://niclas.hedhman.org /
+------//-------------------+
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
