I have to make changes to a table which is not mapped. In order to centralize sql statements, I want to use named sql queries.

I know how to get values from them, but is there also a possiblity to include a parameter in the query and assign a value to it upon creation of the query?


Thanks in advance.
Martin

yes, just do it like any other query.

Could you give me an example or a hint where to look in the documentation?
I didn't find something which helps me.

The very first example includes a parameter and and example code.

http://www.hibernate.org/hib_docs/v3/re ... medqueries

Thanks Max, now I see the example ;)

Unfortunately, it seems I have to go another way.

I wanted to execute an insert or update statement on a table which isn't mapped on a class, so I use a native query. But it seems that I can only execute SELECTs because I can only use methods like uniqueResult() etc. which require a specified return parameter (which I of course don't have if I'm updating or inserting).


My situation is the following:

I have multiple objects of type Plan. Exactly one plan has to be active, so I made a table which contains the id of the active plan. Every Plan has a active-property which gets its value from a formula which compares the id of the plan with the active one.

But formulars are read-only, so I need a mechanism to set this value, too.

Or is there a possibility to do this built-in in hibernate?
Creating a class which only contains a reference on the active plan doesn't sound like a good idea to me.

you can map the same column multiple times, but only one of them can be updatable...dont know if that helps you.

There is a method executeUpdate at least with Hibernate 3.
In the reference have a look at the native SQL.

Just an idea, but couldn't you use a trigger.
insert new plan => trigger sets other plan inactive


Regards Sebastian

executeOrUpdate() only works with HQL queries -. I get an java.lang.UnsupportedOperationException.

A trigger is also not an option because the table doesn't have a column for pubslihed so the trigger wozld never knwo if the inserted or updated plan has to be activated or not.


I'll try to access the JDBC connection directly and send the statement there.
That would be quite a dirty solution, but it should work.

Which Hibernate version do you use?

I use 3.0.5.

Consider the following example:



I get the following:

Sorry, I thought that would work. But I tested it with 3.1 and it is the same.

In this case you may consider to fetch the connection from the session and make a direct JDBC connection, as you propose
session.getConnection

or you may try a stored procedure with a parameter as explained in the reference.

Regards Sebastian