StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POcan I specify the return type in the hql words
primarykey
Id
4495563
data
AcceptedAnswerId
4499113
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-12-21T01:22:25.223
FavoriteCount
0
LastActivityDate
2010-12-21T12:52:12.953
LastEditDate
2010-12-21T12:52:12.953
LastEditorUserId
306719
OwnerUserId
306719
ParentId
0
PostTypeId
1
Score
0
ViewCount
3917
LastEditorDisplayName
text
Body
Hi: I am using hibernate3.6,I meet some problem when do some querying. Take this hql for exmaple: <pre><code>String hql="select count(distinct ip),sum(bytes) from Entity en where .... Query q=Session.createQuery(hql); List<?> list=q.list(); </code></pre> Now I can retrive the columen properties from the list by the following way: <pre><code> String[] properties={"count","sum"}; for (Object obj : list) { Map<String, Object> m = new HashMap<String, Object>(); Object[] props = (Object[]) obj; if(properties.length!=props.length) throw .... for (int i = 0; i < props.length; i++) { m.put(properties[i], props[i]); } } </code></pre> Now,my problem is that,when the hql result no set,the count is 0,but the sum is null. I want it 0 also. Of course,I can do the converting explicitly if the know the column name and type(they are the count,sum in the above example) of the result table from db,but now I did not know. That's to say,I can not use something like this: <pre><code>if(props[i]=null) props[i]=0; m.put(properties[i], props[i]); </code></pre> Since the type of props[i] may be string,in this case if its value is null, it should be "". So I wonder if I can sepcify the converting type in the hql words? maybe someting like this: <blockquote> select count(distinct ip), (long) sum(bytes) from Entity en where .... select count(distinct ip),(converet ..sum(bytes)) from Entity en where .... </blockquote> Is this possible? BWT,I use mysql 5.1. Thanks. UPDATE: @zinan.yumak: Your answer seems like this; <pre><code>select new Wrapper(count(distinct ip),sum(bytes)) from Entity en where... </code></pre> If so I have to create enougth extra class like Wrapper since there are so many types of select in my appliction.like: <pre><code>select new AnotherWrapper(broswer,count(distinct brower)) from Entity en where... ...... </code></pre>
Tags
<java><hibernate><hql><type-conversion>
Title
can I specify the return type in the hql words
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. UShguser
UserOwnerUserId
1. UShguser
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.