Problem connecting to external PostgreSQL DB using connector
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:
- Choose connector - PostgreSQL 9.2.
Choose driver - PostgreSQL.
Enter DB access information. DB is hosted locally.
- Put simple test SQL query. Further I did not choose any additional dependencies.
- Here I suppose to see information from the table, but I got this (and have no I what to do with it):
- Then I tried another query with choosing dependency:
With a bit different result:
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!