File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes HQL query problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL query problem" Watch "HQL query problem" New topic
Author

HQL query problem

Dmitry Shekhter
Greenhorn

Joined: Feb 21, 2001
Posts: 26
Hi guys,

I've got simple Hibernate query that i can't get to work.
The problem is that I need to be able to specify a schema name in my query, because later I will be joining to a table in a different query.

Below is a snippet of the code containing my query:

Query q = session.createQuery(
"select my_column from myschema.mytable a where a.ID = :id");

When the code runs, i get an error saying net.sf.hibernate.QueryException: undefined alias: myschema
It looks like Hibernate is treating my schema name as an alias.

Am I missing something with the syntax?

Thanks in advance.

D.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HQL query problem
 
Similar Threads
Preventing the hard-coding of an annotation
Index Error (Oracle)
could not deserialize
Problem with JPA Embeddable class field in Embedded
Preventing the hard-coding of an annotation