Hi,

I have to call some stored procedures on a 4D database and to map the resultsets.
Here is an example :
XX_StoredProc_GetPContac take 3 parameters (int,int,String) and return a resulset that I just want to map to Document entities.

Hibernate version:3.0.5

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.orkis.ajaris.hibernate">

<class name="Document">
<id name="ref" type="string" />
<property name="titre" type="string" not-null="true"/>
<property name="blob" type="blob" not-null="true"/>

<loader query-ref="pContact"/>
</class>

<sql-query name="pContact" callable="true">
<return class="Document">
<return-property name="ref" column="spTabDocRef"/>
<return-property name="titre" column="spTabDocTitre"/>
<return-property name="blob" column="spTabPreviewBlob"/>
</return>
{ ? = call XX_StoredProc_GetPContact(?, ?, ?) }
</sql-query>

</hibernate-mapping>


Code between sessionFactory.openSession() and session.close():
Transaction tx = session.beginTransaction();

List docs =session.getNamedQuery("pContact")
.setInteger(1,1)
.setInteger(2,12)
.setString(3,"neige")
.list();

Iterator it = docs.iterator();
while(it.hasNext()){
Document d =(Document)it.next();
System.out.println(d.getTitre()+" blob size: "+ d.getBlob().length()+ " ref : "+d.getRef());
}

tx.commit();


Full stack trace of any exception that occurs:
java.lang.ArrayStoreException
at java.lang.System.arraycopy(Native Method)
at java.util.ArrayList.toArray(Unknown Source)
at org.hibernate.util.ArrayHelper.toTypeArray(ArrayHelper.java:75)
at org.hibernate.impl.AbstractQueryImpl.typeArray(AbstractQueryImpl.java:627)
at org.hibernate.impl.AbstractQueryImpl.getQueryParameters(AbstractQueryImpl.java:635)
at org.hibernate.impl.SQLQueryImpl.getQueryParameters(SQLQueryImpl.java:161)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:153)
at HibernateTest.main(HibernateTest.java:25)


HibernateTest.main(HibernateTest.java:25) -> list()

Name and version of the database you are using:
4D


I don't know if my exception is due to a bad mapping or if it comes from my JDBC driver.
I have customized the 4D JDBC driver, to support resulset retrieving from stored procedures.
I've tried in JDBC and it works well, but some classes or method are not implemented so I thought that the error could come from the driver, but the exception doesn't really help me to find the problem.

For information i use the GenericDialect.

I hope that someone will be able to help me finding the problem.

Thanks for your help

the first ? is not a real parameter.

try setting parameter 0, 1 and 2 instead of 1, 2 and 3

Thanks for answering so quickly max,

you are right, i've replaced 1,2,3 by 0,1,2 like that


and then i replaced in the mapping file, the stored procedure call

by :


because the JDBC driver didn't recognize the first form.

I had to write a more specific Dialect, because i had the following error with the generic one :


I have just implemented the following methods in my dialect, and extend GenericDialect class:


I have verified on the 4d server, the stored procedure is called, the 3 parameters are ok, and the procedure make its "work" and return the good result.
But the problem that I have now is that the list() method returns a void list.
I think that the problem must come from the mapping, because i'm sure that myresultset is not empty. I have launched the test under eclipse in debug mode with breakpoints and i have seen the good values in the resulset.

So does someone has an idea?

thanks in advance

it's ok i've found the problem,

i had made a mistake in my resulset implementation :
a beforefirst() was needed before the first next() call on the resulset, i've corrected that and now the mapping works well.

Thanks

++