Gabriela Rios

Hi,

I would like to have dynamic sql statements where I can utilize a hash map to add conditionals something like the following:

<select id="getUsers" resultType="hashmap" parameterType="hashmap">
select *
from users
<where>
<iterate var="i=0" increment>
$columni$ like #valuei#
</iterate>
</where>
</select>

Is there a way for me to accomplish something like that?

I appreciate your input on this.
Thanks.

Hello,

I have a question regarding redirect. I have noticed that when I do a redirect some (NOT ALL) of my model attributes are passed in the URL. I can't quite understand why. I have some attributes that I want to maintain throughout my controllers so I added the annotation @SessionAttributes with the name of the model attributes. In all my controllers, I use at least two of those session attributes but I can only see this particular one always being passed. If I update one of those session attributes, it gets passed on the URL as well. The one that ALWAYS gets passed in my URL is a String. Other types of objects don't get passed in my URL. Is that the reason? If it's a string and/or if I just updated the attributes that is a string, will it get passed in my URL? I redirect using strings. I also use Apache Tiles.

Thanks in advance for the clarification.

Hello, I'm having some difficulties adding Spring Webflow to my application.

I used one of the spring samples: webflow-showcase: https://src.springframework.org/svn/spring-samples/webflow-showcase
I got it to run locally. I created my own flow and made it work.

Now, I'm trying to add it to my application but I can't get the reference to go to the folder with my flow definition.

webflow.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:webflow="http://www.springframework.org/schema/webflow-config" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/webflow-config http://www.springframework.org/schema/webflow-config/spring-webflow-config-2.3.xsd"> <!-- Executes flows: the central entry point into the Spring Web Flow system --> <webflow:flow-executor id="flowExecutor" /> <!-- The registry of executable flow definitions --> <webflow:flow-registry id="flowRegistry" flow-builder-services="flowBuilderServices" base-path="/WEB-INF/views/flows"> <webflow:flow-location-pattern value="/**/flow.xml" /> </webflow:flow-registry> <!-- Plugs in a custom creator for Web Flow views --> <webflow:flow-builder-services id="flowBuilderServices" view-factory-creator="mvcViewFactoryCreator" development="true" validator="validator" /> <!-- Configures Web Flow to use Tiles to create views for rendering; Tiles allows for applying consistent layouts to your views --> <bean id="mvcViewFactoryCreator" class="org.springframework.webflow.mvc.builder.MvcViewFactoryCreator"> <property name="viewResolvers" ref="tilesViewResolver2"/> <property name="useSpringBeanBinding" value="true" /> </bean> <!-- Bootstraps JSR-303 validation and exposes it through Spring's Validator interface --> <bean id="validator" class="org.springframework.validation.beanvalidation.LocalValidatorFactoryBean"/> </beans>

servlet-context.xml

I originally only had UrlBasedViewResolver but for the flows I had to create an AjaxUrlBasedViewResolver and I had to add a new definition to my TilesConfigurer.

<?xml version="1.0" encoding="UTF-8"?> <beans:beans xmlns="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:beans="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:p="http://www.springframework.org/schema/p" xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd"> <beans:import resource="webflow.xml" /> <!-- Enables the Spring MVC @Controller programming model --> <context:component-scan base-package="com.corp.mpower.controller" /> <!-- Scan @Service --> <context:component-scan base-package="com.corp.mpower.service" /> <annotation-driven /> <context:annotation-config /> <!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory --> <resources mapping="/resources/**" location="/resources/" /> <!-- Tiles Configuration --> <beans:bean id="tilesViewResolver1" class="org.springframework.web.servlet.view.UrlBasedViewResolver"> <beans:property name="viewClass" value="org.springframework.web.servlet.view.tiles2.TilesView"/> </beans:bean> <!-- Resolves logical view names returned by Controllers to Tiles; a view name to resolve is treated as the name of a tiles definition --> <beans:bean id="tilesViewResolver2" class="org.springframework.js.ajax.AjaxUrlBasedViewResolver"> <beans:property name="viewClass" value="org.springframework.webflow.mvc.view.FlowAjaxTilesView"/> </beans:bean> <beans:bean class="org.springframework.web.servlet.view.tiles2.TilesConfigurer" id="tilesConfigurer"> <beans:property name="definitions"> <beans:list> <beans:value>/WEB-INF/layouts/layouts.xml</beans:value> <beans:value>/WEB-INF/**/views.xml</beans:value> </beans:list> </beans:property> </beans:bean> </beans:beans>

