hibernate-devel

[Hibernate] Oracle error

[Matt R. <mat...@ca...>]

I am trying to use Hibernate to connect to Oracle.  I was using MySQL -
where everything worked.  All I've changed (so far) was the tablename from
"user" to "cct_user".  Now I'm getting the following error:

   [junit] Testcase:
testGetUser(com.cable.comcast.dmc.itd.cct.persistence.ApplicationDAOHibernat
eTest):     Caused an ERROR
    [junit] java.sql.SQLException: ORA-00923: FROM keyword not found where
expected

    [junit] com.cable.comcast.dmc.itd.cct.persistence.DAOException:
java.sql.SQLException: ORA-00923: FROM keyword not found where expected


I'm guessing there's something wrong with this code:

List users = (List) ses.find("from user in class
com.cable.comcast.dmc.itd.cct.persistence.User where username=?",
name, Hibernate.STRING);

Thanks,

Matt

Re: [Hibernate] Oracle error

[Mark W. <mor...@SM...>]

Matt Raible wrote:

>I am trying to use Hibernate to connect to Oracle.  I was using MySQL -
>where everything worked.  All I've changed (so far) was the tablename from
>"user" to "cct_user".  Now I'm getting the following error:
>
>   [junit] Testcase:
>testGetUser(com.cable.comcast.dmc.itd.cct.persistence.ApplicationDAOHibernat
>eTest):     Caused an ERROR
>    [junit] java.sql.SQLException: ORA-00923: FROM keyword not found where
>expected
>
>    [junit] com.cable.comcast.dmc.itd.cct.persistence.DAOException:
>java.sql.SQLException: ORA-00923: FROM keyword not found where expected
>
>
>I'm guessing there's something wrong with this code:
>
>List users = (List) ses.find("from user in class
>com.cable.comcast.dmc.itd.cct.persistence.User where username=?",
>name, Hibernate.STRING);
>  
>

I believe it will work if you change that statement to "from usr in 
class c.c.c.d.i.c.p.User where usr.username=?".

The first problem is "user" is a keyword in Oracle.  The second problem 
is that you need to specify where username is coming from.

Gavin, perhaps this should be a FAQ?  I think I've seen this question a 
couple times before in the forums.

-Mark