Results 1 to 1 of 1

Thread: is SimpleJdbcCall the only way to call a function in postgres?

  1. #1
    Join Date
    Apr 2012
    Posts
    3

    Default 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?

    Thanks!
    Last edited by oggie; Sep 5th, 2012 at 11:52 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •