Error in creating alias in formula tag

Posted by Senthilnathan on Stack Overflow See other posts from Stack Overflow or by Senthilnathan
Published on 2010-02-22T05:47:17Z Indexed on 2010/05/02 16:57 UTC
Read the original article Hit count: 258

Filed under:

hibernate

|

orm

|

java

Hi all

I have a sql query in formula tag inside property tag.

In that query i am creating alias name but the hibernate appends table name and throwing me error.

select sum(e.salary) as sal from employee e

but hibernate changes to

select sum(e.salary) as employee.sal from employee e

how to avoid this ....

it should recognise as sal inside of employee.sal !!!

© Stack Overflow or respective owner

Related posts about hibernate

Hibernate unable to instantiate default tuplizer - cannot find getter

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to use Hibernate to persist a class that looks like this: public class Item implements Serializable, Comparable<Item> { // Item id private Integer id; // Description of item in inventory private String description; // Number of items described by this inventory item private int… >>> More
Hibernate + PostgreSQL : relation does not exist - SQL Error: 0, SQLState: 42P01

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am having some problems trying to work with PostgreSQL and Hibernate, more specifically, the issue mentioned in the title. I've been searching the net for a few hours now but none of the found solutions worked for me. I am using Eclipse Java EE IDE for Web Developers. Build id: 20090920-1017… >>> More
Problem connecting to Hsqldb via Hibernate when running a Eclipse GWT project.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to run a simple GWT project where I'm trying to do a simple persitence via hibernate to a HSQLDB database. The database I'm using I have been using for at least 2 years with several osgi applications without any problems. So all I done is reused the same configuration and added a simple… >>> More
Hibernate : load and

as seen on Stack Overflow - Search for 'Stack Overflow'
According to the tutorial : http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=27hibernateloadvshibernateget, If you initialize a JavaBean instance with a load method call, you can only access the properties of that JavaBean, for the first time, within the transactional context in which it… >>> More
Hibernate Exception, what wrong ? [[Exception in thread "main" org.hibernate.InvalidMappingException

as seen on Stack Overflow - Search for 'Stack Overflow'
I use netbean 6.7.1 to write "hello world" witch hibernate, but I get some errors, plz help me, thank you very much. my exception init: deps-module-jar: deps-ear-jar: deps-jar: Copying 1 file to F:\Documents and Settings\My Dropbox\DropboxNetBeanProjects\loginspring\build\web\WEB-INF\classes compile-single: run-main: Oct… >>> More

Related posts about orm

Optimizations employed by ORM's

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm teaching JEE, especially JPA, Spring and Spring MVC. As I have not so much experience in large projects, it is difficult to know what to present to students about optimisation of ORM. At the present time, I present some classic optimisation tricks: prepared statements (most of ORM implicitely… >>> More
Which ORM to use with SQL Azure?

as seen on Stack Overflow - Search for 'Stack Overflow'
Just wondering what everyones thoughts on what ORM to use for SQL Azure? I'm fairly comfortable using LINQ-to-SQL and I believe it is possible to get it working with SQL Azure. However, from my understanding (correct me if I'm wrong), no further improvements will be made to Linq-to-SQL in future… >>> More
PHP Doctrine ORM NestedSet

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, although I read through the manual here: http://www.doctrine-project.org/documentation/manual/1_2/hu/hierarchical-data I couldn't find a way to move a node from a Leaf to become a Root node. Any clues? The question is trivial for inserting a new node...but what about updating a node? >>> More
PHP PSR-0 + several namespaces in one file and autoload

as seen on Programmers - Search for 'Programmers'
I've been thinking for a while about defining several namespaces in one php file and so, having several classes inside this file. Suppose, I want to implement something like Doctrine\ORM\Query\Expr: Expr.php Expr |-- Andx.php |-- Base.php |-- Comparison.php |-- Composite.php |-- From.php |-- Func… >>> More
FOSUserBundle override mapping to remove need for username

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to remove the need for a username in the FOSUserBundle. My users will login using an email address only and I've added real name fields as part of the user entity. I realised that I needed to redo the entire mapping as described here. I think I've done it correctly but when I try to submit… >>> More