sachin pachpute

In my spring, JSP based application, user is entering free from description in the text area. But when data is saved and displayed on the next (read only) page, entire text is wrapped in to single para. I want whole text to be saved as user enters it along with line spaces, newlines, tabs etc.

eg is as below.

below entered description when saved will get wrapped in to a single para and will not be dispayed as it looks below.I have posted this question on other forums and also tried finding solution online so please help.


Books in the stack are

Spring
Hibernate
jQuery
mySQL

Hi,

I am getting filtered 'Trainer' entities, but collection (trainedMonkeys) is not filtered. 'trainedMonkeys' variable is holding all 'Monkey' objects instead of holding only the one with 'isThumb = true'.

Can someone please check if below criteria I am using is correct?

@SuppressWarnings("unchecked") public List<Trainer> listTrainers() { Criteria crit = sessionFactory.getCurrentSession().createCriteria(Trainer.class) .createAlias("trainedMonkeys", "tm") .add(Restrictions.eq("tm.isThumb", true)) .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);


Trainer.java
public class Trainer { private Long trainerId; private String trainerName; public List<Monkey> trainedMonkeys;

Monkey.java
public class Monkey { private Long id; private String monkeyName; private boolean isThumb;

I am executing below code in the controller,
for (Trainer trainer : trainerList){ System.err.println("<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>"); System.err.println("Trainer ID*****"+trainer.getTrainerId()); System.err.println("Trainer Name******"+trainer.getTrainerName()); monkeyList = trainer.getTrainedMonkeys(); for (Monkey monkey : monkeyList){ System.err.println("Monkey ID*****"+monkey.getId()); System.err.println("Monkey Name*****"+monkey.getMonkeyName()); } System.err.println("<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>"); }

and the output is as below (Text marked in RED is not expected as it is marked as 'isThumb=false' in the database and hence should not be shown. Please suggest...),
<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>
Trainer ID*****88
Trainer Name******TrainerSachin
Monkey ID*****87
Monkey Name*****Monkey_1
Monkey ID*****88
Monkey Name*****Monkey_2
Monkey ID*****89
Monkey Name*****Monkey_3
<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>
<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>
Trainer ID*****89
Trainer Name******TrainerVinod
Monkey ID*****90
Monkey Name*****Monkey_5
Monkey ID*****91
Monkey Name*****Monkey_6
Monkey ID*****92
Monkey Name*****Monkey_7
<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>

Hi,

I went through the hibernate doc and not able to figure out if I should use bidirectional or unidirectional one-to-many relationship.

Each product has three images. My requirement is, I want to get all the products, loop through it and only display 1st image (along with product details).

should i be using unidirectional or bidirectional one-to-many relationship? I went through the hibernate doc but still not clear.


-- Table schema

|---------------------|
PRODUCT
|---------------------|
id
number
Expiry date
|---------------------|


|---------------------|
IMAGE
|---------------------|
id
image url
|---------------------|

Hi,

I have spent a couple of hours finding solution online but in vain. Please help.

Article.java
@OneToMany(cascade = CascadeType.ALL, fetch=FetchType.EAGER) @JoinTable ( name = "PROPERTY_IMAGE", joinColumns = { @JoinColumn(name = "PROPERTY_ID") }, inverseJoinColumns = { @JoinColumn(name = "IMAGE_ID", unique=true)} ) @JoinColumn(name = "ARTICLE_ID") /*@WhereJoinTable(clause="IMG_NAME like ('%_0.jpg')") @FilterJoinTable(name="test", condition=":IMG_NAME like ('%_0.jpg')") @org.hibernate.annotations.Cascade(value=org.hibernate.annotations.CascadeType.DELETE_ORPHAN)*/ public List<Image> images;

Each Article has 3 images in Image table and hence I am CORRECTLY getting 3 rows. I want to filter records to match criteria "where Image.IMG_NAME like ("%_0.jpg")". You can see I tried using both "WhereJoinTable" and "FilterJoinTable" but it is not working.

Query I can see on the console is,
select this_.ID as ID0_2_, this_.CATEGORY as CATEGORY0_2_, this_.DESCRIPTION as DESCRIPT3_0_2_, this_.LOCATION as LOCATION0_2_, this_.PRICE as PRICE0_2_, this_.TITLE as TITLE0_2_, this_.NUM_BEDROOMS as NUM7_0_2_, this_.user_ID as user8_0_2_, images2_.PROPERTY_ID as PROPERTY1_4_, image3_.id as IMAGE2_4_, image3_.id as id1_0_, image3_.img_name as img2_1_0_, user4_.ID as ID3_1_, user4_.EMAIL_ID as EMAIL2_3_1_, user4_.FIRST_NAME as FIRST3_3_1_, user4_.LAST_NAME as LAST4_3_1_, user4_.LOGIN_ID as LOGIN5_3_1_, user4_.PASSWORD as PASSWORD3_1_, user4_.PHONE as PHONE3_1_ from article this_ left outer join PROPERTY_IMAGE images2_ on this_.ID=images2_.PROPERTY_ID left outer join image image3_ on images2_.IMAGE_ID=image3_.id left outer join user user4_ on this_.user_ID=user4_.ID

This is a correct behavior but I want to add 'where' clause to get only one record (with image name ending with "_0.jpg").

Tables,

TABLE `article` ( `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `TITLE` VARCHAR(45) NOT NULL, `LOCATION` VARCHAR(20) NULL DEFAULT NULL, `DESCRIPTION` VARCHAR(700) NULL DEFAULT NULL, `PRICE` VARCHAR(10) NOT NULL, `CATEGORY` INT(10) UNSIGNED NULL DEFAULT NULL, `USER_ID` INT(10) UNSIGNED NOT NULL, `DATE` DATETIME NULL DEFAULT NULL, `FURNISHED` INT(10) UNSIGNED NULL DEFAULT NULL, `NUM_BEDROOMS` INT(10) UNSIGNED NULL DEFAULT NULL,

TABLE `image` ( `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `IMG_NAME` VARCHAR(150) NOT NULL, PRIMARY KEY (`ID`)

TABLE `property_image` ( `PROPERTY_ID` INT(10) UNSIGNED NOT NULL, `IMAGE_ID` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`PROPERTY_ID`, `IMAGE_ID`), INDEX `FK_property_image_2` (`IMAGE_ID`),

It is just not working. Please suggest. Let me know if are more details are needed...

ok.. the issue is resolved with the version update to 3.1.1

I was going through Spring version changelog and noticed below line for version 3.0.4

"* WebDataBinder and @MVC request params detect and introspect MultipartFile arrays as well"

looks like I need to upgrade to latest version as i am using 3.0.1

I should have done this any ways to avoid any version issues.. lesson learnt!!!

I referred to below posts as well and they havent done anything different.. Can't seem to find what is the issue. Can someone help please? Am I missing something?

http://www.bitspedia.com/2012/05/how-to-upload-multiple-files-using.html

http://stackoverflow.com/questions/2017807/spring-3-upload-many-files

I am trying to upload multiple files using spring 3, it is picking only the fist file. I browsed through a few posts available online but didnt get clear solution.

JSP
<form:input path="fileData" tabindex="10" id="file" value="Add Pictures" type="file"/> <form:input path="fileData" tabindex="10" id="file" value="Add Pictures" type="file"/>

Bean
private List<MultipartFile> fileData; and getter / setters ...

Controller
@RequestMapping(value = "/save", method = RequestMethod.POST) public String saveArticle(@Valid Article article, BindingResult result, HttpServletRequest request, Model model) { List<MultipartFile> multipartFile = article.getFileData(); logger.debug("Size of the multipart file :"+multipartFile.size()); further iteration and processing to write file on a disk....

dispatcher-servlet
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <property name="maxUploadSize" value="1000000"/> </bean>


I earlier tried below in JSP but it gave me error...
<form:input path="fileData[0]" tabindex="10" id="file" value="Add Pictures" type="file"/> <form:input path="fileData[1]" tabindex="10" id="file" value="Add Pictures" type="file"/>

Thanks Bill. I could work on this piece only yesterday and it didn’t even take an hour. Never thought it would be that straightforward

Another good example I found was,

http://www.developer.com/java/web/article.php/10935_3830886_2/A-Pagination-Technique-Using-Spring.htm

Hi Bill,

I am using jsp, Spring 3, Hibernate and MySQL. I am retreiving article list from service and displaying on jsp page. Implementation is something like below,

Controller code
@RequestMapping(method = RequestMethod.GET) public String listArticles(Model model) { // articles: Name of the bean accessed in jsp page model.addAttribute("articles", articleService.listArticles()); // articlesList: Name of the jsp page that will be called return "articlesList"; }

on my JSP, I am displaying

ArticleTitle
ArticleRent
ArticleDescription
ArticleUserFirstName
ArticleUserLastName
ArticleImage

etc....

How to set list in PageListHolder and how to use it in jsp? I want JSP to have buttons like Next, previous, 1, 2, 3 like we see on most of the applications for going to next page, previous page or specific page.

I want to incorporate pagination in my spring 3 MVC application. Is there any standard pagination component spring provides?

Any good example I can refer to?

Thanks,
Sachin

This problem is resolved for me now. Just read the document at http://docs.jboss.org/hibernate/validator/4.0.1/reference/en/html/validator-usingvalidator.html

I added,

@NotNull @Valid

before

@OneToOne(cascade = CascadeType.ALL) private User user;

Details given below. Please note that validation is working fine for Article (only few fields I am validating for now), but isn't working for User which is referred from Article.

Article.java

@Entity @Table(name = "article") public class Article { @Id @GeneratedValue @Column(name = "ID") private Long articleId; @Column(name = "TITLE") @NotEmpty private String articleTitle; @Column(name = "LOCATION", nullable = false) @NotEmpty private String articleLocation; @Column(name = "DESCRIPTION") @NotEmpty private String articleDescription; @Column(name = "RENT") private int articleRent; @Column(name = "CATEGORY") private int articleCategory; @OneToOne(cascade = CascadeType.ALL) private User user;

User.java

@Id @GeneratedValue @Column(name = "ID") private Long userId; @Column(name = "LOGIN_ID", length = 45) private String login; @Column(name = "PASSWORD", length = 45) private String password; @Column(name = "FIRST_NAME") @NotEmpty private String firstName; @Column(name = "LAST_NAME") @NotEmpty private String lastName; @Column(name = "EMAIL_ID") @Email private String emailId; @Column(name = "PHONE") @NotNull @Size(min = 10, max = 14) private String phone;

ArticleController.java

@RequestMapping(value = "/save", method = RequestMethod.POST) public String saveArticle(@Valid Article article, BindingResult result, HttpServletRequest request, Model model) { if (result.hasErrors()) { return "addArticle"; } try { MultipartFile file = article.getFileData();

relevant snippet from despatcher servlet (for JSR 303 & messages) is as below,

<mvc:annotation-driven/> <bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource"> <property name="basename" value="/WEB-INF/messages"/> </bean>

addArticle.jsp

<li> <form:label path="user.firstName">Name*</form:label> <div> <form:input path="user.firstName" type="text" maxlength="70" id="firstName" value=""/> <form:errors path="user.firstName" class="error"/> <form:input path="user.lastName" type="text" maxlength="70" id="lastName" value="""/> <form:errors path="user.lastName" class="error"/> </div> </li> <li> <form:label path="user.emailId">Email address*</form:label> <div> <form:input path="user.emailId" type="text" maxlength="145" id="emailId" value=""/> <form:errors path="user.emailId" class="error"/> </div> </li>

Hi,

In my application I want to validate the field which contains reference to another domain object (Address in this case). I am able to validate name and age fields, but not able to validate fields from Address class (no message is displayed on jsp).

public class Customer { String name; int age; Address address; //getter and setter methods } public class Address{ String postcode; int houseNumber; String roadName; //getter and setter methods }

Hi Ken,

I am completely new to Roo so am I missing a big thing here?

What does is mean to a developer who is working on Spring3 MVC & hibernate with Eclipse IDE and does not know Roo? I have started developing application a month back and now came across this post.

I am still not getting my head around on how can I make use of Roo in my application(or should I at the first place)?
Do I have to start all over if I want to learn Roo?


Thanks