Default schema is not added to native SQL

Michiel · **Joined:** Tue Jul 29, 2008 10:09 am **Posts:** 3

Hi,

When I do a native SQL query I have to add the schema name, so I have to do:
sess.createSQLQuery("SELECT * FROM [schema name].[table name]")

I have set a default_schema in my properties file. Is there a way that this default schema name is added?

Thanks, Michiel

Cameron McKenzie · **Posted:** Wed Jul 30, 2008 7:54 am

Well, you really probably want to do an HQL query, don't you?

If you're going to the trouble of setting up Hibernate, doing an SQL query is a bit of a step backwards.

Look at this tutorial on mastering HQL and Hibernate Queries:

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=08masteringhqlandnamedqueries

If you had a Java class POJO named User, you might do an HQL query like this:

Code:

Session session = HibernateUtil.beginTransaction();
String loginName = "mj";
String hql="from User where loginName = :name";
Query query = session.createQuery(hql);
query.setString("name", loginName);
Object o = query.uniqueResult();
User user = (User)o;
System.out.println(user.getLoginName());
HibernateUtil.commitTransaction();

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=08masteringhqlandnamedqueries

Michiel · **Joined:** Tue Jul 29, 2008 10:09 am **Posts:** 3

If I would build a new application I would of course use HQL or criterias. However I am migrating an EJB entity/session bean application to Hibernate and Spring and we have a lot of SQL queries which we do not want to migrate. Therefore I want to execute the SQL, which is working fine except for the schema name that must be added in the sql. A sollution for this problem would be very nice.