# How to connect to Sybase SQL Anywhere with JDBC plugin **URL:** \ **Category:** Logstash\ **Created:** [August 9, 2017, 2:52pm UTC](https://discuss.elastic.co/t/how-to-connect-to-sybase-sql-anywhere-with-jdbc-plugin/96463 "2017-08-09T14:52:26Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![nikaalv](https://avatars.discourse-cdn.com/v4/letter/n/4da419/32.png) [@nikaalv](https://discuss.elastic.co/u/nikaalv)\ **Post date:** [August 9, 2017, 2:52pm UTC](https://discuss.elastic.co/t/how-to-connect-to-sybase-sql-anywhere-with-jdbc-plugin/96463/1 "2017-08-09T14:52:27Z")
Hello! I need to import data from Sybase SQL Anywhere 17 to Logstash. How can I do it? ---
**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 13, 2017, 6:47pm UTC](https://discuss.elastic.co/t/how-to-connect-to-sybase-sql-anywhere-with-jdbc-plugin/96463/2 "2017-08-13T18:47:53Z")
I was going to point you to the jdbc input plugin but it seems you've already found it. What are you having difficulties with? The more concrete your question is the greater are your chances of getting help. ---
**Author:** ![nikaalv](https://avatars.discourse-cdn.com/v4/letter/n/4da419/32.png) [@nikaalv](https://discuss.elastic.co/u/nikaalv)\ **Post date:** [August 14, 2017, 10:38am UTC](https://discuss.elastic.co/t/how-to-connect-to-sybase-sql-anywhere-with-jdbc-plugin/96463/3 "2017-08-14T10:38:08Z")
I have problem with Logstash JDBC input plugin for SQL Anywhere: My system is : SQL Anywhere 17 Centos 7 (centos-release-7-3.1611.el7.centos.x86\_64) ruby 2.2.5p319 (2016-04-26 revision 54774) [x86\_64-linux] Java: openjdk version "1.8.0\_131" OpenJDK Runtime Environment (build 1.8.0\_131-b12) OpenJDK 64-Bit Server VM (build 25.131-b12, mixed mode) logstash 5.4.0 Logstash conf file: input { jdbc { jdbc\_connection\_string =\> "jdbc:sqlanywhere://host:port/DB\_NAME" jdbc\_user =\> "user" jdbc\_password =\> "password" jdbc\_validate\_connection =\> true jdbc\_driver\_library =\> "/usr/share/logstash/jconn3.jar" jdbc\_driver\_class =\> "com.sybase.jdbc3.jdbc.SybDriver" schedule =\> "00 15 \* \* \*" statement =\> "SELECT User\_ID, User\_Name, Tenant\_ID, Cluster\_ID FROM ads\_user" } } output { elasticsearch { index =\> "ads\_user\_data" document\_type =\> "ads\_user" document\_id =\> "%{User\_ID}" hosts =\> ["localhost:9200"] } } Rezult from the log file: :error=\>"NoMethodError: undefined method `new' for #Array:0x2807bd49"} Error registering plugin {:plugin=\>"\"jdbc:sqlanywhere://host:port/DB\_NAME", jdbc\_user=\>"user", jdbc\_password=\>, jdbc\_validate\_connection=\>true, jdbc\_driver\_library=\>"/usr/share/logstash/jconn3.jar", jdbc\_driver\_class=\>"com.sybase.jdbc3.jdbc.SybDriver", schedule=\>"00 15 \* \* \*", statement=\>"SELECT User\_ID, User\_Name, Tenant\_ID, Cluster\_ID FROM ads\_user", id=\>"c60edd68b511d76cc50eae57ee60a6b6b0c47057-13", enable\_metric=\>true, codec=\>\"plain\_7adfcbcf-b27f-4e1f-8cc4-9e4b5179f098", enable\_metric=\>true, charset=\>"UTF-8"\>, jdbc\_paging\_enabled=\>false, jdbc\_page\_size=\>100000, jdbc\_validation\_timeout=\>3600, jdbc\_pool\_timeout=\>5, sql\_log\_level=\>"info", connection\_retry\_attempts=\>1, connection\_retry\_attempts\_wait\_time=\>0.5, last\_run\_metadata\_path=\>"/usr/share/logstash/.logstash\_jdbc\_last\_run", use\_column\_value=\>false, tracking\_column\_type=\>"numeric", clean\_run=\>false, record\_last\_run=\>true, lowercase\_column\_names=\>true\>", :error=\>"NoMethodError: undefined method `new' for #Array:0x2807bd49"} Pipeline aborted due to error {:exception=\>#\>, :backtrace=>["/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/adapters/jdbc.rb:222:in`connect'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection\_pool.rb:116:in `make_new'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:228:in`make\_new'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection\_pool/threaded.rb:201:in `available'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:137:in`\_acquire'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection\_pool/threaded.rb:151:in `acquire'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:282:in`sync'", "org/jruby/ext/thread/Mutex.java:149:in `synchronize'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection_pool/threaded.rb:282:in`sync'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection\_pool/threaded.rb:150:in `acquire'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/extensions/connection_validator.rb:98:in`acquire'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/connection\_pool/threaded.rb:106:in `hold'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/database/connecting.rb:285:in`synchronize'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.43.0/lib/sequel/database/connecting.rb:295:in `test_connection'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/plugin_mixins/jdbc.rb:171:in`prepare\_jdbc\_connection'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/inputs/jdbc.rb:191:in `register'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:268:in`register\_plugin'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:279:in `register_plugins'", "org/jruby/RubyArray.java:1613:in`each'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:279:in `register_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:429:in`start\_inputs'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:323:in `start_workers'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:214:in`run'", "/usr/share/logstash/logstash-core/lib/logstash/agent.rb:398:in `start\_pipeline'"]} ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 11, 2017, 10:38am UTC](https://discuss.elastic.co/t/how-to-connect-to-sybase-sql-anywhere-with-jdbc-plugin/96463/4 "2017-09-11T10:38:35Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.