java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml | 7 +++----
1 file changed, 3 insertions(+), 4 deletions(-)
New commits:
commit 3920241d797a7def82f97ea13ef28c0784059382
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Mon Oct 4 15:34:55 2010 +0200
Replace Oracle outer join syntax with ANSI syntax for Channel.findAllBaseChannels.
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
com.redhat.rhn.common.hibernate.HibernateFactory.listObjectsByNamedQuery(HibernateFactory.java:265)
at
com.redhat.rhn.common.hibernate.HibernateFactory.listObjectsByNamedQuery(HibernateFactory.java:206)
at
com.redhat.rhn.domain.channel.ChannelFactory.listAllBaseChannels(ChannelFactory.java:966)
at
com.redhat.rhn.manager.channel.ChannelManager.findAllBaseChannelsForOrg(ChannelManager.java:2408)
at
com.redhat.rhn.frontend.action.channel.manage.EditChannelAction.prepDropdowns(EditChannelAction.java:621)
at
com.redhat.rhn.frontend.action.channel.manage.EditChannelAction.setupForm(EditChannelAction.java:535)
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 5037729..9f845c6 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
@@ -163,11 +163,10 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
-->
<sql-query name="Channel.findAllBaseChannels">
<![CDATA[SELECT {c.*}
- FROM rhnChannel {c},
- rhnUserChannel uc,
- rhnChannelCloned c_1_
+ FROM rhnUserChannel uc,
+ rhnChannel {c} left outer join rhnChannelCloned c_1_
+ ON c.id = c_1_.id
WHERE c.id = uc.channel_id
- AND c.id = c_1_.id (+)
AND uc.org_id = :org_id
AND uc.user_id = :user_id
AND uc.role = 'subscribe'
Show replies by date