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.

ORA-01502 Oracle Index in Unusable State

As I execute sql statement to do search, it return this message unexpectedly:ORA-01502: index 'RSDB.RESUME_PK' or partition of such index is in unusable state

Solution: rebuild this index

ALTER INDEX RESUME_PK REBUILD

After I executed this rebuild action, it turned out to be normal.

Reference
[1] http://www.mydigitallife.info/2006/01/28/ora-01502-oracle-index-in-unusable-state/

Template method pattern example

http://www.slideshare.net/junyuo/template-method-pattern-example

Utilize Quartz to Implement Scheduling Service

Scenario


Implementation Process


http://www.slideshare.net/junyuo/utilize-quartz-to-implement-scheduling-service

PMD

PMD scans Java source code and looks for potential problems like:

• Possible bugs - empty try/catch/finally/switch statements
• Dead code - unused local variables, parameters and private methods
• Suboptimal code - wasteful String/StringBuffer usage
• Overcomplicated expressions - unnecessary if statements, for loops that could be while loops
• Duplicate code - copied/pasted code means copied/pasted bugs

It can be plug-in to Eclipse, NetBeans, etc.

http://pmd.sourceforge.net/

Utilize Jericho HTML Parser to Resolve NCR Problem

Agenda

• What is NCR (Numeric Character Reference) ?
• Scenario Description
• Problem (XML with NCR)
• Resolution Process
• Result (NCR had been decoded)
  

http://www.slideshare.net/junyuo/utilize-jericho-html-parser-to-resolve-ncr-problem

XML Utility: Convert DTD to XML Schema

http://www.hitsw.com/xml_utilites/

Problems running dot: exit code=-1, command='dot'

As I used Doxygen to generate source code docuemt, I failed to generate graphs and got this kind of error message: 

Problems running dot: exit code=-1, command='dot', arguments='"classcom_1_1htc_1_1hr_1_1tree_1_1_department_table_bean_50f82c9386b01669779a1524b380b355_cgraph.dot" -Tpng -o "classcom_1_1htc_1_1hr_1_1tree_1_1_department_table_bean_50f82c9386b01669779a1524b380b355_cgraph.png"'

I spent lots of time to resolve this odd issue, and found out its result from the wrong GraphViz version. I cannot use the latest version. As I tried graphviz-2.12.exe this version, all problems were gone. You can go to here to download this verion: http://www.graphviz.org/pub/graphviz/stable/windows/

Here is class hierarchy:


Here is call graph:

Applied Apache Trinidad to show organization chart

Technology: Apache Trinidad, JPA

Web Container: Glassfish

Demo
1. enter personnel request application form page


2. launch popup window to show the organization chart


3. return the selected department back to original page


sequence diagram



trinidad page -- caller page


trinidad page -- popup window



PersonnelRequestController


DepartmentTableBean




you can also check the developer guide for futher information: http://myfaces.apache.org/trinidad/devguide/tree.html

java.sql.SQLException: OALL8 is in an inconsistent state

Technology: Apache Trinidad, JPA

Web Container: glassfish

Database: Oracle 10g

Scenario: As I execute some functions, then it will get this error message
[#|2009-02-03T11:22:52.620+0800|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=httpSSLWorkerThread-8080-1;|[TopLink Warning]: 2009.02.03 11:22:52.620--UnitOfWork(2726974)--Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/11/2008))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: OALL8 is in an inconsistent state
Error Code: 17447
Call: SELECT ID, JOB_LOC_ENG_DESC, JOB_LOC_INFORM_ENG_DESC, DOMAIN, IS_JOB_LOC, CREATETIMESTAMP, IS_INTERVIEW_LOC, JOB_LOC_NATIVE_DESC, IS_ONBOARD_LOC, JOB_LOC_INFORM_NATIVE_DESC, JOB_LOCATION_CODE, MODIFYTIMESTAMP, MODIFIER, CREATOR FROM RSDB.JOB_LOCATION WHERE (ID = ?)
bind => [22612]
Query: ReadObjectQuery(com.htc.hr.entity.JobLocation)
|#]


Root Cause: I put collection object into hashCode function, it's the root cause to cause this error. Just remove it.

Set up a simple way to backup testing server database

1. write an ant build file to generate dump file and copy to remote machine (on a daily basis)
















2. create a batch file to execute my build script

3. add this batch file to scheduler service


4. result
[local machine]


[remote machine]