Hibernate Community • View topic - Create function in SQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Create function in SQL

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

Buio

Post subject: Create function in SQL

Posted: Wed May 20, 2009 11:23 am

Newbie

Joined: Wed May 20, 2009 11:03 am
Posts: 1

I need to let a user to create a function by insering sql code.
The code is in PL/PgSQL.

Code:

String sql = "CREATE OR REPLACE FUNCTION myFunction ..."
... //very long function...
sql +=" end; $BODY$ language 'plpgsql' VOLATILE;";

session.CreateSQLQuery(sql).executeUpdate();

If I execute the code in a program such pgAdmin, the function is created correctly.
But when I try to execute the code with an hibernate sqlquery I get this exception:

java.lang.UnsupportedOperationException: Update queries only supported through HQL

Why must I use only HQL?
I want to use my code, how can I do that?

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum