Don't get JOIN work'in - "unexpected token"

leethacker · **Joined:** Tue May 31, 2005 5:36 pm **Posts:** 21

Guys, I have the following problem:

I'd like to do a Query with a JOIN over 2 Tables.

When I perform the query with the HSQL Database Manager, everything works fine:

Code:

SELECT * FROM kunde k JOIN ticketcard t ON t.kartennr = k.kartennr WHERE t.vname LIKE 'Morgan' AND t.nname LIKE 'Breitfuss' AND k.kartennr = 8;

But if I try the same query in my own Java code, the only thing I get is the following Unexpected Token Exception. :cry:

Code:

              Session session = HibernateSessionFactory.currentSession();
              //List vlist = session.find("FROM Veranstaltung WHERE Dauer >= 112 ORDER BY Dauer ASC");
                 session.find("SELECT * FROM kunde JOIN ticketcard ON ticketcard.kartennr = kunde.kartennr WHERE ticketcard.vname LIKE 'Morgan' AND ticketcard.nname LIKE 'Breitfuss' AND kunde.kartennr = 8");

Code:

java.lang.RuntimeException: unexpected token: join [SELECT * FROM kunde JOIN ticketcard ON ticketcard.kartennr = kunde.kartennr WHERE ticketcard.vname LIKE 'Morgan' AND ticketcard.nname LIKE 'Breitfuss' AND kunde.kartennr = 8]
    at ticketline.WebAccount$1.widgetSelected(WebAccount.java:153)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:842)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2908)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2541)
    at ticketline.MainApp1.open(MainApp1.java:736)
    at ticketline.MainApp1.runMain(MainApp1.java:103)
    at ticketline.Login1$2.widgetSelected(Login1.java:139)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:842)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2908)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2541)
    at ticketline.Login1.open(Login1.java:216)
    at ticketline.Login1.main(Login1.java:61)

Can someone explain what I did wrong? I don't see any fault in my code ...

------------------
Hibernate version: 2

vgiguere · **Posted:** Tue May 31, 2005 5:59 pm

HQL Examples that I see always use alias... maybe it is required:

try:

FROM kunde as kun JOIN ticketcard as tick ON tick.kartennr = kun.kartennr WHERE tick.vname LIKE 'Morgan' AND tick.nname LIKE 'Breitfuss' AND kun.kartennr = 8

Let me know if it works
Good luck,

leethacker · **Joined:** Tue May 31, 2005 5:36 pm **Posts:** 21

vgiguere wrote:

FROM kunde as kun JOIN ticketcard as tick ON tick.kartennr = kun.kartennr WHERE tick.vname LIKE 'Morgan' AND tick.nname LIKE 'Breitfuss' AND kun.kartennr = 8

Hummmmm ... unfortunately this is not the solution. Seems that AS is an unexpected token too ...

Code:

java.lang.RuntimeException: unexpected token: as [FROM kunde as kun JOIN ticketcard as tick ON tick.kartennr = kun.kartennr WHERE tick.vname LIKE 'Morgan' AND tick.nname LIKE 'Breitfuss' AND kun.kartennr = 8]
   at ticketline.WebAccount$1.widgetSelected(WebAccount.java:153)
   at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
   at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
   at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:842)
   at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2908)
   at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2541)
   at ticketline.MainApp1.open(MainApp1.java:736)
   at ticketline.MainApp1.runMain(MainApp1.java:103)
   at ticketline.Login1$2.widgetSelected(Login1.java:139)
   at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
   at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
   at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:842)
   at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2908)
   at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2541)
   at ticketline.Login1.open(Login1.java:216)
   at ticketline.Login1.main(Login1.java:61)

vgiguere · **Posted:** Tue May 31, 2005 6:06 pm

kunde is your table name or your entity name?