# Logstash || Insert Apache log file to Oracle Database

**URL:** <https://discuss.elastic.co/t/logstash-insert-apache-log-file-to-oracle-database/142560>\
**Category:** Logstash\
**Created:** [August 1, 2018, 12:03pm UTC](https://discuss.elastic.co/t/logstash-insert-apache-log-file-to-oracle-database/142560 "2018-08-01T12:03:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ssneha02](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@ssneha02](https://discuss.elastic.co/u/ssneha02)\
**Post date:** [August 1, 2018, 12:03pm UTC](https://discuss.elastic.co/t/logstash-insert-apache-log-file-to-oracle-database/142560/1 "2018-08-01T12:03:20Z")

</div>

I am trying to insert my daily Apache logs to Oracle database. I did the following configuration file coding, however I am getting error - Couldn't find any output plugin. I have done testing on 6.3.2 & 5.6.0 versions of logstash. In short my input will be a text file and output will be my database(in this case Oracle). Can someone please help with the code. I did research but I couldn't find any correct answer.

input  
{  
file  
{  
path =\> "C:\Users\ssn\logstash\Input\access.log"  
start\_position =\> "beginning"  
}  
}  
output  
{

jdbc{  
jdbc\_connection\_string =\> "jdbc:oracle:thin:xyz/Helloxyz1@xyz1000:PORT:1521"  
statement =\> [ "INSERT INTO LOGS (IP\_ADDRESS, USER\_IDENTIFIER, USERID, REQUEST\_TIME, CLIENT\_REQUEST, RESPONSE\_CODE, SIZEOFOBJECT, COOKIES)  
VALUES(?, ? , ?, ?, ? , ?, ?, ?)", "IP\_ADDRESS", "USER\_IDENTIFIER", "USERID", "REQUEST\_TIME", "CLIENT\_REQUEST", "RESPONSE\_CODE", "SIZEOFOBJECT", "COOKIES"]  
}

}

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [August 1, 2018, 12:36pm UTC](https://discuss.elastic.co/t/logstash-insert-apache-log-file-to-oracle-database/142560/2 "2018-08-01T12:36:36Z")

</div>

Logstash doesn't ship with a JDBC _output_ plugin. See [Is logstash-output-jdbc supported by ELASTIC?](https://discuss.elastic.co/t/is-logstash-output-jdbc-supported-by-elastic/71421).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 29, 2018, 12:39pm UTC](https://discuss.elastic.co/t/logstash-insert-apache-log-file-to-oracle-database/142560/3 "2018-08-29T12:39:12Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.