[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-1019) HQL Editor unable to correctly detect UserType in Query Parameters

[Bertrand GILLIS (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_29021 ] 

Bertrand GILLIS commented on HBX-1019:
--------------------------------------

My application is connecting to an Oracle 9i database with Hibernate 3.2.5 GA where dates are stored as string (VARCHAR), in format "yyyyMMdd".

In order to have these dates in my Pojos as java.util.Date, I've implemented both interfaces UserType and ParameterizedType. This type takes one parameter: "datePattern" (default value: "yyyyMMdd").

I'm using HQL Editor available with Hibernate Eclipse plugin for development purposes and I'd like to configure this UserType/ParameterizedType in the Editor. Otherwise, I couldn't test any HQL statement on my pojo attributes using this type (eg. select an entity where one entity attribute of this type is equal to the system date).

Types seems to be available for all Hibernate native types (tab "Query Parameters", column "type") but not for user defined types. When I click the :P+, HQL Editor doesn't automatically figured out my UserType.

Test case are fully provided (see file attachments and printscreen).

> HQL Editor unable to correctly detect UserType in Query Parameters
> ------------------------------------------------------------------
>
>                 Key: HBX-1019
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1019
>             Project: Hibernate Tools
>          Issue Type: Bug
>          Components: eclipse
>    Affects Versions: 3.2.cr1
>         Environment: DB: Oracle 9i
> OS: Windows XP SP2
>            Reporter: Bertrand GILLIS
>         Attachments: Hibernate Perspective in Eclipse.jpg, Statement.hbm.xml, Statement.java, STATEMENT.sql, StringDateType.java, TypeDef.hbm.xml
>
>
> For full details about this issue, please refer to the following post on Hibernate forum: http://forum.hibernate.org/viewtopic.php?t=981674

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira