[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2129) Invalid column name SQL Error: 17006, SQLState: null
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2129?page=c...
]
sagar patkar commented on HHH-2129:
-----------------------------------
Since stored procedures currently only return scalars and entities, is it so that we
should always retrieve all columns of table using select * or the column names which are
mapped to particular fields of java class? Can we retrieve single column in result set as
result from procedure? Does Hibernate 3.2 version support this feature? Please answer
these questions in details since I didn't find any help from
http://forum.hibernate.org/
Invalid column name SQL Error: 17006, SQLState: null
----------------------------------------------------
Key: HHH-2129
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2129
Project: Hibernate3
Type: Bug
Components: query-sql
Versions: 3.2.0.cr3
Environment: Hibernate 3.2 cr3 with oracle 9i
Reporter: sagar patkar
Hi,
Is it required that stored procedure must return all the column in the resultset of the
mapped class. i was trying to fetch only subset of column & i got the following
exception
ERROR [org.hibernate.util.JDBCExceptionReporter] - <Invalid column name>
is it a bug? or is there any alternative solution for this?
Stored procedure
CREATE OR REPLACE PACKAGE BODY Pkg_Test2
IS
PROCEDURE get_my_list(p_record OUT ref_cur ,eventid IN NUMBER)
AS
BEGIN
OPEN p_record FOR
SELECT EVENT_ID, TITLE FROM EVENTS WHERE EVENT_ID=eventid;
END get_my_list;
END Pkg_Test2;
/
mapping file for procedure call
<sql-query name="test_select_sp" callable="true">
<return alias="evaa" class="events.Event">
<return-property name="id" column="EVENT_ID"/>
<return-property name="title" column="TITLE"/>
</return>
{ call pkg_test1.get_selected_list(?,:eventid)}
</sql-query>
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira