# RC5 Gatling.conf
**URL:** https://community.gatling.io/t/rc5-gatling-conf/1451
**Category:** Gatling (Open-Source)
**Created:** [September 22, 2014, 11:49pm UTC](https://community.gatling.io/t/rc5-gatling-conf/1451 "2014-09-22T23:49:00Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Santhosh](https://community.gatling.io/u/Santhosh)
#### Post date: [September 22, 2014, 11:49pm UTC](https://community.gatling.io/t/rc5-gatling-conf/1451/1 "2014-09-22T23:49:00Z")
Hi,
Below implementation is for cross result analysis?
jdbc {
db {
#url = “jdbc:mysql://localhost:3306/temp” # The JDBC URL used by the JDBC DataWriter
#username = “root” # The database user used by the JDBC DataWriter
#password = “123123q” # The password for the specified user
}
#bufferSize = 20 # The size for each batch of SQL inserts to send to the database
create {
#createRunRecordTable = “CREATE TABLE IF NOT EXISTS `RunRecords` ( `id` INT NOT NULL AUTO\_INCREMENT , `runDate` DATETIME NULL , `simulationId` VARCHAR(45) NULL , `runDescription` VARCHAR(45) NULL , PRIMARY KEY (`id`) )”
#createRequestRecordTable = “CREATE TABLE IF NOT EXISTS `RequestRecords` (`id` int(11) NOT NULL AUTO\_INCREMENT, `runId` int DEFAULT NULL, `scenario` varchar(45) DEFAULT NULL, `userId` VARCHAR(20) NULL, `name` varchar(50) DEFAULT NULL, `requestStartDate` bigint DEFAULT NULL, `requestEndDate` bigint DEFAULT NULL, `responseStartDate` bigint DEFAULT NULL, `responseEndDate` bigint DEFAULT NULL, `status` varchar(2) DEFAULT NULL, `message` varchar(4500) DEFAULT NULL, `responseTime` bigint DEFAULT NULL, PRIMARY KEY (`id`) )”
#createScenarioRecordTable = “CREATE TABLE IF NOT EXISTS `ScenarioRecords` (`id` int(11) NOT NULL AUTO\_INCREMENT, `runId` int DEFAULT NULL, `scenarioName` varchar(45) DEFAULT NULL, `userId` VARCHAR(20) NULL, `event` varchar(50) DEFAULT NULL, `startDate` bigint DEFAULT NULL, `endDate` bigint DEFAULT NULL, PRIMARY KEY (`id`) )”
#createGroupRecordTable = “CREATE TABLE IF NOT EXISTS `GroupRecords` (`id` int(11) NOT NULL AUTO\_INCREMENT, `runId` int DEFAULT NULL, `scenarioName` varchar(45) DEFAULT NULL, `userId` VARCHAR(20) NULL, `entryDate` bigint DEFAULT NULL, `exitDate` bigint DEFAULT NULL, `status` varchar(2) DEFAULT NULL, PRIMARY KEY (`id`) )”
}
insert {
#insertRunRecord = “INSERT INTO RunRecords (runDate, simulationId, runDescription) VALUES (?,?,?)”
#insertRequestRecord = “INSERT INTO RequestRecords (runId, scenario, userId, name, requestStartDate, requestEndDate, responseStartDate, responseEndDate, status, message, responseTime) VALUES (?,?,?,?,?,?,?,?,?,?,?)”
#insertScenarioRecord = “INSERT INTO ScenarioRecords (runId, scenarioName, userId, event, startDate, endDate) VALUES (?,?,?,?,?,?)”
#insertGroupRecord = “INSERT INTO GroupRecords (runId, scenarioName, userId, entryDate, exitDate, status) VALUES (?,?,?,?,?,?)”
}
}
---
### Author:  [@Excilys](https://community.gatling.io/u/Excilys)
#### Post date: [September 23, 2014, 5:33am UTC](https://community.gatling.io/t/rc5-gatling-conf/1451/2 "2014-09-23T05:33:22Z")
It’s for people wanting to store Gatling results in a database and then build their own reports.
It was an external contribution.
---
### Author:  [@Santhosh](https://community.gatling.io/u/Santhosh)
#### Post date: [September 23, 2014, 6:52pm UTC](https://community.gatling.io/t/rc5-gatling-conf/1451/3 "2014-09-23T18:52:29Z")
Oh thats great. Thank you.