hi!
what's wrong hire?
select r
from
Obj r
join r.Resource resource
where
:targetPath2 like concat(concat(resource.Path,
resource.id), '/%')
and (r.IsHeritable= true or resource.id= :targetId or
r.IsStartedFromHire)
and concat(r.PermitLevels, r.DenyLevels) like
concat(concat('%',:level), '%')
order by
resource.Path desc
I know that error is in this string. But I don't understand why
and (r.IsHeritable= true or resource.id= :targetId or
r.IsStartedFromHire)
Could not cust "Antlr.Runtime.Tree.CommonTree" to
"NHibernate.Hql.Ast.ANTLR.Tree.IASTNode". (translated)
Even if I modify this query to
select r
from
Obj r
join r.Resource resource
where
true
it will throw exception.
hibernate config
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property
name="connection.provider">NHibernate.Connection.DriverConnectionProvider</
property>
<property name="dialect">NHibernate.Dialect.SQLiteDialect</
property>
<property
name="connection.driver_class">NHibernate.Driver.SQLite20Driver</
property>
<property name="connection.connection_string">Data Source=C:
\helpdesk\Tests\planneddebtorsrollcall.db;Version=3</property>
<property name="query.substitutions">true=1;false=0</property>
<property
name="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory,
NHibernate.ByteCode.Castle</property>
<property name="show_sql">true</property>
</session-factory>
</hibernate-configuration>
Thanks!
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
