This is not the proper list for this kind of questions; in the future, I
ask you to use nhusers instead.
As for your question, I'm not a MySQL user, can you try instead:
session.CreateSQLQuery("SET @id = 0; SELECT @id");
Maybe there's a different syntax in MySQL.
RP
On Friday, October 3, 2014 2:52:53 PM UTC+1, Danny Stommen wrote:
>
> Hi all,
>
> I have "job queue" table, where several worker processes can take a job
> from.
>
> To "claim" a job, I want to execute the following query:
>
> SET @id = 0;
>
> UPDATE job
> INNER JOIN
> (
> SELECT id AS tempid, @id := id;
> FROM job
> WHERE active_host IS NULL
> AND enabled = 1
> AND next_start < NOW()
> ORDER BY next_start ASC
> LIMIT 1
> ) tmp
> ON id = tempid
> SET active_host = :host;
>
> SELECT @id;
>
>
> This works just fine in the normal MySQL Workbench, but NHibernate keeps
> having issues with the user defined variable @id. Even just executing "SET
> @id = 0" fails:
>
> var r = session.CreateSQLQuery("SET @id = 1; ").UniqueResult();
> "could not execute query\r\n[ SET @id = 1; ]\r\n[SQL: SET @id = 1;]"
> inner exception: Fatal error encountered during command execution.
>
> Is it possible to do this using NHibernate?
>
>
> Thanks!
>
> Danny
>
--
---
You received this message because you are subscribed to the Google Groups
"nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
