java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml | 5 ++---
1 file changed, 2 insertions(+), 3 deletions(-)
New commits:
commit 425e61320b085945d91973b3da990fe26361c718
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Oct 5 13:42:59 2010 +0200
Replace Oracle outer join syntax with ANSI syntax for Channel.findByIdAndUserId.
Addressing
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
at
com.redhat.rhn.domain.channel.ChannelFactory.lookupByIdAndUser(ChannelFactory.java:92)
at
com.redhat.rhn.manager.channel.ChannelManager.lookupByIdAndUser(ChannelManager.java:735)
at
com.redhat.rhn.frontend.action.channel.manage.EditChannelAction.setupForm(EditChannelAction.java:539)
at
com.redhat.rhn.frontend.action.channel.manage.EditChannelAction.execute(EditChannelAction.java:89)
diff --git a/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml
b/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml
index 9f845c6..8909b13 100644
--- a/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml
+++ b/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml
@@ -187,10 +187,9 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
<sql-query name="Channel.findByIdAndUserId">
<![CDATA[SELECT {c.*}
- FROM rhnChannel {c},
- rhnChannelCloned c_1_
+ FROM rhnChannel {c} left outer join rhnChannelCloned c_1_
+ ON c.id = c_1_.id
WHERE c.id = :cid
- AND c.id = c_1_.id (+)
AND (rhn_channel.user_role_check(c.id, :userId, 'subscribe') = 1
OR
rhn_channel.user_role_check(c.id, :userId, 'manage') = 1)
]]>
<return alias="c"
class="com.redhat.rhn.domain.channel.Channel" />
Show replies by date