# \#jdbc **URL:** https://discuss.elastic.co/tag/jdbc/102.md [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) --- ## [Jdbc\_static dealing with parameters from not existing fields](https://discuss.elastic.co/t/jdbc-static-dealing-with-parameters-from-not-existing-fields/377628)
**Author:** [@Francesco\_Esposito](https://discuss.elastic.co/u/Francesco_Esposito)\ **Replies:** 3\ **Last updated:** [May 12, 2025, 10:09pm UTC](https://discuss.elastic.co/t/jdbc-static-dealing-with-parameters-from-not-existing-fields/377628 "2025-05-12T22:09:37Z")
I'm trying to use the jdbc\_static filter in my logstash pipeline, but I am getting the following error: \[2025-04-29T10:36:48,983\]\[WARN \]\[logstash.filters.jdbc.lookup\]\[test\]\[udplogstash\] Parameter field not found in even… --- ## [SQLRecoverableException: ORA-17008: Closed connection](https://discuss.elastic.co/t/sqlrecoverableexception-ora-17008-closed-connection/377428)
**Author:** [@Witcherek](https://discuss.elastic.co/u/Witcherek)\ **Replies:** 3\ **Last updated:** [April 29, 2025, 2:35pm UTC](https://discuss.elastic.co/t/sqlrecoverableexception-ora-17008-closed-connection/377428 "2025-04-29T14:35:08Z")
Hello, Since two weeks we have problem that from time to time our logstash pipeline which is connecting to oracle databse with jdbc\_streaming filter is throwing, exception=\>#\ **Author:** [@Francesco\_Esposito](https://discuss.elastic.co/u/Francesco_Esposito)\ **Replies:** 2\ **Last updated:** [April 17, 2025, 2:03pm UTC](https://discuss.elastic.co/t/jdbc-this-driver-is-not-configured-for-integrated-authentication/377225 "2025-04-17T14:03:21Z") Trying to connect to my Sql Server Instance thru Windows Authentication using the following configuration: input { udp { port =\> 517 } } filter { mutate { gsub =\> \[ "message", "\\u0000", "\[0x00\]" \] } mutate { gsub … --- ## [Logstash JDBC Input PREPARE on every run](https://discuss.elastic.co/t/logstash-jdbc-input-prepare-on-every-run/375312)
**Author:** [@dwjvaughan](https://discuss.elastic.co/u/dwjvaughan)\ **Replies:** 2\ **Last updated:** [March 3, 2025, 3:56pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-prepare-on-every-run/375312 "2025-03-03T15:56:41Z")
Hi, Since upgrading from Logstash 8.7.1 to 8.17.2 I've noticed that the PREPARE statement is run every time (followed by the EXECUTE), where as previously PREPARE would run once at start up, and EXECUTE would run every … --- ## [Slow SQL with timestamp on Oracle](https://discuss.elastic.co/t/slow-sql-with-timestamp-on-oracle/369819)
**Author:** [@Wolfram\_Haussig](https://discuss.elastic.co/u/Wolfram_Haussig)\ **Replies:** 2\ **Last updated:** [October 31, 2024, 8:44am UTC](https://discuss.elastic.co/t/slow-sql-with-timestamp-on-oracle/369819 "2024-10-31T08:44:10Z")
Hello all, We have a Logstash Pipeline with jdbc input that ran really slow. I investigated and found something where I am not sure if this could be improved on Logstash side or if this is something we need to handle so… --- ## [JDBC input has irregular schedule intervals](https://discuss.elastic.co/t/jdbc-input-has-irregular-schedule-intervals/364252)
**Author:** [@Mahdi\_Moazami](https://discuss.elastic.co/u/Mahdi_Moazami)\ **Replies:** 6\ **Last updated:** [August 9, 2024, 5:21pm UTC](https://discuss.elastic.co/t/jdbc-input-has-irregular-schedule-intervals/364252 "2024-08-09T17:21:47Z")
Hi Elastic team, We have about 300 pipelines setup which have JDBC inputs that fetches data from different databases landed on a central SQL server. All of the JDBC inputs have a schedule set on \*/5 \* \* \* \* (every 5 mi… --- ## [Java Resource Attributes in OTel Java SDK with Elastic Observability](https://discuss.elastic.co/t/java-resource-attributes-in-otel-java-sdk-with-elastic-observability/363737)
**Author:** [@Bahubali\_Shetti](https://discuss.elastic.co/u/Bahubali_Shetti)\ **Replies:** 0\ **Last updated:** [July 24, 2024, 6:00pm UTC](https://discuss.elastic.co/t/java-resource-attributes-in-otel-java-sdk-with-elastic-observability/363737 "2024-07-24T18:00:41Z")
Learn how to use resource attributes in OTel S=Java SDK. Automatic cloud resource attributes with OpenTelemetry Java — Elastic Observability Labs --- ## [Logstash JDBC input plugin skips few scheduled runs](https://discuss.elastic.co/t/logstash-jdbc-input-plugin-skips-few-scheduled-runs/363021)
**Author:** [@forabraham1](https://discuss.elastic.co/u/forabraham1)\ **Replies:** 6\ **Last updated:** [July 17, 2024, 7:24am UTC](https://discuss.elastic.co/t/logstash-jdbc-input-plugin-skips-few-scheduled-runs/363021 "2024-07-17T07:24:37Z")
Hi All, We're using JDBC input plugin to load data from Oracle 19c DB. Totally 55 separate config files ( each per client ) . Each file having 4 different sections for JDBC input, scheduled to run every 10 secs. Some t… --- ## [Dynamically set connection string on jdbc\_streaming filter](https://discuss.elastic.co/t/dynamically-set-connection-string-on-jdbc-streaming-filter/361675)
**Author:** [@DMcP89](https://discuss.elastic.co/u/DMcP89)\ **Replies:** 1\ **Last updated:** [June 18, 2024, 11:56pm UTC](https://discuss.elastic.co/t/dynamically-set-connection-string-on-jdbc-streaming-filter/361675 "2024-06-18T23:56:07Z")
Is it possible to dynamically set the connection string on a jdbc\_streaming filter? Something like this for example: mutate { add\_field =\> { "connection\_string" =\> "jdbc:sqlserver://test.mydb.co… --- ## [Issue with unintentionally becoming non\_running in Logstash management](https://discuss.elastic.co/t/issue-with-unintentionally-becoming-non-running-in-logstash-management/361298)
**Author:** [@shibadog](https://discuss.elastic.co/u/shibadog)\ **Replies:** 7\ **Last updated:** [June 18, 2024, 7:29am UTC](https://discuss.elastic.co/t/issue-with-unintentionally-becoming-non-running-in-logstash-management/361298 "2024-06-18T07:29:10Z")
Using Logstash management, I was adding pipeline settings from Kibana. Although it was working fine before, after adding a pipeline, the newly added pipeline unintentionally became non-running. The environment is as fol… --- ## [Logstash JDBC Input Issue - Single Quotes](https://discuss.elastic.co/t/logstash-jdbc-input-issue-single-quotes/360882)
**Author:** [@OscarFilho](https://discuss.elastic.co/u/OscarFilho)\ **Replies:** 2\ **Last updated:** [June 9, 2024, 6:09pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-issue-single-quotes/360882 "2024-06-09T18:09:43Z")
I'm using a JDBC input plugin (for sql server connection) in my logstash and having a issue on statement. The error displayed is: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Incorrect syntax near 'ATUALIZADO\\'… --- ## [I'm trying to use the jdbc\_static plugin to join two tables from MySql and index it but I'm receiving this error (warning: already initialized constant Manticore::Client::ByteArrayEntity)](https://discuss.elastic.co/t/im-trying-to-use-the-jdbc-static-plugin-to-join-two-tables-from-mysql-and-index-it-but-im-receiving-this-error-warning-already-initialized-constant-manticore-bytearrayentity/359532)
**Author:** [@Danyal\_Danish](https://discuss.elastic.co/u/Danyal_Danish)\ **Replies:** 0\ **Last updated:** [May 15, 2024, 10:42am UTC](https://discuss.elastic.co/t/im-trying-to-use-the-jdbc-static-plugin-to-join-two-tables-from-mysql-and-index-it-but-im-receiving-this-error-warning-already-initialized-constant-manticore-bytearrayentity/359532 "2024-05-15T10:42:41Z")
I'm trying to use the jdbc\_static plugin to join two tables from MySql and index it but I'm receiving this error (warning: already initialized constant Manticore::Client::ByteArrayEntity) This is my pipeline: input { … --- ## [JDBC password needs to be retrieved from CyberArk and cached locally](https://discuss.elastic.co/t/jdbc-password-needs-to-be-retrieved-from-cyberark-and-cached-locally/358193)
**Author:** [@forabraham1](https://discuss.elastic.co/u/forabraham1)\ **Replies:** 3\ **Last updated:** [April 29, 2024, 7:09am UTC](https://discuss.elastic.co/t/jdbc-password-needs-to-be-retrieved-from-cyberark-and-cached-locally/358193 "2024-04-29T07:09:24Z")
In our setup, there are ~ 30 JDBC configs \*.conf (one per client) within that it will have one input section with 4 different jdbc section (one per functionality). Every functionality JDBC sections are scheduled to run e… --- ## [Logstash Jdbc connection error](https://discuss.elastic.co/t/logstash-jdbc-connection-error/356358)
**Author:** [@viera120](https://discuss.elastic.co/u/viera120)\ **Replies:** 4\ **Last updated:** [March 30, 2024, 9:36am UTC](https://discuss.elastic.co/t/logstash-jdbc-connection-error/356358 "2024-03-30T09:36:52Z")
Hi, We are running a 3 node elastic cluster to index logs from a firewall. Filebeat and Redis Queue are used to forward the logs to Logstash for necessary parsing, after which it is indexed in to the Elastic cluster. D… --- ## [JDBC streaming filter with SQL IN () condition](https://discuss.elastic.co/t/jdbc-streaming-filter-with-sql-in-condition/354429)
**Author:** [@Joss](https://discuss.elastic.co/u/Joss)\ **Replies:** 1\ **Last updated:** [March 12, 2024, 11:19am UTC](https://discuss.elastic.co/t/jdbc-streaming-filter-with-sql-in-condition/354429 "2024-03-12T11:19:03Z")
Greetings community, I stuck with development of data processing pipeline where is one step is fetch data from DB by array of ids. Prerequisites: logstash 7.17 logstash-filter-jdbc\_streaming (OOTB) jdbc client for ma… --- ## [Ingest data from a relational database - STDOUT Duplicates](https://discuss.elastic.co/t/ingest-data-from-a-relational-database-stdout-duplicates/353984)
**Author:** [@MaikLinnemann](https://discuss.elastic.co/u/MaikLinnemann)\ **Replies:** 0\ **Last updated:** [February 23, 2024, 12:50pm UTC](https://discuss.elastic.co/t/ingest-data-from-a-relational-database-stdout-duplicates/353984 "2024-02-23T12:50:29Z")
Dear all, when i follow the article to ingest data from a relational database (MSSQL), which is that one: Klick and i stdout the results to console, i receive duplicates. Exactly i use: stdout { codec =\> json } for th… --- ## [ODBC Driver for elasticsearch](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783)
**Author:** [@muhammad\_qassem](https://discuss.elastic.co/u/muhammad_qassem)\ **Replies:** 8\ **Last updated:** [January 29, 2024, 8:11am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783 "2024-01-29T08:11:57Z")
Hi, I am trying to configure the elastic odbc driver for Elasticsearch to then get data to power bi but when i test the connection for that it gives me error i dont know this error is related to what certificate or autho… --- ## [Logstash JDBC Output to Postgres case-sensitive issue](https://discuss.elastic.co/t/logstash-jdbc-output-to-postgres-case-sensitive-issue/351881)
**Author:** [@h\_ng\_d\_ng](https://discuss.elastic.co/u/h_ng_d_ng)\ **Replies:** 9\ **Last updated:** [January 28, 2024, 9:53am UTC](https://discuss.elastic.co/t/logstash-jdbc-output-to-postgres-case-sensitive-issue/351881 "2024-01-28T09:53:03Z")
Hi, i got issue with logstash when trying to import data to postgres table. here are my output config: and it always show error that :\[ERROR\] 2024-01-26 20:22:38.348 \[\[main\]\>worker0\] jdbc - JDBC - Exception. Not retr… --- ## [JDBC streaming array as parameter](https://discuss.elastic.co/t/jdbc-streaming-array-as-parameter/348159)
**Author:** [@Rodrigo\_Martins](https://discuss.elastic.co/u/Rodrigo_Martins)\ **Replies:** 0\ **Last updated:** [November 28, 2023, 3:19pm UTC](https://discuss.elastic.co/t/jdbc-streaming-array-as-parameter/348159 "2023-11-28T15:19:33Z")
Hello everyone, We are trying to execute a jdbc\_streaming query that takes as parameter a array of values. Our statement looks like this: statement =\> "SELECT \`table\_name\`,\`column\_name\`,\`classification\` FROM \`tableEx\`… --- ## [Logstash fetching data from multiple MySQL databases](https://discuss.elastic.co/t/logstash-fetching-data-from-multiple-mysql-databases/345350)
**Author:** [@mfrob](https://discuss.elastic.co/u/mfrob)\ **Replies:** 0\ **Last updated:** [October 19, 2023, 3:48am UTC](https://discuss.elastic.co/t/logstash-fetching-data-from-multiple-mysql-databases/345350 "2023-10-19T03:48:20Z")
Hi there, I think this community is really great and helpful, especially for someone like me who is really new to the ELK stack, barely a week in. So Ive been tasked to use elasticsearch for a new company project. In or… --- ## [Can't connect to autonomoous oracledb cloud](https://discuss.elastic.co/t/cant-connect-to-autonomoous-oracledb-cloud/343081)
**Author:** [@A\_Mightiev](https://discuss.elastic.co/u/A_Mightiev)\ **Replies:** 1\ **Last updated:** [September 26, 2023, 2:54pm UTC](https://discuss.elastic.co/t/cant-connect-to-autonomoous-oracledb-cloud/343081 "2023-09-26T14:54:13Z")
Hi I can't connect to an oracle db in oracle cloud, it gives me an error Got minus one from a read call. I've been trying many things in the discussions but nothing seems to work for me: this is my input: input{ j… --- ## [Connecting to Tableau: Tableau could not generate a query to perform this operation](https://discuss.elastic.co/t/connecting-to-tableau-tableau-could-not-generate-a-query-to-perform-this-operation/342517)
**Author:** [@Krikkits](https://discuss.elastic.co/u/Krikkits)\ **Replies:** 4\ **Last updated:** [September 8, 2023, 10:17am UTC](https://discuss.elastic.co/t/connecting-to-tableau-tableau-could-not-generate-a-query-to-perform-this-operation/342517 "2023-09-08T10:17:06Z")
I have Elasticsearch 7.17.3 and the latest Tableau Desktop (trial version). I followed the documentation (v. 7.17.3 connectors as well) on how to connect them and it works. However, even though the tables are shown withi… --- ## [Logstash connecting to more than 1 Database](https://discuss.elastic.co/t/logstash-connecting-to-more-than-1-database/341791)
**Author:** [@Ong](https://discuss.elastic.co/u/Ong)\ **Replies:** 1\ **Last updated:** [August 28, 2023, 1:10pm UTC](https://discuss.elastic.co/t/logstash-connecting-to-more-than-1-database/341791 "2023-08-28T13:10:00Z")
I have 2 separate MSSQL databases and would like to extract data from them, combine it and send it to ES for indexing. Can Logstash connect to more than 1 MSSQL database, retrieve certain data from them then combine the… --- ## [How many records does jdbc input plugin can read at once?](https://discuss.elastic.co/t/how-many-records-does-jdbc-input-plugin-can-read-at-once/341561)
**Author:** [@Sreenivas1](https://discuss.elastic.co/u/Sreenivas1)\ **Replies:** 1\ **Last updated:** [August 24, 2023, 2:43pm UTC](https://discuss.elastic.co/t/how-many-records-does-jdbc-input-plugin-can-read-at-once/341561 "2023-08-24T14:43:13Z")
Hi Team, We have to pull data of 70million records from oracle database in a week and load into elastic cluster of 3 nodes. So we have a scheduler in database side which will load 50k or 1million records in 6min to a te… --- ## [Can I access data in my 2nd lookup using 1st lookup result using jdbc\_static filter in Logstash for my mariaDB data](https://discuss.elastic.co/t/can-i-access-data-in-my-2nd-lookup-using-1st-lookup-result-using-jdbc-static-filter-in-logstash-for-my-mariadb-data/340977)
**Author:** [@aurangzeb99](https://discuss.elastic.co/u/aurangzeb99)\ **Replies:** 0\ **Last updated:** [August 17, 2023, 7:32am UTC](https://discuss.elastic.co/t/can-i-access-data-in-my-2nd-lookup-using-1st-lookup-result-using-jdbc-static-filter-in-logstash-for-my-mariadb-data/340977 "2023-08-17T07:32:20Z")
Hello I am using jdbc\_static filter in Logstash for my mariaDB data . where I have define 2 local\_lookups. Can I access data in my 2nd lookup using 1st lookup result fields ???????????????? local\_lookups =\> \[ { … --- ## [Error executing logstash pipeline with jdbc select SQLDataException: ORA-01846: not a valid day of the week](https://discuss.elastic.co/t/error-executing-logstash-pipeline-with-jdbc-select-sqldataexception-ora-01846-not-a-valid-day-of-the-week/340368)
**Author:** [@cperzrt10](https://discuss.elastic.co/u/cperzrt10)\ **Replies:** 4\ **Last updated:** [August 11, 2023, 6:23am UTC](https://discuss.elastic.co/t/error-executing-logstash-pipeline-with-jdbc-select-sqldataexception-ora-01846-not-a-valid-day-of-the-week/340368 "2023-08-11T06:23:14Z")
We have into logstash pipeline the config to search into database and get the data, after the first search we want only select the new data, to do this we use the config of jdbc plugin, my pipeline config. input { jdb… --- ## [Unable to configure oracle stored procedure in logstash jdbc pipeline](https://discuss.elastic.co/t/unable-to-configure-oracle-stored-procedure-in-logstash-jdbc-pipeline/340369)
**Author:** [@Sreenivas1](https://discuss.elastic.co/u/Sreenivas1)\ **Replies:** 3\ **Last updated:** [August 9, 2023, 7:30am UTC](https://discuss.elastic.co/t/unable-to-configure-oracle-stored-procedure-in-logstash-jdbc-pipeline/340369 "2023-08-09T07:30:43Z")
Hi all, I'm trying to call stored procedure created in oracle database using logstash jdbc pipeline but even I tried with many ways to pass stored procedure in statement it's getting failed with sql error exceptions . … --- ## [Logstash JDBC Input Plugin Connection Pooling](https://discuss.elastic.co/t/logstash-jdbc-input-plugin-connection-pooling/337823)
**Author:** [@alromos](https://discuss.elastic.co/u/alromos)\ **Replies:** 4\ **Last updated:** [July 31, 2023, 11:08pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-plugin-connection-pooling/337823 "2023-07-31T23:08:35Z")
Our team is actively using Logstash JDBC Input plugin with MSSQL JDBC driver for reading some data from DB for further processing. Logstash version: 8.5.1 MSSQL JDBC version: 11.2.1.jre17 At the moment we are facing s… --- ## ["The connection is broken and recovery is not possible" after MSSQL reboot](https://discuss.elastic.co/t/the-connection-is-broken-and-recovery-is-not-possible-after-mssql-reboot/338793)
**Author:** [@mr18](https://discuss.elastic.co/u/mr18)\ **Replies:** 1\ **Last updated:** [July 19, 2023, 4:02pm UTC](https://discuss.elastic.co/t/the-connection-is-broken-and-recovery-is-not-possible-after-mssql-reboot/338793 "2023-07-19T16:02:50Z")
Hi all ! I use a jdbc input plugin to get MS SQL data. Everything works fine, but when my SQL server reboots for maintenance, the queries don't work anymore, and I have the following error: \[ERROR\]\[logstash.inputs.jdb… --- ## [Logstash stops treatment when database goes down](https://discuss.elastic.co/t/logstash-stops-treatment-when-database-goes-down/338806)
**Author:** [@thibaut\_a](https://discuss.elastic.co/u/thibaut_a)\ **Replies:** 0\ **Last updated:** [July 19, 2023, 3:30pm UTC](https://discuss.elastic.co/t/logstash-stops-treatment-when-database-goes-down/338806 "2023-07-19T15:30:35Z")
Hi, I have multiple JDBC inputs waiting for PostgreSQL database lines each minute. The database has a problem and is down. Due to this mistake, I don't receive any log in Kibana. I tried to find some fields in the docum… [Next page](https://discuss.elastic.co/tag/jdbc/102.md?match_all_tags=true&page=1&tags%5B%5D=jdbc)