# JDBC Plugin — Missing Converter handling for full class name=org.postgresql.util.PGobject, simple name=PGobject

**URL:** https://discuss.elastic.co/t/jdbc-plugin-missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/311246
**Category:** Logstash
**Created:** [August 2, 2022, 10:30pm UTC](https://discuss.elastic.co/t/jdbc-plugin-missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/311246 "2022-08-02T22:30:21Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![5k\_pwc](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/5k_pwc/32/107057_2.png) [@5k\_pwc](https://discuss.elastic.co/u/5k_pwc)
#### Post date: [August 2, 2022, 10:30pm UTC](https://discuss.elastic.co/t/jdbc-plugin-missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/311246/1 "2022-08-02T22:30:21Z")

</div>

hi,  
my table geometry, JSONB, i get the below exception.  
Exception when executing JDBC query {:exception=\>Sequel::DatabaseError, :message=\>"Java::OrgLogstash::MissingConverterException: Missing Converter handling for full class name=org.postgresql.util.PGobject, simple name=PGobject", :cause=\>"org.logstash.MissingConverterException: Missing Converter handling for full class name=org.postgresql.util.PGobject, simple name=PGobject"}

my conf like :``Preformatted text\> `

> > input {  
> > jdbc {  
> > jdbc\_driver\_library =\> "C:\Users\Lenovo\Desktop\ELK\logstash-8.1.0\logstash-core\lib\jars\postgresql-42.4.0.jar"  
> > jdbc\_driver\_class =\> "org.postgresql.Driver"  
> > jdbc\_connection\_string =\> "jdbc:postgresql://localhost/hb"  
> > jdbc\_user =\> "p"  
> > jdbc\_password =\> "1234"  
> > statement =\> 'SELECT \* FROM "E-ANOMAL"'

```
}

```

}

filter {  
ruby {  
code =\> "  
require 'json'  
begin  
point\_json = JSON.parse(event.get('location'))  
data\_json = JSON.parse(event.get('additionaldata').to\_s || {})  
event.set('lon', point\_json['coordinates'][0])  
event.set('lat', point\_json['coordinates'][1])  
event.set('data', data\_json)  
rescue Exception =\> e  
event.tag('invalide boundaries json')  
end  
"  
}  
}

output {  
elasticsearch {  
hosts =\> ["[http://localhost:9200](http://localhost:9200)"]  
index =\> "my-index"  
user =\> "ela"  
password =\> "ro"  
document\_id =\>"%{id}"  
}  
}  
please you suggestion

---

<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 30, 2022, 10:30pm UTC](https://discuss.elastic.co/t/jdbc-plugin-missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/311246/2 "2022-08-30T22:30:31Z")

</div>

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