Re: question about Grinder test data to database

On 10/07/14 12:50, Gang Yan wrote:
>
> Hi All:
>
>  
>
> I want to send Grinder test data  to database. I execute follow this link:
>
>  
>
> http://grinder.sourceforge.net/g3/logging.html
>
>  
>
> I have question:
>
>  
>
> 1: modify logback-worker.xml,Add follow content:
>
>  
>
> <logger name="data" additivity="false">
>
>      <appender-ref ref="data-file" />
>
>      <appender-ref ref="data-db" />
>
>    </logger>
>
>  
>
>    Previous content need to keep or delete?
>
>  
>
>     <logger name="worker" additivity="false">
>
>       <appender-ref ref="log-file" />
>
>     </logger>
>
>  
>
>     <logger name="data" additivity="false">
>
>       <appender-ref ref="data-file" />
>
> </logger>
>
>  
>

Change the "data" logger so it has the additional appender line. Don't
delete the "worker" logger, or you'll disable the normal logging.


>  
>
> 2: Create suitable user in database? Execute follow SQL?
>

Yes, that looks right to me. Make sure you're using the DDL script that
corresponds to the version of logback. For The Grinder 3.11, its logback
1.0.0 =>
https://github.com/qos-ch/logback/blob/v_1.0.0/logback-classic/src/main/java/ch/qos/logback/classic/db/dialect/oracle.sql

For more information, refer to
http://logback.qos.ch/manual/appenders.html#DBAppender

>  
>
> -- This SQL script creates the required tables by
> ch.qos.logback.classic.db.DBAppender
>
> -- It is intended for Oracle databases.
>
> -- The following lines are useful in cleaning any previous tables
>
> --drop TRIGGER logging_event_id_seq_trig;
>
> --drop SEQUENCE logging_event_id_seq;
>
> --drop table logging_event_property;
>
> --drop table logging_event_exception;
>
> --drop table logging_event;
>
>  
>
>  
>
> CREATE SEQUENCE logging_event_id_seq MINVALUE 1 START WITH 1;
>
>  
>
> CREATE TABLE logging_event
>
>   (
>
>     timestmp         NUMBER(20) NOT NULL,
>
>    formatted_message  VARCHAR2(4000) NOT NULL,
>
>     logger_name       VARCHAR(254) NOT NULL,
>
>     level_string      VARCHAR(254) NOT NULL,
>
>     thread_name       VARCHAR(254),
>
>     reference_flag    SMALLINT,
>
>     caller_filename   VARCHAR(254) NOT NULL,
>
>     caller_class      VARCHAR(254) NOT NULL,
>
>     caller_method     VARCHAR(254) NOT NULL,
>
>     caller_line       CHAR(4) NOT NULL,
>
>     event_id          NUMBER(10) PRIMARY KEY
>
>   );
>
>  
>
>  
>
> CREATE TRIGGER logging_event_id_seq_trig
>
>   BEFORE INSERT ON logging_event
>
>   FOR EACH ROW 
>
>   BEGIN 
>
>     SELECT logging_event_id_seq.NEXTVAL
>
>     INTO   :NEW.event_id
>
>     FROM   DUAL; 
>
>   END logging_event_id_seq_trig;
>
>  
>
>  
>
> CREATE TABLE logging_event_property
>
>   (
>
>     event_id        NUMBER(10) NOT NULL,
>
>     mapped_key        VARCHAR2(254) NOT NULL,
>
>     mapped_value      VARCHAR2(1024),
>
>     PRIMARY KEY(event_id, mapped_key),
>
>     FOREIGN KEY (event_id) REFERENCES logging_event(event_id)
>
>   );
>
>  
>
> CREATE TABLE logging_event_exception
>
>   (
>
>     event_id         NUMBER(10) NOT NULL,
>
>     i                SMALLINT NOT NULL,
>
>     trace_line       VARCHAR2(254) NOT NULL,
>
>     PRIMARY KEY(event_id, i),
>
>     FOREIGN KEY (event_id) REFERENCES logging_event(event_id)
>
>   );
>
>  
>
>  
>
>  
>
>  
>

------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft

_______________________________________________
grinder-use mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/grinder-use