This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 240166

Summary: Add additional support, like SQL in hibernate.xml
Product: javaee Reporter: tomzi <tomzi>
Component: HibernateAssignee: Sergey Petrov <sj-nb>
Status: RESOLVED WONTFIX    
Severity: normal    
Priority: P3    
Version: 7.4   
Hardware: PC   
OS: Linux   
Issue Type: ENHANCEMENT Exception Reporter:

Description tomzi 2014-01-09 15:56:23 UTC
In an hibernate.xml you might have:

<hibernate-mapping>
   <class name="com.comp.Addresses" table="ADDRESSES" dynamic-update="true">
   	  <id name="lineNumber" column="LINE_NUMBER" type="integer"></id>
      <property name="ardId" column="ARD_ID" type="integer">
      </property>
      <property name="exchangeSite" type="string">
         <column name="EXCHANGE_SITE" not-null="true" length="255" />
      </property>
	</class>
	<sql-query name="com.comp.Addresses.Addresses">
		<return alias="Address" class="com.comp.Addresses"/>
		<![CDATA[ 
		WITH tokens AS (
    SELECT substr(',' || :address, s + 1, e - s - 1) e, rownum n FROM (
                    SELECT  instr(' ' || :address, ' ', 1, level) s
                          , instr(' ' || :address || ' ', ' ', 1, level + 1) e 
                      FROM dual CONNECT BY instr(' ' || :address, ' ', 1, level) != 0
            )
), token_without_number as (
    SELECT e, rownum n FROM tokens WHERE not(regexp_like(e, '[0-9]'))
), token_with_number as (
    SELECT e, rownum n FROM tokens WHERE regexp_like(e, '[0-9]')
) select
      Address.LINE_NUMBER AS {Address.lineNumber} 
    , Address.ARD_ID AS {.ardId}
....
  from (....)
	]]>
	</sql-query>
	<query name="com.comp.Addresses.getByArdKey">
		From Addresses as nv WHERE nv.ardId = :ardKey		
   </query>
</hibernate-mapping>

Please add support for sql completion in hibernate.
Also add support for the <query ... part.



Product Version = NetBeans IDE 7.4 (Build 201310111528)
Operating System = Linux version 3.8.0-32-generic running on amd64
Java; VM; Vendor = 1.7.0_45
Runtime = Java HotSpot(TM) 64-Bit Server VM 24.45-b08
Comment 1 Svata Dedic 2015-04-07 09:14:46 UTC
Pls. evaluate.
Comment 2 Martin Balin 2016-07-07 08:53:36 UTC
This old bug may not be relevant anymore. If you can still reproduce it in 8.2 development builds please reopen this issue.

Thanks for your cooperation,
NetBeans IDE 8.2 Release Boss