topic Error when calling a PostgreSQL stored procedure using tdbRow - getting syntax error at end of input in Talend Studio

Error when calling a PostgreSQL stored procedure using tdbRow - getting syntax error at end of input

MRosol_ACS — Fri, 11 Jul 2025 15:39:43 GMT

Hello,

Can someone point me in right direction concerning calling a PostgreSQL procedure in Talend. I am using the tpostresqlRow (which resolves to tdbRow), but no matter how I call the procedure in the SQL query field, I get the same error.

This is the call in the Query box. The procedure has no parameter inputs.

"CALL set_status_running;"

This is the error:

"syntax error at end of input"

I'm sure it must be something simple, but so far it is eluding me and I can't find any answers in web searches.

Thank you!

Re: Error when calling a PostgreSQL stored procedure using tdbRow - getting syntax error at end of input

Denis_Segard — Fri, 11 Jul 2025 19:19:53 GMT

Hello,

Could you test to use :

"CALL set_status_running()"

Kind regards
Denis

Re: Error when calling a PostgreSQL stored procedure using tdbRow - getting syntax error at end of input

MRosol_ACS — Fri, 11 Jul 2025 19:38:36 GMT

Hello Denis, thank you for your response.

Calling the procedure with the parentheses returns this error:

ERROR: procedure set_status_running() does not exist
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Position: 6
[ERROR] 15:36:43 erds_talend.mspubs_package_procedures_0_1.MSPUBS_Package_Procedures- tDBRow_1 - ERROR: procedure set_status_running() does not exist
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Position: 6

If I remove the parentheses -- "CALL set_status_running" I get this error:

ERROR: syntax error at end of input
Position: 31
[ERROR] 15:34:30 erds_talend.mspubs_package_procedures_0_1.MSPUBS_Package_Procedures- tDBRow_1 - ERROR: syntax error at end of input
Position: 24

Re: Error when calling a PostgreSQL stored procedure using tdbRow - getting syntax error at end of input

Denis_Segard — Sat, 12 Jul 2025 08:48:48 GMT

Hello,
1. The procedure exists ion the DB / Schema set in the component ?

2. Else you can create a file c:/temp/logging.postgres.properties with the lines:

.level=INFO handlers =java.util.logging.ConsoleHandler java.util.logging.ConsoleHandler.level = ALL java.util.logging.ConsoleHandler.formatter = java.util.logging.SimpleFormatter sun.net.www.protocol.http.HttpURLConnection.level=ALL # Facility specific properties. org.postgresql.level = FINEST

then, execute the job with the JVM argument :
-Djava.util.logging.config.file=c:/temp/logging.postgres.properties

to get some traces from the Postgres JDBC Driver ...

Kind regards
Denis

Re: Error when calling a PostgreSQL stored procedure using tdbRow - getting syntax error at end of input

MRosol_ACS — Mon, 14 Jul 2025 18:02:10 GMT

Thank you Denis.

I worked with a Postgres developer who demonstrated how to get the procedure to work in the Postgres IDE. The problem was with how I set up the Talend connection. The procedures were implemented in a separate schema from the tables and I thought I needed a separate connection for that schema. (I didn't.)

Best regards,

Martin