SQL syntax error in Hibernate request

hanihill · **Joined:** Mon Feb 25, 2008 6:32 am **Posts:** 2

Hello

I'm trying to do a basic

Code:

SELECT * FROM database_schema.table_name

To do such a thing, i use the hibernate loadAll (). I created the TableName class using a reverse engineering. And i call the loadAll() from the class TableNameDao.

I get an org.hibernate.exception.SQLGrammarException : could not execute query.

it says that the following request contains a SQL syntax error

Code:

select column1, column2, ... from database_name.database_schema.table_name

I'm pretty sure that without the database_name in the request, i would work

Code:

select column1, column2, ... from database_schema.table_name

Do anybody have any idea how to tell hibernate not to put the database name in my request.

Thanx

jsimas · **Joined:** Tue Feb 19, 2008 6:48 am **Posts:** 17

What database are you using?

You're using what dialect?

You have to give us more information.

hanihill · **Joined:** Mon Feb 25, 2008 6:32 am **Posts:** 2

I'm using a Informix database.
and the following dialect : org.hibernate.dialect.InformixDialect

I'm a rookie in the hibernate game, so i dont know what kind of info you would need, just ask me

thanx for answering though