Problem Urgent about sql

far56 · **Joined:** Thu Feb 05, 2004 9:09 am **Posts:** 27

Can I create sql instructions without mapping table in Hibernate.
Example:

I have a table call "TB_PESSOA" and some atributes like "CD_PESSOA", "NM_PESSOA", "DT_NASCIMENTO".

And I wanna do this sql:

SELECT * FROM TB_PESSOA

or specified some static or dinamic condicions

SELECT * FROM TB_PESSOA WHERE CD_PESSOA = {} AND NM_PESSOA = 'GOMES'

WHO CAN I DO THIS?
THANKS.

anthony · **Posted:** Thu Mar 11, 2004 10:48 am

the question is, what do you want to do with the result? send it to your presentation layer?

far56 · **Joined:** Thu Feb 05, 2004 9:09 am **Posts:** 27

I wanna get some atributes without mapping table in Hibernate.
Because this table is a view on Oracle and I don

anthony · **Posted:** Thu Mar 11, 2004 11:03 am

just do List result = session.find (SELECT A,B FROM TB_PESSOA )
this will return a list of Object[]
for example if A is a Varchar and B a Number

so Objet[] myResult = (Objet[] )result.get(0) (= 1st row)
myResult[0] --> is A ...
so you can do
myA = (String)myResult[0]
myB = (Integer)myResult[1]

This will work

far56 · **Joined:** Thu Feb 05, 2004 9:09 am **Posts:** 27

Thank you guy, but if I do this happend this:

net.sf.hibernate.QueryException: undefined alias: TB_PESSOA [ SELECT TB_PESSOA.CD_PESSOA FROM TB_PESSOA ]

Remeber TB_PESSOA can

anthony · **Posted:** Thu Mar 11, 2004 1:09 pm

do you have some sql generated?

far56 · **Joined:** Thu Feb 05, 2004 9:09 am **Posts:** 27

This is error:

net.sf.hibernate.QueryException: undefined alias: TB_PESSOA [ SELECT TB_PESSOA.CD_PESSOA FROM TB_PESSOA ]

This is my source:

List lista = session.find(" SELECT p.CD_PESSOA FROM TB_PESSOA p");

pierre-yves · **Posted:** Thu Mar 11, 2004 1:26 pm

If the Table TB_PESSOA is not mapped to any object what is the point to use Hibernate instead of plain JDBC.
Anyway, from the doc, Hibernate needs the alias to the mapped class, even with the SQLQuery methods.

http://www.hibernate.org/hib_docs/reference/html/query-sql.html#query-sql-s1

Quote:

The three parameters provided to createSQLQuery() are:

*

the SQL query string
*

a table alias name
*

the persistent class returned by the query

The alias name is used inside the sql string to refer to the properties of the mapped class (in this case Cat). You may retrieve multiple objects per row by supplying a String array of alias names and a Class array of corresponding classes.

far56 · **Joined:** Thu Feb 05, 2004 9:09 am **Posts:** 27

My full source using hibernate mapping except this table, can

far56 · **Joined:** Thu Feb 05, 2004 9:09 am **Posts:** 27

Please help me anyone!

christian · **Posted:** Fri Mar 12, 2004 8:30 am

You can't use Hibernate without mapping a table with Hibernate. You may use direct SQL/JDBC by calling session.connection().

baliukas · **Posted:** Fri Mar 12, 2004 8:31 am

Statement s = session.connection().createStatement(" SELECT p.CD_PESSOA FROM TB_PESSOA p");