Author: eric Date: Thu Apr 7 04:17:22 2011 New Revision: 1089731 URL: http://svn.apache.org/viewvc?rev=1089731&view=rev Log: Rename JPA table and queries for RRT - Previous generated database need rename JAMES_VIRTUAL_USER_TABLE table to JAMES_RECIPIENT_REWRITE (JAMES-1218)
Modified: james/server/trunk/jpa/src/main/java/org/apache/james/rrt/jpa/model/JPARecipientRewrite.java Modified: james/server/trunk/jpa/src/main/java/org/apache/james/rrt/jpa/model/JPARecipientRewrite.java URL: http://svn.apache.org/viewvc/james/server/trunk/jpa/src/main/java/org/apache/james/rrt/jpa/model/JPARecipientRewrite.java?rev=1089731&r1=1089730&r2=1089731&view=diff ============================================================================== --- james/server/trunk/jpa/src/main/java/org/apache/james/rrt/jpa/model/JPARecipientRewrite.java (original) +++ james/server/trunk/jpa/src/main/java/org/apache/james/rrt/jpa/model/JPARecipientRewrite.java Thu Apr 7 04:17:22 2011 @@ -32,12 +32,12 @@ import javax.persistence.Table; * RecipientRewriteTable class for the James Virtual User Table to be used for JPA * persistence. */ -@Entity(name = "JamesRecipientRewriteTable") -@Table(name = "JAMES_VIRTUAL_USER_TABLE") -@NamedQueries({ @NamedQuery(name = "selectMappings", query = "SELECT vut FROM JamesRecipientRewriteTable vut WHERE (vut.user LIKE :user OR vut.user='*') and (vut.domain like :domain or vut.domain='*') ORDER BY vut.domain DESC"), - @NamedQuery(name = "selectUserDomainMapping", query = "SELECT vut FROM JamesRecipientRewriteTable vut WHERE vut.user=:user AND vut.domain=:domain"), @NamedQuery(name = "selectAllMappings", query = "SELECT vut FROM JamesRecipientRewriteTable vut"), - @NamedQuery(name = "deleteMapping", query = "DELETE FROM JamesRecipientRewriteTable vut WHERE vut.user=:user AND vut.domain=:domain AND vut.targetAddress=:targetAddress"), - @NamedQuery(name = "updateMapping", query = "UPDATE JamesRecipientRewriteTable vut SET vut.targetAddress=:targetAddress WHERE vut.user=:user AND vut.domain=:domain") }) +@Entity(name = "JamesRecipientRewrite") +@Table(name = "JAMES_RECIPIENT_REWRITE") +@NamedQueries({ @NamedQuery(name = "selectMappings", query = "SELECT rrt FROM JamesRecipientRewrite rrt WHERE (rrt.user LIKE :user OR rrt.user='*') and (rrt.domain like :domain or rrt.domain='*') ORDER BY rrt.domain DESC"), + @NamedQuery(name = "selectUserDomainMapping", query = "SELECT rrt FROM JamesRecipientRewrite rrt WHERE rrt.user=:user AND rrt.domain=:domain"), @NamedQuery(name = "selectAllMappings", query = "SELECT rrt FROM JamesRecipientRewrite rrt"), + @NamedQuery(name = "deleteMapping", query = "DELETE FROM JamesRecipientRewrite rrt WHERE rrt.user=:user AND rrt.domain=:domain AND rrt.targetAddress=:targetAddress"), + @NamedQuery(name = "updateMapping", query = "UPDATE JamesRecipientRewrite rrt SET rrt.targetAddress=:targetAddress WHERE rrt.user=:user AND rrt.domain=:domain") }) @IdClass(JPARecipientRewrite.RecipientRewriteTableId.class) public class JPARecipientRewrite { --------------------------------------------------------------------- To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org For additional commands, e-mail: server-dev-h...@james.apache.org