<class name="Article" table="ARTICLES">
        <id name="id" column="ARTICLE_ID">
         <generator class="native"/>
        </id>
        <property name="guid" column="GUID" unique="true" />

        <set name="permissionSet">
             <key />
             <many-to-many class="Permission" />
                <loader query-ref="permissionSet" />
        </set>
    </class>

    <sql-query name="permissionSet">
        <load-collection alias="perms" role="Article.permissionSet" />
        SELECT perms.*
        FROM PERMISSIONS perms
        LEFT OUTER JOIN PERMISSION_X_GUID permsx ON perms.PERMISSION_ID = permsx.PERMISSION_ID
        LEFT OUTER JOIN ARTICLES arts ON permsx.GUID = arts.GUID
        WHERE arts.ARTICLE_ID = ?
    </sql-query>

<class name="Permission" table="PERMISSIONS">
        <id name="id" column="PERMISSION_ID">
         <generator class="native"/>
        </id>
        <property name="title" column="TITLE" />
        <property name="plevel" column="PLEVEL" />
       
    </class>

2006-04-13 13:15:46,774 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
2006-04-13 13:15:46,790 DEBUG [org.hibernate.type.LongType] binding '163971' to parameter: 1
2006-04-13 13:15:46,837 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2006-04-13 13:15:46,837 DEBUG [org.hibernate.loader.Loader] result set contains (possibly empty) collection: [Article.permissionSet#163971]
2006-04-13 13:15:46,837 DEBUG [org.hibernate.engine.CollectionLoadContext] uninitialized collection: initializing
2006-04-13 13:15:46,837 DEBUG [org.hibernate.loader.Loader] processing result set
2006-04-13 13:15:46,837 DEBUG [org.hibernate.loader.Loader] result set row: 0
2006-04-13 13:15:46,837 DEBUG [org.hibernate.loader.Loader] result row:
2006-04-13 13:15:46,868 INFO  [org.hibernate.type.LongType] could not read column value from result set: id; Invalid column name
2006-04-13 13:15:46,868 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
2006-04-13 13:15:46,868 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-04-13 13:15:46,868 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
2006-04-13 13:15:46,868 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [SELECT perms.*
        FROM PERMISSIONS perms
        LEFT OUTER JOIN PERMISSION_X_GUID permsx ON perms.PERMISSION_ID = permsx.PERMISSION_ID
        LEFT OUTER JOIN ARTICLES arts ON permsx.GUID = arts.GUID
        WHERE arts.ARTICLE_ID = ?]
java.sql.SQLException: Invalid column name
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
   at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3295)
   at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1914)
   at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1575)
   at org.jboss.resource.adapter.jdbc.WrappedResultSet.getLong(WrappedResultSet.java:338)
   at org.hibernate.type.LongType.get(LongType.java:28)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
   at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
   at org.hibernate.persister.collection.AbstractCollectionPersister.readKey(AbstractCollectionPersister.java:676)
   at org.hibernate.loader.Loader.readCollectionElement(Loader.java:962)
   at org.hibernate.loader.Loader.readCollectionElements(Loader.java:635)
   at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
   at org.hibernate.loader.Loader.doQuery(Loader.java:689)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
   at org.hibernate.loader.Loader.doList(Loader.java:2145)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
   at org.hibernate.loader.Loader.list(Loader.java:2024)
   at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111)
   at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1655)
   at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
   at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
   at org.hibernate.persister.collection.NamedQueryCollectionInitializer.initialize(NamedQueryCollectionInitializer.java:54)
   at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)
   at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
   at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1676)
   at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
   at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
   at org.hibernate.collection.PersistentSet.iterator(PersistentSet.java:138)

SQLQuery sqlQry = openedSession.createSQLQuery(""
                   +"SELECT {c.*}"
                   +" FROM CUSTOMERS {c} WHERE {c}.username='" +getUsername()+ "'" + " AND {c}.password =" +getPassword()+"");