Hi ,
After I upgarte to 2.11 as you suggest to solve my order by issue. I start getting this exception it is complettly in different part of the application
the table is defined as follows.
create table medias_by_id(
type TEXT,
id UUID ,
title TEXT,
description TEXT,
pic_320X320 TEXT,
pic_100X100 TEXT,
pic_large TEXT,
image_category UUID,
user_id UUID,
created_date BIGINT,
like_count INT ,
share_count INT,
dislike_count INT,
comment_count INT,
view_count INT,
rating FLOAT,
rating_total FLOAT,
number_of_raring INT,
video_file_name text,
PRIMARY KEY(id)
) ;
and this is the java model for that table
import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import
javax.persistence.Id;
import javax.persistence.Table;
import javax.xml.bind.annotation.XmlRootElement;
import com.audition.dao.model.key.ImagesByDateKey;
import com.impetus.kundera.index.IndexCollection;
import com.impetus.kundera.index.Index;
/**
*/
@Entity
@Table(name = "medias_by_id", schema = "auditionspace@auditionspace_pu")
//@IndexCollection(columns = { @Index(name = "created_by"), @Index(name = "image_category")})
@XmlRootElement(name = "imagesById")
public class ImagesById {
@Id
@Column(name="id")
private UUID id ;
@Column(name="type")
private String type ;
@Column(name="created_date")
private long createdDate ;
@Column(name="user_id")
private UUID userId ;
@Column(name="description")
private String description ;
@Column(name="pic_320x320")
private String pic320X320 ;
@Column(name="pic_100x100")
private String pic100X100 ;
@Column(name="pic_large")
private String picLarge ;
@Column(name="image_category")
private UUID imageCategory ;
@Column(name="like_count")
private int likeCount ;
@Column(name="share_count")
private int shareCount ;
@Column(name="dislike_count")
private int dislikeCount ;
@Column(name="rating")
private float rating ;
@Column(name="rating_total")
private float raingTotal ;
@Column(name="number_of_raring")
private int numberOfRating ;
@Column(name="title")
private String title;
@Column(name="comment_count")
private int commentCount ;
@Column(name="view_count")
private int viewCount ;
@Column(name="video_file_name")
private String videoFileName;
/**
* Method getUserId.
* @return UUID
*/
public UUID getUserId() {
return userId;
}
/**
* Method setUserId.
* @param userId UUID
*/
public void setUserId(UUID userId) {
this.userId = userId;
}
/**
* Method getDescription.
* @return String
*/
public String getDescription() {
return description;
}
/**
* Method setDescription.
* @param description String
*/
public void setDescription(String description) {
this.description = description;
}
/**
* Method getPic320X320.
* @return String
*/
public String getPic320X320() {
return pic320X320;
}
/**
* Method setPic320X320.
* @param pic320x320 String
*/
public void setPic320X320(String pic320x320) {
pic320X320 = pic320x320;
}
/**
* Method getPic100X100.
* @return String
*/
public String getPic100X100() {
return pic100X100;
}
/**
* Method setPic100X100.
* @param pic100x100 String
*/
public void setPic100X100(String pic100x100) {
pic100X100 = pic100x100;
}
/**
* Method getPicLarge.
* @return String
*/
public String getPicLarge() {
return picLarge;
}
/**
* Method setPicLarge.
* @param picLarge String
*/
public void setPicLarge(String picLarge) {
this.picLarge = picLarge;
}
/**
* Method getImageCategory.
* @return UUID
*/
public UUID getImageCategory() {
return imageCategory;
}
/**
* Method setImageCategory.
* @param imageCategory UUID
*/
public void setImageCategory(UUID imageCategory) {
this.imageCategory = imageCategory;
}
/**
* Method getLikeCount.
* @return int
*/
public int getLikeCount() {
return likeCount;
}
/**
* Method setLikeCount.
* @param likeCount int
*/
public void setLikeCount(int likeCount) {
this.likeCount = likeCount;
}
/**
* Method getShareCount.
* @return int
*/
public int getShareCount() {
return shareCount;
}
/**
* Method setShareCount.
* @param shareCount int
*/
public void setShareCount(int shareCount) {
this.shareCount = shareCount;
}
/**
* Method getDislikeCount.
* @return int
*/
public int getDislikeCount() {
return dislikeCount;
}
/**
* Method setDislikeCount.
* @param dislikeCount int
*/
public void setDislikeCount(int dislikeCount) {
this.dislikeCount = dislikeCount;
}
/**
* Method getRating.
* @return float
*/
public float getRating() {
return rating;
}
/**
* Method setRating.
* @param rating float
*/
public void setRating(float rating) {
this.rating = rating;
}
/**
* Method getRaingTotal.
* @return float
*/
public float getRaingTotal() {
return raingTotal;
}
/**
* Method setRaingTotal.
* @param raingTotal float
*/
public void setRaingTotal(float raingTotal) {
this.raingTotal = raingTotal;
}
/**
* Method getNumberOfRating.
* @return int
*/
public int getNumberOfRating() {
return numberOfRating;
}
/**
* Method setNumberOfRating.
* @param numberOfRating int
*/
public void setNumberOfRating(int numberOfRating) {
this.numberOfRating = numberOfRating;
}
/**
* Method getTitle.
* @return String
*/
public String getTitle() {
return title;
}
/**
* Method setTitle.
* @param title String
*/
public void setTitle(String title) {
this.title = title;
}
/**
* Method getId.
* @return UUID
*/
public UUID getId() {
return id;
}
/**
* Method setId.
* @param id UUID
*/
public void setId(UUID id) {
this.id = id;
}
/**
* Method getCommentCount.
* @return int
*/
public int getCommentCount() {
return commentCount;
}
/**
* Method setCommentCount.
* @param commentCount int
*/
public void setCommentCount(int commentCount) {
this.commentCount = commentCount;
}
/**
* Method getViewCount.
* @return int
*/
public int getViewCount() {
return viewCount;
}
/**
* Method setViewCount.
* @param viewCount int
*/
public void setViewCount(int viewCount) {
this.viewCount = viewCount;
}
/**
* Method getType.
* @return String
*/
public String getType() {
return type;
}
/**
* Method setType.
* @param type String
*/
public void setType(String type) {
this.type = type;
}
/**
* Method getCreatedDate.
* @return long
*/
public long getCreatedDate() {
return createdDate;
}
/**
* Method setCreatedDate.
* @param createdDate long
*/
public void setCreatedDate(long createdDate) {
this.createdDate = createdDate;
}
/**
* Method VideoFileName.
* @return String
*/
public String getVideoFileName() {
return videoFileName;
}
/**
* Method VideoFileName.
* @param videoFileName String
*/
public void setVideoFileName(String videoFileName) {
this.videoFileName = videoFileName;
}
}
and this is how I get the data based on the id
@Override
public ImageDto getOneImageById(UUID id) {
// TODO Auto-generated method stub
String query = "SELECT images FROM " + ImagesById.class.getSimpleName()
+ " images WHERE
images.id= :id";
List<ImagesById> ls = (List<ImagesById>) this.dao.findByQuery(query,
"id", id); if (ls != null && ls.size() > 0) {
ImageDto dto = new ImageDto();
dto = this.convertImagesByIdToImageDto(ls.get(0), dto);
UserDto user = this.userBo.getUserById(dto.getUserId());
String userFirstName = user.getFirstName();
String userLastName = user.getLastName();
MediaCategoriesDto category = this.imageCategorybo
.getImageCategoryById(dto.getImageCategory());
String categoryName = category.getCategoryDesc();
dto.setCategoryName(categoryName);
dto.setUserFirstName(userFirstName);
dto.setUserLastName(userLastName);
return dto;
} else {
return null;
}
}
the bold line is where my code is broking currently it was working fine in 2.9. (5b997526-5485-4ef9-94b2-f261daa53eea) is there in the table I can select it using CQLSH. I dont know what casuing this issue, any help will be highly appreciated.
[Request processing failed; nested exception is javax.persistence.PersistenceException: javax.persistence.PersistenceException: com.impetus.kundera.KunderaException: InvalidRequestException(why:Undefined name key in where clause ('key EQ token(5b997526-5485-4ef9-94b2-f261daa53eea)'))] with root cause
InvalidRequestException(why:Undefined name key in where clause ('key EQ token(5b997526-5485-4ef9-94b2-f261daa53eea)'))
at org.apache.cassandra.thrift.Cassandra$execute_cql3_query_result.read(Cassandra.java:37849)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
at org.apache.cassandra.thrift.Cassandra$Client.recv_execute_cql3_query(Cassandra.java:1562)
at org.apache.cassandra.thrift.Cassandra$Client.execute_cql3_query(Cassandra.java:1547)
at com.impetus.client.cassandra.CassandraClientBase.execute(CassandraClientBase.java:2291)
at com.impetus.client.cassandra.CassandraClientBase.executeCQLQuery(CassandraClientBase.java:1860)
at com.impetus.client.cassandra.CassandraClientBase$CQLClient.executeQuery(CassandraClientBase.java:2028)
at com.impetus.client.cassandra.CassandraClientBase.executeSelectQuery(CassandraClientBase.java:854)
at com.impetus.client.cassandra.thrift.ThriftClient.executeQuery(ThriftClient.java:906)
at com.impetus.client.cassandra.query.CassQuery.populateEntities(CassQuery.java:135)
at com.impetus.kundera.query.QueryImpl.fetch(QueryImpl.java:927)
at com.impetus.kundera.query.QueryImpl.getResultList(QueryImpl.java:157)
at com.audition.dao.impl.AuditionDaoImpl.findByQuery(AuditionDaoImpl.java:143)
at com.audition.bo.impl.ImageBoImpl.getOneImageById(ImageBoImpl.java:520)
at com.audition.bo.impl.UserActivityBoImpl.getUserActivityByUserAndHisFriend(UserActivityBoImpl.java:111)