Guys,

I hope you can help.

We are using MSSQL server using stored proecures. Currently the stored proecudre is called using JDBC, which returns 1000 rows(say). This data is used in several places through the application, and currently I am looking at a way of applying aggregation and grouping to this stored proecdures result.

This cannot be done at the database level and might need to be donw recursively. Ie grouping on results of grouping. I have looked at Hiberante but couldnt see if this was possibel.

I have also looked ta Appache Commons etc.

Thanks for your help

Steve,

I would suggest you do some more reading on hibernate. It is a very powerful tool in dealing with database persistence in Java.

However, if you are locked in to exectuing your stored procedure using JDBC, you will not be able to use Hibernate to populate your graph. You can however execute your Stored Procedure withint the Hibernate framework and return a graph of objects.

I would suggest looking at the Hibernate 3 reference documentation for more information.

Hi,

I am not delaing with data persistence - Rather I am dealing with data retrieval.

Yes I know Hibernate can execute a stored proecure and yes i can go the hiberante way for this. However, the sored proecdeue seems to be executed only when efined in XML - a big show stopper fopr me - and even if i could execute a stored proecure using hiberante - how then can you apply filtering grouping and aggrgation to the result set.

I really dont wnat tio havbe to code this - but it looks like I might

Hi,

I am not delaing with data persistence - Rather I am dealing with data retrieval.

Yes I know Hibernate can execute a stored proecure and yes i can go the hiberante way for this. However, the sored proecdeue seems to be executed only when efined in XML - a big show stopper fopr me - and even if i could execute a stored proecure using hiberante - how then can you apply filtering grouping and aggrgation to the result set.

I really dont wnat tio havbe to code this - but it looks like I might

Your stored procedure is still defined in the database, but you have to map the return values to the class mapping in Hibernate. How else would it know what to do ?

Look at section 17.3.2 in the Hibernate 3.0.5 reference docs for an example.

So if I unedrstabnd you correctly - every time a stored proecudre chnages then the XML file needs to be updated as well as your class which contain geters and setters.

This is a mainatance nightmare - JDBC allows you to process the result set regardless of how / what has retirved from the database

Does hibernate not have a generic object which you can use.

My main concern is that I do not know what the stored proecures return - they should work with any stored proecure.

Does that mean that Hibernate is definitely out the question - there is no way that I can construct the XML hibernate mapping file on the fly.

I really only need to use the power of JDBC with the nice features from Hibernate

So if I unedrstabnd you correctly - every time a stored proecudre chnages then the XML file needs to be updated as well as your class which contain geters and setters.

This is a mainatance nightmare - JDBC allows you to process the result set regardless of how / what has retirved from the database

Does hibernate not have a generic object which you can use.

My main concern is that I do not know what the stored proecures return - they should work with any stored proecure.

Does that mean that Hibernate is definitely out the question - there is no way that I can construct the XML hibernate mapping file on the fly.

I really only need to use the power of JDBC with the nice features from Hibernate

How does straight JDBC help you if you change the results of your Stored Procudure ? If you add or change a column in the SP resutls, JDBC will not magically retrieve it and populate the proper field.

I obviously don't fully understand what you're doing with this data currently. But the purpose of Hibernate is to simply the process of converting database data into Java Objects. If you don't need the data in a Java object, I'm not sure what you want Hibernate to do.

Hi,

Thanks so much for your help.

Maybe let me give ou an example

public void processResultSet(String spName, int resultLength){
//open a connection to the server and exurte the stored proedcure
// Fetch each row from the result set

while (rs.next()) {
for(int i=0; i< resultLength; i++){
// Get the data from the row using the column index
String s = rs.getString(i);

// Get the data from the row using the column name
System.out.println(s);

}

}
} catch (SQLException e) {
}

This is exactly what I want - but before processign the results I want to apply a group by
or a aggregation of the data.

Is this clearer?

I don't totally understand your motivation, but perhaps you need to investigate the use of custom persisters.