# Plugin JDBC **URL:** \ **Category:** Logstash\ **Created:** [November 29, 2016, 3:45pm UTC](https://discuss.elastic.co/t/plugin-jdbc/67513 "2016-11-29T15:45:07Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Diego\_Gomez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_gomez/32/12893_2.png) [@Diego\_Gomez](https://discuss.elastic.co/u/Diego_Gomez)\ **Post date:** [November 29, 2016, 3:45pm UTC](https://discuss.elastic.co/t/plugin-jdbc/67513/1 "2016-11-29T15:45:07Z")
Hello, to a query because I can not make JDBC work, in the data where this "?" I do not know what to put so that logstash I take the data that are recorded in the database every 10 seconds, could help me to see the subject. Thank you ``` input { jdbc { jdbc_driver_library => "mysql-connector-java-5.1.36-bin.jar" jdbc_driver_class => "com.mysql.jdbc.Driver" jdbc_connection_string => "jdbc:mysql://localhost:3306/mydb" jdbc_user => "mysql" parameters => { "???????????????" } schedule => "???????????" statement => "??????????????" } } ``` ---
**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:** [November 29, 2016, 9:19pm UTC](https://discuss.elastic.co/t/plugin-jdbc/67513/2 "2016-11-29T21:19:22Z")
- `parameters` is optional. - I'm not sure the `schedule` syntax supports finer resolution than one minute. - `statement` should contain the query that fetches the data. Without further details it's obviously hard to help. Since you probably don't want to fetch all the data every time you should look into the `sql_last_value` parameter that's described in a couple of places in the documentation. ---
**Author:** ![Diego\_Gomez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_gomez/32/12893_2.png) [@Diego\_Gomez](https://discuss.elastic.co/u/Diego_Gomez)\ **Post date:** [November 30, 2016, 2:22pm UTC](https://discuss.elastic.co/t/plugin-jdbc/67513/3 "2016-11-30T14:22:29Z")
Hi this is the logstash code and below this is the error that gives me ``` input { jdbc { jdbc_driver_library => "/home/rack/mysql-connector-java-5.1.40/mysql-connector-java-5.1.40-bin.jar" jdbc_driver_class => "com.mysql.jdbc.Driver" jdbc_connection_string => "jdbc:mysql://10.10.0.132:3306/testdb" jdbc_user => "user" jdbc_password => "rack" schedule => "*/1 * * * *" statement => "select id, DATE_FORMAT(timestamp, '%Y-%m-%d %T') AS id, id_wasp, id_secret, frame_type, frame_number, sensor, value, timestamp, raw, parser_type, trans_id from `testdb`. `sensorParser` where timestamp >= :sql_last_value" } } filter { date { locale => "en" timezone => "America/Buenos_Aires" match => ["timestamp", "YYYY-MM-dd HH:mm:ss"] target => "@timestamp" } } output { elasticsearch { hosts => ["10.10.0.132:9200"] index => "audit-%{+YYYY.MM.dd}" document_id => "%{id}" } stdout { codec => rubydebug } } ``` [2016-11-30T11:20:00,235][WARN][logstash.inputs.jdbc] Exception when executing JDBC query {:exception=\>#\} [2016-11-30T11:21:00,293][ERROR][logstash.inputs.jdbc] Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Unknown column 'trans\_id' in 'field list': select id, DATE\_FORMAT(timestamp, '%Y-%m-%d %T') AS id, id\_wasp, id\_secret, frame\_type, frame\_number, sensor, value, timestamp, raw, parser\_type, trans\_id from `testdb`.`sensorParser`where timestamp \>= '1970-01-01 00:00:00' [2016-11-30T11:21:00,297][WARN][logstash.inputs.jdbc] Exception when executing JDBC query {:exception=\>#\} ---
**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:** [November 30, 2016, 2:32pm UTC](https://discuss.elastic.co/t/plugin-jdbc/67513/4 "2016-11-30T14:32:10Z")
> Unknown column 'trans\_id' in 'field list' Is this not clear? ---
**Author:** ![Diego\_Gomez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_gomez/32/12893_2.png) [@Diego\_Gomez](https://discuss.elastic.co/u/Diego_Gomez)\ **Post date:** [November 30, 2016, 3:17pm UTC](https://discuss.elastic.co/t/plugin-jdbc/67513/5 "2016-11-30T15:17:16Z")
Hello, I already changed it and it walks, but I throw this data the first time and then I do not throw more data, just this ``` "@timestamp" => 2016-11-30T14:31:25.789Z, "@version" => "1", "sensor" => "TCA", "id" => "2016-11-29 17:33:23", "value" => "22.26", "timestamp" => 2016-11-29T20:33:23.000Z } { "id_secret" => "408425467", "raw" => "noraw", "parser_type" => 1, "frame_type" => 128, "frame_number" => 204, "id_wasp" => "Waspmote_PRO", "tags" => [ [0] "_dateparsefailure" ], "@timestamp" => 2016-11-30T14:31:25.789Z, "@version" => "1", "sensor" => "TCA", "id" => "2016-11-29 17:33:29", "value" => "22.26", "timestamp" => 2016-11-29T20:33:29.000Z } ``` [2016-11-30T11:32:00,309][INFO][logstash.inputs.jdbc] (0.067000s) select id, DATE\_FORMAT(timestamp, '%Y-%m-%d %T') AS id, id\_wasp, id\_secret, frame\_type, frame\_number, sensor, value, timestamp, raw, parser\_type, timestamp from `testdb`.`sensorParser`where timestamp \>= '2016-11-30 14:31:26' ---
**Author:** ![Diego\_Gomez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_gomez/32/12893_2.png) [@Diego\_Gomez](https://discuss.elastic.co/u/Diego_Gomez)\ **Post date:** [December 6, 2016, 5:58pm UTC](https://discuss.elastic.co/t/plugin-jdbc/67513/6 "2016-12-06T17:58:03Z")
Please if someone knows what error you could have in the note that you leave later ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 3, 2017, 5:58pm UTC](https://discuss.elastic.co/t/plugin-jdbc/67513/7 "2017-01-03T17:58:36Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.