Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

3.1.2 rc2:

hello, can someone show me how to call a stored procedure correctly?actually, i already called a stored procedure in hibernate mapping but the fields does not correctly put in place..eg. i call a stored like this <sql-insetrt>{ ? = MY_SP(?,?,?,?,?)}</sql-insert> which has 5 parameters..but the data inserted in the database are switch or not put in right fields were should it be..can some tells me whats going wrong..and one yhing i keep arranging the hibernate mapping to put in exact fields of database...tnx

my hbn mapping:

<hibernate-mapping package="com.ifafa.reg.forms">
<class name="Test" table="Test">
<id name="par_Status" column="Status" type="java.lang.Character">
<!--generator class="assigned"/-->
</id >

<property name="par_ID" column="ID" not-null="true" type="java.lang.Long" />
<property name="par_Username" column="Username" not-null="true" type="java.lang.String"/>
<property name="par_Password" column="Password" not-null="true" type="java.lang.String" />
<property name="par_SiteID" column="siteID" not-null="true" type="java.lang.Long" />





<sql-insert callable="true">
{ ? = call SP_Dealer_Registration(?,?,?,?,?) }
</sql-insert>

</class>
</hibernate-mapping>

MySQL 5

From the ref docs, section 16.4:

The order of the positional parameters are currently vital, as they must be in the same sequence as Hibernate expects them.

You can see the expected order by enabling debug logging for the org.hibernate.persister.entity level. With this level enabled Hibernate will print out the static SQL that is used to create, update, delete etc. entities. (To see the expected sequence, remember to not include your custom SQL in the mapping files as that will override the Hibernate generated static sql.)

Hi,

The reference manual has this to say:



Perhaps turning debug level logging on as noted above will show you what Hibernate is expecting as far as parameter order is concerned?

Hope this helps,

thnak for the reply...im kind of newbie here..can you give me how to turn the org.hiberante.persister.entity level?

Edit the log4j.properties file in the top level of your classpath. Have it include this line:

based from im posted:


can you suggest a better way to call a stored procedure in MySQL 5?or have a better example?thus my calling a stored procedure is correct?