# Configuring logstash to connect to Oracle AQ (JMS) without a web server

**URL:** <https://discuss.elastic.co/t/configuring-logstash-to-connect-to-oracle-aq-jms-without-a-web-server/314266>\
**Category:** Logstash\
**Created:** [September 13, 2022, 8:35am UTC](https://discuss.elastic.co/t/configuring-logstash-to-connect-to-oracle-aq-jms-without-a-web-server/314266 "2022-09-13T08:35:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ztine77](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ztine77/32/110787_2.png) [@ztine77](https://discuss.elastic.co/u/ztine77)\
**Post date:** [September 13, 2022, 8:35am UTC](https://discuss.elastic.co/t/configuring-logstash-to-connect-to-oracle-aq-jms-without-a-web-server/314266/1 "2022-09-13T08:35:30Z")

</div>

I use dockerized version of logstash and would like to use Oracle AQ as an input.  
This is my ./pipeline/logstash.conf file:

```auto
input {
  jms {
    broker_url => 'jdbc:oracle:thin:@server:1521:sid' 
    destination => 'MYQUEUE' 
    factory => 'oracle.jms.AQjmsInitialContextFactory' 
    pub_sub => false 
    use_jms_timestamp => false 
    username => 'usr'
    password => 'pwd'
    keystore => ''
    keystore_password => ''
    truststore => ''
    truststore_password => ''
    include_headers => false
    include_properties => false
    include_body => true
    selector => ''
    factory_settings => { 
      exclusive_consumer => true
    }
    require_jars => [
      '/usr/share/logstash/jars/aqapi-19.3.0.0.jar', 
      '/usr/share/logstash/jars/javax.jms-api-2.0.1.jar', 
      '/usr/share/logstash/jars/jta-1.1.jar', 
      '/usr/share/logstash/jars/ojdbc8-21.5.0.0.jar', 
      '/usr/share/logstash/jars/xdb-19.3.0.0.jar', 
      '/usr/share/logstash/jars/xmlparserv2-19.3.0.0.jar'
    ] 
  }
}

output {
  stdout {
    codec => rubydebug
  }
}

```

When I run the container or execute: $bin\> . ./logstash, I receive this error:

```auto
[ERROR][logstash.agent] Failed to execute action {:action=>LogStash::PipelineAction::Create/pipeline_id:main, :exception=>"LogStash::ConfigurationError", :message=>"Expected one of [\\t\\r\\n], \"#\", \"{\", \"}\" at line 3, column 58 (byte 74) after input {\n jms {\n broker_url => 'jdbc:oracle:thin:@devana:1521:stenar1'", :backtrace=>["/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:32:in `compile_imperative'", "org/logstash/execution/AbstractPipelineExt.java:210:in `initialize'", "org/logstash/execution/JavaBasePipelineExt.java:72:in `initialize'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:48:in `initialize'", "org/jruby/RubyClass.java:909:in `new'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline_action/create.rb:50:in `execute'", "/usr/share/logstash/logstash-core/lib/logstash/agent.rb:381:in `block in converge_state'"]}

```

What am I doing wrong? Is this the proper way to connect to Oracle queue? Thank you.

---

<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:** [October 11, 2022, 8:36am UTC](https://discuss.elastic.co/t/configuring-logstash-to-connect-to-oracle-aq-jms-without-a-web-server/314266/2 "2022-10-11T08:36:17Z")

</div>

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