# Postgres Transaction Group Question

**URL:** <https://forum.inductiveautomation.com/t/postgres-transaction-group-question/64190>\
**Category:** Ignition\
**Created:** [September 16, 2022, 5:48pm UTC](https://forum.inductiveautomation.com/t/postgres-transaction-group-question/64190 "2022-09-16T17:48:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [September 16, 2022, 5:48pm UTC](https://forum.inductiveautomation.com/t/postgres-transaction-group-question/64190/1 "2022-09-16T17:48:16Z")

</div>

I've got a question, I've linked a similar post below, but I'm confused since the 'object' in my query is another string.

Essentially I have a procedure that takes in a Serial number (TEXT), Expected station(TEXT), and outputs an integer to state if the part is ready or not for the station its been scanned at. I can run it within the script console fine, but the transaction returns the following error. the serial number and expected station are string tags with TEXT type on the DB parameter

```auto
Error during group execution. Error registering parameter 'expected_station'. Verify that the parameter name and type are correct. Method org.postgresql.jdbc.PgCallableStatement.setObject(String,Object,int) is not yet implemented.

```

Any ideas? Was hoping to keep things simple and still use transaction groups, but thinking I might be moving to scripting.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/f/9fe88a176206d516a1669b46256555f130fed40d.png)

version 8.1.20

> [@Calling PostegreSQL 11 Stored Procedures](https://forum.inductiveautomation.com/t/calling-postegresql-11-stored-procedures/23786/6):
>
> So. Is it all possible to call a PostgreSQL Procedure from Ignition? Table definition: -- Table: public.decimal\_test -- DROP TABLE public.decimal\_test; CREATE TABLE public.decimal\_test ( val numeric(15,8), src character varying(50) COLLATE pg\_catalog."default" ) TABLESPACE pg\_default; ALTER TABLE public.decimal\_test OWNER to postgres; Procedure with named arguments: -- PROCEDURE: public.decimal\_test\_insert(numeric, character varying) -- DROP PROCEDURE public.decimal\_test\_in…

---

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [September 16, 2022, 7:00pm UTC](https://forum.inductiveautomation.com/t/postgres-transaction-group-question/64190/2 "2022-09-16T19:00:15Z")

</div>

Starting to think I’ve hit a limitation of the Postgres JDBC driver ☹