Sep 5th, 2012, 11:33 AM
is SimpleJdbcCall the only way to call a function in postgres?
We created a postgres function that takes 2 parameters and returns a list of objects. We need to call it from our application. We currently using spring data, jpa and hibernate.
I should also mention that the return type is custom:
create type cust_access as ( customer_data_id UUID, FK_customer_id UUID,fk_user_login_id UUID,
user_role_name VARCHAR, data_type_name VARCHAR, Name VARCHAR, Value TEXT, edit_priv BOOLEAN );
Is there anyway to call this function using the JPARepository interface or a named query? Or is my only option to use the SimpleJdbcCall?
Last edited by oggie; Sep 5th, 2012 at 11:52 AM.