I have a stored procedure in sql server , my goal is i need to parse that into java code , In procedure there are some physical and temporary tables involved , i created domain classes for physical tables, so can i also map domain classes with temporary table .
my procedure is
thank you , i created one class that represents the result set of procedure, and i mapped properties of that class with procedure return results,
and i have list of files that represent #files (temporary table) , even though i have one more problem is that, there is a #files (temporary table) in the FROM Clause of Select Statement.
So How can i map this Files class with #files temporary table, is it possible to map? (because it is not physical table in database), so how can i achieve this using Java Code?
( or) please give me suggestions, How to write the java code(in spring jdbc) using domain(pojo) classes by mapping with physical and temporary tables for the above mentioned 'select query ' .
subject: is it good idea to create domain classes for temporary tables, if so, is how is possible