ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Niemeyer <andreas.nieme...@gutzmann.com>
Subject Re: JSF configuration with Spring?
Date Sat, 01 Nov 2008 16:35:57 GMT
Hi,

I got everything working now after a few hours investigation.


The motivation was to get a basic setup working within a portlet AND a 
servlet environment with a simple implemented service layer in context 
of JSF.


The promised simplicity of iBatis seemed to be ideal for the 
requirements: getting a loosly coupled DAO service, model undriven and 
flexible in configuration, extensibility and usage. The excellent SPRING 
  support was not least the key between everything.


Therefore a small summerize at this point how to glue JSF with Spring 
and iBatis.


Some links helped me:

http://ibatisnet.sourceforge.net/DevGuide.html
http://www.developersbook.com/ibatis/iBatis-tutorials/iBatis-tutorials.php
http://forum.springframework.org/showthread.php?t=19032&highlight=iBatis
http://opensource.atlassian.com/confluence/spring/display/JSR168/Home
http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/iBATIS-SqlMaps-2-Tutorial_en.pdf
http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/iBATIS-SqlMaps-2_en.pdf


The configuration based on facelets 1.1.14, myfaces 1.1.6, ibatis 
2.3.4.726, spring-framework 2.5.5 (spring.jar, spring-webmvc.jar, 
spring-webmvc-portlet.jar), the portal environment is liferay x.


Only the relevant fragments are listed below portal type is independent.

The approach was to simply call a db sequence as a first step, no 
classes of properties or resultsets mapped here. (shouldn't be a problem 
  anymore)


Kind regards,
Andreas


1) faces-config.xml

...

<application>
<view-handler>com.sun.facelets.FaceletPortletViewHandler</view-handler>		<variable-resolver>org.springframework.web.jsf.DelegatingVariableResolver</variable-resolver>


</application>

...


2) web.xml

...

<context-param>				
  <param-name>javax.faces.application.CONFIG_FILES</param-name>
  <param-value>/WEB-INF/faces-config.xml</param-value>
</context-param>

<context-param>
  <param-name>contextConfigLocation</param-name>
   <param-value>
    /WEB-INF/classes/applicationContext.xml
  </param-value>
</context-param>

...

<listener>    	 
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

<listener>    	 
<listener-class>org.springframework.web.context.request.RequestContextListener</listener-class>
</listener>

...


3) applicationContext.xml

...

<bean id="dataSource" 
class="org.springframework.jndi.JndiObjectFactoryBean">
	<property name="jndiName" value="java:comp/env/jdbc/XXX"/>
</bean>

<bean id="sqlMap"
	class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
	<property name="configLocation" value="WEB-INF/classes/sqlmap-config.xml"/>
	<property name="dataSource" ref="dataSource"/>
</bean>

<bean id="sequencesBean"
         class="com.company.portlets.xxx.galery.dao.SequenceServiceImpl">
         <property name="sqlMapClient" ref="sqlMap" />
</bean>

...

4) META-INF/context.xml

...

<Resource
        	name="jdbc/XXX"
         auth="Container"
         type="javax.sql.DataSource"
         driverClassName="org.postgresql.Driver"
 
url="jdbc:postgresql://localhost:5432/xxx?useUnicode=true&amp;characterEncoding=UTF-8"
         username="foo"
         password="foopass"
         maxActive="100"
         maxIdle="30"
         maxWait="10000"
   	/>

...

5) sqlmap-config.xml

...

<sqlMapConfig>
     <settings useStatementNamespaces="true"/>
     <sqlMap resource="ibatis-sql/sequences.xml"/>
</sqlMapConfig>

...

6) sequences.xml

...

<sqlMap namespace="sequences">
   <select id="getUploadSequence" resultClass="long">
     select nextval('galery_s_upload_id')
   </select>
</sqlMap>

...

7) ISequenceService class

package com.company.portlets.xxx.galery.dao;

public interface ISequenceService {
	public long getUploadSequence() throws Exception ;
}


8) SequenceServiceImpl class

package com.company.portlets.xxx.galery.dao;

import com.ibatis.sqlmap.client.SqlMapClient;

public class SequenceServiceImpl implements ISequenceService {

	protected SqlMapClient sqlMap = null;

     public void setSqlMapClient(SqlMapClient sqlMap) {
         this.sqlMap = sqlMap;
     }

     public long getUploadSequence() throws Exception {
         return (Long)sqlMap.queryForObject("sequences.getUploadSequence");
     }
}


9) a JSF bean class

...

import org.springframework.context.ApplicationContext;
import com.company.portlets.xxx.galery.dao.ISequenceService;

...

public long getServletuploadid() {

  ...
  long id_seq;

  ApplicationContext ctx = PortletJSFUtil.getApplicationContext();
  ISequenceService service = (ISequenceService)
    ctx.getBean("sequencesBean");
  try {
    id_seq = service.getUploadSequence();
  } catch (Exception e) {
   pLogger.error(e.getMessage());
  ...
}


}

10) a PortletJSFUtil class

...

import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;
import org.springframework.context.ApplicationContext;
import 
org.springframework.web.portlet.context.PortletApplicationContextUtils;

...


private static ExternalContext getExternalContext() {
  return FacesContext.getCurrentInstance().getExternalContext();
}
	
public static ApplicationContext getApplicationContext() {	
return 
PortletApplicationContextUtils.getRequiredWebApplicationContext((PortletContext) 
getExternalContext().getContext());
}

...

11) in a servlet class

...

import org.springframework.web.context.WebApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;
import com.company.portlets.xxx.galery.dao.ISequenceService;
...

WebApplicationContext ctx = 
WebApplicationContextUtils.getRequiredWebApplicationContext(getServletContext());
ISequenceService service=(ISequenceService)ctx.getBean("sequencesBean");

long id_seq = -1;
	
try {
  id_seq = service.getUploadSequence();
} catch (Exception e) {
  pLogger.error(e.toString());
}

...




Andreas Niemeyer schrieb:
> Hi,
> 
> Does someone knows a basic example for this combination?
> 
> I found one tiny example which is a bit incomplete. I guess for Spring a 
> DelegatingVariableResolver is required for the managed beans.
> 
> http://ffzhuang.blogspot.com/2007/04/jsf-spring-ibatis-integrate.html
> 
> Thank you!
> 
> 
> Kind regards,
> Andreas
> 
> 


Mime
View raw message