This is the page that launches my flow: shoppingcart.jsp. My href is the name of the folder that has my flow: shopping-cart.

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <div> <h2 class="alt">Flow In a Modal Dialog</h2> <h4 class="alt"><a href="<c:url value="/"/>">Home</a></h4> <hr> <c:if test="${param.result eq 'success'}"> <p class="success">Flow completed with success!</p> </c:if> <c:if test="${param.result eq 'cancel'}"> <p class="error">Flow ended with cancellation!</p> </c:if> <div> <p> <h4><a id="startFlow" rel="nofollow">Launch Flow</a></h4> <script type="text/javascript"> Spring.addDecoration(new Spring.AjaxEventDecoration({elementId:"startFlow",event:"onclick",popup:true,params:{fragments:"body",mode:"embedded"}})); </script> </p> </div> </div>

My shopping-cart folder is in "/WEB-INF/views/flows" as per my FlowRegistry.

WEB-INF
>>views
>>>>flows
>>>>>>shopping-cart
>>>>>>>>flow.xml
>>>>>>>>step1.jsp
>>>>>>>>step2.jsp
>>>>>>>>views.xml

flow.xml

<?xml version="1.0" encoding="UTF-8"?> <flow xmlns="http://www.springframework.org/schema/webflow" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=" http://www.springframework.org/schema/webflow http://www.springframework.org/schema/webflow/spring-webflow.xsd"> <view-state id="step1" view="shopping-cart/step1"> <transition on="next" to="step2"/> <transition on="cancel" to="cancel"/> </view-state> <view-state id="step2" view="shopping-cart/step2"> <transition on="previous" to="step1"/> <transition on="finish" to="success"/> <transition on="cancel" to="cancel"/> </view-state> <end-state id="success" view="externalRedirect:shoppingcart?result=success"/> <end-state id="cancel" view="externalRedirect:shoppingcart?result=cancel"/> </flow>

views.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE tiles-definitions PUBLIC "-//Apache Software Foundation//DTD Tiles Configuration 2.0//EN" "http://tiles.apache.org/dtds/tiles-config_2_0.dtd"> <tiles-definitions> <definition name="shopping-cart/*" extends="standardLayout"> <put-attribute name="body" value="/WEB-INF/views/flows/shopping-cart/{1}.jsp" /> </definition> </tiles-definitions>


Any idea of what I'm doing wrong? Thanks. Any help will be greatly appreciated.

Regards,

Thanks Bill. I may used as it looks a little bit cleaner. Should I have my links like this instead of plain text: <c:url value="home"/>?

Thanks Mark! That fixed my problem with the css, js, and images. Does that mean that I need to add the context to all my links? For example in my header I have the logo of my company and I have the reference of my links like this "home". Now, of course, that doesn't work. Should I then have "${pageContext.request.contextPath}\home" for ALL of my links? I feel like I'm doing something wrong here.

Hi,

I have a questions regarding the change of the root folder by default after a call using more than one RequestMapping. Could any body please clarify this for me? For example:
I have a link in one of my views with something like this #142

I have my Controller

