# Problem connecting to external PostgreSQL DB using connector

**URL:** <https://community.ofelia.com/t/problem-connecting-to-external-postgresql-db-using-connector/5930>\
**Category:** Q&A\
**Created:** [14 May 2015 08:28 UTC](https://community.ofelia.com/t/problem-connecting-to-external-postgresql-db-using-connector/5930 "2015-05-14T08:28:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shpak.serhiy](https://avatars.discourse-cdn.com/v4/letter/s/73ab20/32.png) [@shpak.serhiy](https://community.ofelia.com/u/shpak.serhiy)\
**Post date:** [14 May 2015 08:28 UTC](https://community.ofelia.com/t/problem-connecting-to-external-postgresql-db-using-connector/5930/1 "2015-05-14T08:28:04Z")

</div>

Bonita BPM 6.5.2. Community  
PostgreSQL 9.4

I am very new in using Bonita. I am studying it to use in production.  
I stuck in pretty simply task. I need to create connectors in order to get and update data from/in external client base (PostgreSQL). I created connector in lane, entered correct info for connecting to the database but can’t event test connection with simple queries.

Here are my steps:

1. Choose connector - PostgreSQL 9.2.

2. Choose driver - PostgreSQL.

3. Enter DB access information. DB is hosted locally.

![3](http://s21.postimg.org/5z1hu7son/screenshot4.png)

1. Put simple test SQL query. Further I did not choose any additional dependencies.

![4](http://s13.postimg.org/68nu4meg7/screenshot5.png)

1. Here I suppose to see information from the table, but I got this (and have no I what to do with it):

![5](http://s18.postimg.org/f6kwxgrgp/screenshot7.png)

1. Then I tried another query with choosing dependency:

![6](http://s1.postimg.org/g2s616ftr/screenshot8.png)

![61](http://s1.postimg.org/7919k2sv3/screenshot9.png)

With a bit different result:

![62](http://s1.postimg.org/aq3bn1rxb/screenshot10.png)

I supposed that using DB connector will allow to use pure SQL queries without the need of Groovy scripting or Java code, at least for simple tasks.

I would be grateful for any hint and advise. Thank you!

---

<div class="post-metadata">

**Author:** ![m.errafay123](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@m.errafay123](https://community.ofelia.com/u/m.errafay123)\
**Post date:** [22 January 2016 11:47 UTC](https://community.ofelia.com/t/problem-connecting-to-external-postgresql-db-using-connector/5930/2 "2016-01-22T11:47:13Z")

</div>

Hi, I have same issue have you figured out what the problem was ?