How to query Oracle sql-fucntion to_char with 2 params?

onit · **Joined:** Tue Aug 15, 2006 8:49 am **Posts:** 9

NHibernate version: 1.2.0.4000

Mapping documents:

Code:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-lazy="false" namespace="KRS" assembly="Ecomonica">
   <class name="TestFixMestoroz" table="TEST_FIX_MESTOROZ">
      <!-- Primary Key(s) -->
      <id name="IdMest" column="ID_MEST" type="Decimal" unsaved-value="0">
         <generator class="assigned"/>
      </id>
      
      <!-- Properties -->
      <property column="NAME_" type="String" name="Name1" length="100" />
      <property column="ID_TYPE" type="Decimal" name="IdType" />
      <property column="NAME_ROD" type="String" name="NameRod" length="150" />
      <property column="SETTINGS" type="String" name="Settings" length="200" />
      <property column="LOCALSETTINGS" type="String" name="Localsettings" length="2000" />
      <property column="DS_CRC32" type="System.Byte[]" name="DsCrc32" />
      <property column="DS_CRC32_DATE" type="System.DateTime" name="DsCrc32Date" />
      <property column="SETTINGS_UPDATER" type="String" name="SettingsUpdater" length="100" />
      <property column="FOR_FINDER" type="String" name="ForFinder" length="300" />
      <property column="ID_MEST_SQLSERVER" type="Decimal" name="IdMestSqlserver" />
      <property column="ID_ZALEJ_SQLSERVER" type="Decimal" name="IdZalejSqlserver" />
   </class>
</hibernate-mapping>

Name and version of the database you are using:
Oracle 10G

Error: alias or expression expected in SELECT

How to create HQL-query fith SQL-function like this for Oracle9 Dialect?

Code:

select to_char(tmz.DsCrc32Date,'YYYY') from TestFixMestoroz tmz")

onit · **Joined:** Tue Aug 15, 2006 8:49 am **Posts:** 9

SQL Functions do not work in select section?

Only in where?

wolli · **Posted:** Fri Aug 29, 2008 2:55 am

If you want to use special sql functions you have to use a SQL query instead of HQL. HQL only supports a special set of functions.

onit · **Joined:** Tue Aug 15, 2006 8:49 am **Posts:** 9

This function is registered in Oracle9Dialect.

HQL

Code:

from TestFixMestoroz tmz where to_char(tmz.DsCrc32Date,'YYYY')=:year

param year = 2005

work fine.

In select not work :(