How to print the result from the query. It returns [Ljava.lang.Object;@72557746[Ljava.lang.Object;@8c12524[Ljava.lang.Object; . But I want the exact value. Thanks
For your information, I am achieving a dynamic column from the query, execute it and call from hibernate.
// build sql
String sql = " DECLARE @cols AS NVARCHAR(MAX), @getweekly AS NVARCHAR(MAX), @getmonthly AS NVARCHAR(MAX), "
+ " @finalresult AS NVARCHAR(MAX), @startdate datetime, @enddate datetime, @paramdef nvarchar(max) "
+ " set @startdate = '2013-01-01 00:00:00.000' set @enddate = '2018-01-01 23:59:59.000'; set @paramdef = '@startdate datetime, @enddate datetime'; "
+ " select @cols = STUFF((SELECT ',' + QUOTENAME(convert(varchar(10), S_DATE_TO, 120)) from VW_PLANNINGS_NEW where S_DATE_TO >= @startdate and S_DATE_TO <= @enddate "
+ " group by S_DATE_TO order by S_DATE_TO FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)') ,1,1,'') "
+ " set @getweekly = N'SELECT *, '+ @cols + ' "
+ " from ( select S_AMOUNT, S_INSTITUTION_TITLE, S_DATE_TO from VW_PLANNINGS_NEW where S_DATE_TO > @startdate and S_DATE_TO <= @enddate "
+ " ) x pivot ( SUM(S_AMOUNT) for S_DATE_TO in ('+@cols+') ) p ' "
+ " set @getmonthly = N'SELECT *, '+ @cols + ' from "
+ " ( select S_AMOUNT, S_INSTITUTION_TITLE, S_DATE_TO from VW_PLANNINGS_NEW where S_DATE_TO > @startdate and S_DATE_TO <= @enddate ) x "
+ " pivot ( SUM(S_AMOUNT) for S_DATE_TO in ('+@cols+') ) p ' "
+ " set @finalresult = @getweekly + ' UNION ALL ' + @getmonthly; "
+ " exec sp_executesql @finalresult output, @paramdef, @startdate = @startdate, @enddate = @enddate; ";
// execute query
SQLQuery query = session.createSQLQuery( sql );
List<?> rows = query.list();
// print object
for( int i=0; i<rows.size(); i++ )
{
// debug
System.out.print( rows.get( i ) );
}
