Hi All,
I'm new of this forum an I want to thanks in advance every one who could help me.
I'm using
Hibernate 3.6
jtds 1.2.7
SQLserver database
I crate my custom dialect, registering the convert function as to_date as follow:
public class MySQLServerDialect extends org.hibernate.dialect.SQLServerDialect{
Code:
public SQLServerDialect() {
super();
registerFunction("TO_DATE", new SQLFunctionTemplate(StandardBasicTypes.DATE, "Convert(DATETIME, ?1 ,112)"));
}
The function works correctly in HQL when it is in where clause, see example as follow
Code:
from MyObject o
where to_date(o.firstDate) < :date
Otherwise I've aproblem when I use it as follow:
Code:
select new map(to_date(o.firstDate) as myDate)
from MyObject o
here is the stacktrace I get when hibernate try to instantiate the session factory:
Code:
ERROR it.netechgroup.discoveryleasing.ImportLeasing.perform() - java.lang.NullPointerException
java.lang.NullPointerException
at org.hibernate.hql.NameGenerator.generateColumnNames(NameGenerator.java:46)
at org.hibernate.hql.ast.util.SessionFactoryHelper.generateColumnNames(SessionFactoryHelper.java:410)
at org.hibernate.hql.ast.tree.SelectClause.initializeColumnNames(SelectClause.java:257)
at org.hibernate.hql.ast.tree.SelectClause.finishInitialization(SelectClause.java:247)
at org.hibernate.hql.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:242)
at org.hibernate.hql.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:852)
at org.hibernate.hql.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:640)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:685)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:547)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:411)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1842)
Any help would be apreciated, many thanks