I changed it to use this error and I'm still getting the same error. I'm guessing that my table name is irrelevant as long as it's in the User.hbm.xml file.
Is there anyway to turn on debugging so I can see the SQL being sent? Thanks, Matt -----Original Message----- From: Gavin King [mailto:[EMAIL PROTECTED] Sent: Friday, December 20, 2002 3:57 PM To: Raible, Matt Cc: [EMAIL PROTECTED] Subject: RE: [Hibernate] Oracle error Correct QL syntax is: from user in class com.cable.comcast.dmc.itd.cct.persistence.User where user.username=? :) > -----Original Message----- > From: Matt Raible [mailto:[EMAIL PROTECTED] > Sent: Saturday, 21 December 2002 6:21 AM > To: [EMAIL PROTECTED] > Subject: [Hibernate] Oracle error > > > 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.Applicat > ionDAOHibernat > 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 > > > > ------------------------------------------------------- > 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 [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > ********** 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. 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 ********** ------------------------------------------------------- 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 [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