import java.util.Locale; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.ModelAttribute; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.SessionAttributes; import domain.Product; import service.ProductService; import util.MyException; @RequestMapping("/product") @Controller public class ProductController { @Autowired private ProductService productService; @RequestMapping(value = "/{id}", method=RequestMethod.GET) public String showProduct(@PathVariable("id") long id, Locale locale, Model model) { System.out.println(id); try { Product p = productService.getProductById(id, m2Ticket); if(p == null){ System.out.println("\n\n\n\n\nredirect home"); return "redirect:/home"; } } catch (MyException e) { // TODO Auto-generated catch block e.printStackTrace(); } System.out.println("\n\n\n\n\nproduct"); return "product"; } }

The problem I'm having is the following: I have my images, css, js, etc in the resources folder so my links are <link rel="stylesheet" type="text/css" href="resources/css/grid.css"/>. Initially, this all works but after having used /product/{142}. My root folder has changed to MyRoot/product so links now instead of going to MyRoot/resources/css/grid.css they go to MyRoot/Product/resources/css/grid.css.

How should I address this issue? I don't want to have a different header and footer every time I used a mapping with more than one level like /product/142.

Any help will be greatly appreciated

Hello,

I'm new to RESTful Web Services. I created one and now I'm working on the client but I'm confused on how to turn my xml into my object.

I have my response of the type org.apache.http.HttpResponse. It looks like this:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><User><address>XXX</address><firstname>Gabriela</firstname></User>

I have my class User with @XmlRootElement. How do i turn that xml into my class.
In here, http://cxf.apache.org/docs/jax-rs-data-bindings.html, they show how to do it but they never really assign the response to the Customer or Customers.

I also found this, http://www.mkyong.com/webservices/jax-rs/restful-java-client-with-apache-httpclient/, but it produces a string rather than xml. I would like to find an example like this where instead of using json they use xml.

I would like to know how do they do something like this?

HttpResponse result = httpclient.execute(get);
User user = magicFunction(result);

Can somebody point in the right direction please?

Thanks,

Turns out I still had the error so I removed <context:annotation-config /> and it works now. Thanks


web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <!-- Creates the Spring Container shared by all Servlets and Filters --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- Processes application requests --> <servlet> <servlet-name>appServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <!-- The definition of the Root Spring Container shared by all Servlets and Filters --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/spring/root-context.xml</param-value> </context-param> <servlet-mapping> <servlet-name>appServlet</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <!-- Welcome file --> <welcome-file-list> <welcome-file>/WEB-INF/views/index.jsp</welcome-file> </welcome-file-list> </web-app>


root-context.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:lang="http://www.springframework.org/schema/lang" xmlns:p="http://www.springframework.org/schema/p" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd"> <context:annotation-config /> <context:component-scan base-package="com.syscorp.power" /> <!-- Tiles Configuration --> <bean class="org.springframework.web.servlet.view.UrlBasedViewResolver" id="tilesViewResolver"> <property name="viewClass" value="org.springframework.web.servlet.view.tiles2.TilesView"/> </bean> <bean class="org.springframework.web.servlet.view.tiles2.TilesConfigurer" id="tilesConfigurer"> <property name="definitions"> <list> <value>/WEB-INF/layouts/layouts.xml</value> </list> </property> </bean> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" p:location="/WEB-INF/jdbc.properties" /> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" p:driverClassName="${jdbc.driverClassName}" p:url="${jdbc.databaseurl}" p:username="${jdbc.username}" p:password="${jdbc.password}" /> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation"> <value>classpath:hibernate.cfg.xml</value> </property> <property name="configurationClass"> <value>org.hibernate.cfg.AnnotationConfiguration</value> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">${jdbc.dialect}</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean> <tx:annotation-driven /> <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean> </beans>

servlet-context.xml

<?xml version="1.0" encoding="UTF-8"?> <beans:beans xmlns="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:beans="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:p="http://www.springframework.org/schema/p" xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd"> <!-- Enables the Spring MVC @Controller programming model --> <context:component-scan base-package="com.m2syscorp.mpower.controller" /> <annotation-driven /> <!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory --> <resources mapping="/assets/**" location="/assets/" /> </beans:beans>

Thanks for letting me know all of that. I'm in the process of learning spring 3 and hibernate but at the same time I have to make some progress in my project so I'm using things that I don't fully understand.

I have removed the filter as I really didn't need it. Initially, when I added it, it let me see other errors that I had with my mappings. I had errors with my OneToMany and ManyToMany annotations which essentially was that I didn't have the table in my hibernate.cfg.xml.

<?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <mapping class="com.sys.power.domain.User"/> <mapping class="com.sys.power.domain.Interest"/> <mapping class="com.sys.power.domain.Registrant"/> </session-factory> </hibernate-configuration>

The first example that I saw didn't really use that file. It was something like this.

<!-- SessionFactory bean --> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> <!-- Inject data source bean into the session factory --> <property name="dataSource" ref="dataSource"/> <!-- Scan for the domain objects with the ORM annotation --> <property name="packagesToScan" value="com.sys.power.domain"/> <!-- Provides configuration details for hibernate --> <property name="hibernateProperties"> <props> <!-- database dialect MySQLDialect, PostgreSQLDialect, Oracle10gDialect --> <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop> <!-- Declares the depth for outer joins when mapping objects have associations with other mapped objects --> <prop key="hibernate.max_fetch_depth">3</prop> <!-- The number of records from the JDBC result set that Hibernate should use to retrieve the records for each fetch --> <prop key="hibernate.jdbc.fetch_size">50</prop> <!-- Number of update operations that should be grouped together into a batch --> <prop key="hibernate.jdbc.batch_size">10</prop> <!-- if hibernate should output the sql queries to the log or console --> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean>

Is that file really necessary? I get a warning because the DTD is deprecated but I changed it to the new one supposedly and it didn't work for me. Any thoughts on this? Thanks for your help on this. I'm learning a lot with you guys.

It works now. I added this filter:

<filter> <filter-name>hibernateFilter</filter-name> <filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class> </filter> <filter-mapping> <filter-name>hibernateFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping>

Thanks!

Thanks Mark! I moved my DataSource, TransactionManager and SessionFactory to my root-context.xml. When I try to run it, I get:

Jun 11, 2012 9:43:07 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [appServlet] in context with path [/MPower] threw exception [Request processing failed; nested exception is org.hibernate.HibernateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here] with root cause
org.hibernate.HibernateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here

Any ideas?

I added <context:annotation-config/> but that didn't fix the problem.

This is my web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <!-- Creates the Spring Container shared by all Servlets and Filters --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- Processes application requests --> <servlet> <servlet-name>appServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <!-- The definition of the Root Spring Container shared by all Servlets and Filters --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/spring/root-context.xml</param-value> </context-param> <servlet-mapping> <servlet-name>appServlet</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <!-- Standard Action Servlet Mapping --> <servlet-mapping> <servlet-name>AppManager</servlet-name> <url-pattern>/servlet/AppManager</url-pattern> </servlet-mapping> <!-- Welcome file --> <welcome-file-list> <welcome-file>/WEB-INF/views/index.jsp</welcome-file> </welcome-file-list> <!-- Error redirects --> <error-page> <error-code>404</error-code> <location>/WEB-INF/views/errornotfound.jsp</location> </error-page> <error-page> <error-code>500</error-code> <location>/WEB-INF/views/errorunauthorized.jsp</location> </error-page> </web-app>

Hello,

I'm trying to incorporate hibernate in my project but I'm having some difficulties. I'm getting the following error:

ERROR: org.springframework.web.context.ContextLoader - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userDAOImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.hibernate.SessionFactory com.sys.power.dao.hibernate.UserDAOImpl.sessionFactory; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No matching bean of type [org.hibernate.SessionFactory] found for dependency: expected at least 1 bean which qualifies as autowire candidate for this dependency. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.hibernate.SessionFactory com.sys.power.dao.hibernate.UserDAOImpl.sessionFactory; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No matching bean of type [org.hibernate.SessionFactory] found for dependency: expected at least 1 bean which qualifies as autowire candidate for this dependency. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}


I'm not sure what the problem is as I'm implementing all the interfaces needed. I don't know where is the mapping that I need to make the autowired work. I don't want this post that long but here are my files.

root-context.xml
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <context:annotation-config/> <context:component-scan base-package="com.sys.power.dao"/> <context:component-scan base-package="com.sys.power.dao.hibernate"/> <context:component-scan base-package="com.sys.power.service"/> </beans>

servlet-context.xml
<?xml version="1.0" encoding="UTF-8"?> <beans:beans xmlns="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:beans="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:p="http://www.springframework.org/schema/p" xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd"> <!-- Enables the Spring MVC @Controller programming model --> <context:component-scan base-package="com.sys.power" /> <annotation-driven /> <!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory --> <resources mapping="/assets/**" location="/assets/" /> <!-- Tiles Configuration --> <beans:bean class="org.springframework.web.servlet.view.UrlBasedViewResolver" id="tilesViewResolver"> <beans:property name="viewClass" value="org.springframework.web.servlet.view.tiles2.TilesView"/> </beans:bean> <beans:bean class="org.springframework.web.servlet.view.tiles2.TilesConfigurer" id="tilesConfigurer"> <beans:property name="definitions"> <beans:list> <beans:value>/WEB-INF/layouts/layouts.xml</beans:value> </beans:list> </beans:property> </beans:bean> <tx:annotation-driven transaction-manager="transactionManager"/> <beans:bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <beans:property name="sessionFactory" ref="sessionFactory"/> </beans:bean> <beans:bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" p:location="/WEB-INF/jdbc.properties"/> <beans:bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" p:driverClassName="${jdbc.driverClassName}" p:url="${jdbc.databaseurl}" p:username="${jdbc.username}" p:password="${jdbc.password}"/> <beans:bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <beans:property name="dataSource" ref="dataSource"/> <beans:property name="configLocation"> <beans:value>classpath:hibernate.cfg.xml</beans:value> </beans:property> <beans:property name="configurationClass"> <beans:value>org.hibernate.cfg.AnnotationConfiguration</beans:value> </beans:property> <beans:property name="hibernateProperties"> <beans:props> <beans:prop key="hibernate.show_sql">true</beans:prop> <beans:prop key="hibernate.dialect">${jdbc.dialect}</beans:prop> <beans:prop key="hibernate.connection.charSet">UTF-8</beans:prop> </beans:props> </beans:property> </beans:bean> </beans:beans>

hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <mapping class="com.sys.power.domain.User"/> </session-factory> </hibernate-configuration>


I have my User.java
package com.sys.power.domain; import javax.persistence.*; @Entity @Table(name="users") public class User implements Serializable { private int id; private String firstName; private String middleName; private String lastName; @Id @Column(name="USERID") @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="USERS_TRG") @SequenceGenerator(name="USERS_TRG", sequenceName = "USERS_SEQ") public int getId() { return id; } /** * @param id the id to set */ public void setId(int id) { this.id = id; } }

UserDAO.java
package com.sys.power.dao; import java.util.List; import com.sys.power.domain.User; public interface UserDAO { public List<User> findAll(); public List<User> findAllWithInterests(); public User findById(int id); public User save(User user); public void delete(User user); }

UserDAOImpl.java
package com.m2sys.mpower.dao.hibernate; import java.util.List; import javax.annotation.Resource; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.hibernate.SessionFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import org.springframework.transaction.annotation.Transactional; import com.m2sys.mpower.dao.UserDAO; import com.m2sys.mpower.domain.User; /** * * @author GDelosrios * */ @Repository @Transactional public class UserDAOImpl implements UserDAO { @Autowired private SessionFactory sessionFactory; @Transactional(readOnly=true) public List<User> findAll() { return sessionFactory.getCurrentSession().createQuery("from User c").list(); } public List<User> findAllWithInterests() { return sessionFactory.getCurrentSession(). getNamedQuery("User.findAllWithInterests").list(); } public User findById(int id) { return (User) sessionFactory.getCurrentSession(). getNamedQuery("User.findById"). setParameter("id",id).uniqueResult(); } public User save(User user) { return null; } public void delete(User user) { } }

UserService.java
package com.sys.power.service; import java.util.List; import com.sys.power.domain.User; public interface UserService { public void save(User user); public List<User> findAll(); public void delete(User user); public User findById(int id); }

UserServiceImpl.java
package com.m2sys.mpower.service; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import com.m2sys.mpower.dao.UserDAO; import com.m2sys.mpower.domain.User; @Service public class UserServiceImpl implements UserService { @Autowired private UserDAO userDao; @Transactional public void save(User user) { userDao.save(user); } @Transactional public List<User> findAll() { return userDao.findAll(); } @Transactional public void delete(User user) { userDao.delete(user); } @Transactional public User findById(int id) { return userDao.findById(id); } }

UserController.java

package com.sys.power.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.ModelAttribute; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.support.SessionStatus; import com.sys.power.domain.User; import com.sys.power.service.UserService; @Controller public class UserController { @Autowired private UserService userService; @RequestMapping(value = "/login.do") public String login(@ModelAttribute("user")User user, @RequestParam("username") String username, @RequestParam("password") String password, Model model, SessionStatus status) { logger.info("Login"); System.out.println(userService.findById(1)); } }

are my packages ok? What am I missing? any ideas? Thanks. Any help will be greatly appreciate it.

Thanks! My bad. I'll be more careful next time.

I got this working by doing the follwing:

@Id @Column(name="USERID") @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="USERS_TRG") @SequenceGenerator(name="USERS_TRG", sequenceName = "USERS_SEQ") public int getId() { return id; }

and also I had the wrong dialect in my hibernateProperties: <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>