nHibenrate Exception: Unable to locate appropriate constructor on class [Persistence.vo.CaseTypeReportBean, Persistence]

I'm using aggregate functions in my HQL, it looks like this

and the CaseTypeReportBean is as bellowing

But as I run this function, system report this error message: Unable to locate appropriate constructor on class [Persistence.vo.CaseTypeReportBean, Persistence] [select new CaseTypeReportBean(t1.caseType, count(t1)) from Persistence.vo.Cases t1 group by t1.caseType]

It results from the inappropriate data type for CaseTypeReportBean constructor

Hence, I modify the constructor just like this(from int to Int64), then it works now

Reference: https://www.hibernate.org/407.html#A22

nHibernate Query

Check out this SlideShare Presentation:

nHibernate Query

View more presentations from Guo Albert.

Cannot find hibernate.cfg.xml file

Problem
As I startup IIS and run my asp .net program, it reported this error meesage to complain it cannot find hibernate.cfg.xml file:
2009-10-12 10:01:23,250 ERROR TCePolice.CaseList.Page_Load(D:\work\source\TCePolice\TCePolice\CaseList.ascx.cs:48) - NHibernate.Cfg.HibernateConfigException: An exception occurred during configuration of persistence layer. ---> System.IO.FileNotFoundException: 找不到檔案 'D:\work\source\TCePolice\TCePolice\bin\hibernate.cfg.xml'。

Solution
Edit hibernate.cfg.xml file's property, Copy to Output Directory, and set its value to Copy if newer.

IE8 Compatibility View

In some pages, IE 8 may not work correctly. Ex.


But it's working in IE6 & IE7.
Therefore, you need to turn on the compatibility view in IE8 to resolve this problem.


But it doesn't make sense to ask user to do this.
So this article will guide you to resolve this problem.
Here has two solutions:
1. Add mimic Internet Explorer 7 tag to your header in each page.

2. Configure web.config (I don't know why this approach does not work in my application)


Owing to we use master pages to provide a template page in our application.
Therefore, we just add Mimic Internet Explorer 7 tag into its header. Then it will apply to all pages.

What is Master Pages?
Master pages are an easy way to provide a template that can be used by any number of ASP.NET pages in your application.



Introducing Compatibility View:
http://blogs.msdn.com/ie/archive/2008/08/27/introducing-compatibility-view.aspx
META Tags and Locking in Future Compatibility:
http://msdn.microsoft.com/zh-tw/library/cc817574%28en-us%29.aspx

nHibernate Log Isolation

Check out this SlideShare Presentation:

nHibernate Log Isolation

View more presentations from Guo Albert.

nHibernate Caching

Check out this SlideShare Presentation:

nHibernate Caching

View more presentations from Guo Albert.

NHibernate for .NET

Check out this SlideShare Presentation:

NHibernate for .NET

View more presentations from Guo Albert.

nHibernate Explained by example

Check out this SlideShare Presentation:

nHibernate Explained by example

View more documents from Guo Albert.

NHibernate 常見問題

包含

• hbm.xmlNHibernate文件中版本号可能引起的问题.
• 在对照类中如果属性没有加virtual关键字
• 映射文件没有将属性设为＂嵌入的资源＂引起的错误．
• "Could not find the dialect in the configuration"异常
• "未能未能加载文件或程序集Castle.DynamicProxy2"的异常
  

http://zhangrh1008.spaces.live.com/blog/cns!A5242842A85F6A16!171.entry?sa=47445455

NHibernate.MappingException: No persister for: HelloNHibernate.vo.People

I am testing NHibnernate these days, but I get this kind of error message NHibernate.MappingException: No persister for: HelloNHibernate.vo.People

The cs name, package name are correct, but the console still report this error message.

Finally, I found out the root cause: all mapping files should be set Embedded Resource, then it can execture correctly.

right-click in XXX.hbm.xml->Properties->Build Action="Embedded Resource"

Telerik Reporting– Quick Start (Part 2)

Check out this SlideShare Presentation:

Telerik Reporting– Quick Start (Part 2)

View more presentations from Guo Albert.

Telerik Reporting– Quick Start (Part 1)

Check out this SlideShare Presentation:

Telerik Reporting– Quick Start (Part 1)

View more presentations from Guo Albert.

Quartz.NET - Enterprise Job Scheduler for .NET Platform

Check out this SlideShare Presentation:

Quartz.NET - Enterprise Job Scheduler for .NET Platform

View more presentations from Guo Albert.

Logging Services for .net - log4net

Check out this SlideShare Presentation:

Logging Services for .net - log4net

View more presentations from Guo Albert.

RandomAccessFile Quick Start

Check out this SlideShare Presentation:

RandomAccessFile Quick Start

View more presentations from Guo Albert.

Rule Engine: Drools .Net

Check out this SlideShare Presentation:

Rule Engine: Drools .Net

View more presentations from Guo Albert.

GridBagLayout Quick Start

Check out this SlideShare Presentation:

GridBagLayout Quick Start

View more OpenOffice presentations from Guo Albert.

JPA Code Generation via MyEclipse

Check out this SlideShare Presentation:

JPA Code Generation via MyEclipse

View more OpenOffice presentations from Guo Albert.

A Short Java Socket Tutorial

Check out this SlideShare Presentation:

A Short Java Socket Tutorial

View more OpenOffice presentations from Guo Albert.

SchemaSpyGUI Quick Start

http://www.slideshare.net/junyuo/schemaspygui-quick-startppt

A Short Java RMI Tutorial

http://www.slideshare.net/junyuo/a-short-java-rmi-tutorial

和四種主管溝通的小秘訣

溝通秘訣1：駕馭型--搞定老虎主管
老虎型主管注重結果導向，他就事論事並且有冒險精神。而且老虎主管通常速度很快，與他溝通要直接說重點。

溝通秘訣2：表達型--孔雀主管
與孔雀主管可以多聊家常事務，先建立個人感情再談公事會更為順利，孔雀主管非常有創意，不喜歡太死板的教條。

溝通秘訣3：親和型--無尾熊主管
無尾熊主管重視團隊的和諧氣氛、不喜歡風險，與無尾熊主管溝通要溫和，並且給他多一點決策時間。

溝通秘訣4：分析型--貓頭鷹主管
貓頭鷹主管重視品質，給他的資料要精確、有邏輯。屬下工作要按照一定步驟，並且要注意細節要正確。

http://www.cw.com.tw/article/index.jsp?id=2910

可惜他沒提到無能型的

ORA-00932: inconsistent datatypes: expected - got CLOB

As I am doing data query with distinct syntax in select clause, I got this error message:
ORA-00932: inconsistent datatypes: expected - got CLOB

This error message result from Clob limitation:

1. CLOBs don't work like strings. You can't ask for the LENGTH of a CLOB column, for example. You can work around this with PL/SQL calls but it isn't much fun.
2. LOBs are not allowed in GROUP BY, ORDER BY, SELECT DISTINCT, aggregates and JOINS

Therefore, I re-designed my database schema. Save this CLOB column into another table.