<sql-query name="destinationForPort">
    <return alias="destination" class="Location"/>
       SELECT {destination}.DABBR AS {destination.abbreviation},
                 {destination}.DNAME AS {destination.name}
       FROM DESTINATION {destination}, PORTS_FOR_DESTINATION {ports_destinations}
       WHERE {destination}.DABBR = {ports_destinations}.DABBR
       AND {ports_destinations}.PORT_ID = :portAbbreviation
</sql-query>

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 5: Incorrect syntax near '{'.
   at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
   at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
   at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
   at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
   at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
   at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
   at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
   at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
   at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
   at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
   at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
   at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
   at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
   at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
   at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:800)
   at net.sf.hibernate.loader.Loader.doQuery(Loader.java:189)
   at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
   at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
   at net.sf.hibernate.loader.Loader.list(Loader.java:946)
   at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92)
   at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3802)
   at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)

SELECT destination.DABBR AS dabbr0_, destination.DNAME AS dname0_ FROM DESTINATION destination, PORTS_FOR_DESTINATION {ports_destinations} WHERE destination.DABBR = {ports_destinations}.DABBR AND {ports_destinations}.PORT_ID = ?

<sql-query name="destinationForPort">
    <return alias="destination" class="Location"/>
       SELECT {destination}.DABBR AS {destination.abbreviation},
                 {destination}.DNAME AS {destination.name}
       FROM DESTINATION {destination}, PORTS_FOR_DESTINATION somealias
       WHERE {destination}.DABBR = somealias.DABBR
       AND somealias.PORT_ID = :portAbbreviation
</sql-query>