RE: [Hibernate] Oracle error

[Gavin K. <Gav...@ex...>]

set=20

hiberante.show_sql=3Dtrue

or put log4j.properties in the classpath

> -----Original Message-----
> From: Raible, Matt [mailto:Mat...@ca...]=20
> Sent: Saturday, 21 December 2002 10:34 AM
> To: hib...@li...
> Subject: RE: [Hibernate] Oracle error
>=20
>=20
> I changed it to use this error and I'm still getting the same=20
> error.  I'm guessing that my table name is irrelevant as long=20
> as it's in the User.hbm.xml file. =20
>=20
> Is there anyway to turn on debugging so I can see the SQL being sent?
>=20
> Thanks,
>=20
> Matt
>=20
> -----Original Message-----
> From: Gavin King [mailto:Gav...@ex...]
> Sent: Friday, December 20, 2002 3:57 PM
> To: Raible, Matt
> Cc: hib...@li...
> Subject: RE: [Hibernate] Oracle error
>=20
>=20
> Correct QL syntax is:
>=20
> from user in class=20
> com.cable.comcast.dmc.itd.cct.persistence.User=20
> where user.username=3D?
>=20
> :)
>=20
> > -----Original Message-----
> > From: Matt Raible [mailto:mat...@ca...]
> > Sent: Saturday, 21 December 2002 6:21 AM
> > To: hib...@li...
> > Subject: [Hibernate] Oracle error
> >=20
> >=20
> > I am trying to use Hibernate to connect to Oracle.  I was
> > using MySQL - where everything worked.  All I've changed (so=20
> > far) was the tablename from "user" to "cct_user".  Now I'm=20
> > getting the following error:
> >=20
> >    [junit] Testcase:
> > testGetUser(com.cable.comcast.dmc.itd.cct.persistence.Applicat
> > ionDAOHibernat
> > eTest):     Caused an ERROR
> >     [junit] java.sql.SQLException: ORA-00923: FROM keyword=20
> > not found where expected
> >=20
> >     [junit] com.cable.comcast.dmc.itd.cct.persistence.DAOException:
> > java.sql.SQLException: ORA-00923: FROM keyword not found
> > where expected
> >=20
> >=20
> > I'm guessing there's something wrong with this code:
> >=20
> > List users =3D (List) ses.find("from user in class
> > com.cable.comcast.dmc.itd.cct.persistence.User where=20
> > username=3D?", name, Hibernate.STRING);
> >=20
> > Thanks,
> >=20
> > Matt
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > This SF.NET email is sponsored by:  The Best Geek Holiday
> > Gifts! Time is running out!  Thinkgeek.com has the coolest gifts for
> > your favorite geek.   Let your fingers do the typing.   Visit Now.
> > T H I N K G E E K . C O M        http://www.thinkgeek.com/sf/
> > _______________________________________________
> > hibernate-devel mailing list hib...@li...
> > https://lists.sourceforge.net/lists/listinfo/hibernate-devel
> >=20
>=20
>=20
> ********** CAUTION - Disclaimer **********
> This message may contain privileged and confidential
> information. If you are not the intended recipient of this
> message (or responsible for delivery of the message to
> such person) you are hereby notified that any use,
> dissemination, distribution or reproduction of this message
> is prohibited. If you have received this message in error,
> you should destroy it and kindly notify the sender by reply
> e-mail. Please advise immediately if you or your employer
> do not consent to Internet e-mail for messages of this kind.
> Opinions, conclusions and other information in this
> message that do not relate to the official business of
> Expert Information Services Pty Ltd ("The Company")
> shall be understood as neither given nor endorsed by it.
>=20
> The Company advises that this e-mail and any attached
> files should be scanned to detect viruses. The Company
> accepts no liability for loss or damage (whether caused
> by negligence or not) resulting from the use of any
> attached files.
> **EIS******** End of Disclaimer **********
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.NET email is sponsored by:  The Best Geek Holiday Gifts!
> Time is running out!  Thinkgeek.com has the coolest gifts for
> your favorite geek.   Let your fingers do the typing.   Visit Now.
> T H I N K G E E K . C O M        http://www.thinkgeek.com/sf/
> _______________________________________________
> hibernate-devel mailing list
> hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
>=20