Jechue World

Rest Template

servlet-context.xml 설정

스키마 설정

<beans:beans xmlns="http://www.springframework.org/schema/mvc"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:mvc="http://www.springframework.org/schema/mvc"

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:util="http://www.springframework.org/schema/util"

xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd

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

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">

bean 설정

// RestTemplate bean 등록

<beans:bean id="restTemplate" class="org.springframework.web.client.RestTemplate">

<util:list>

<beans:bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">

//카멜케이스를 언더스코어로 받기위해 objectMapper 사용

<beans:property name="objectMapper">

<beans:ref bean="objectMapper"/>

</beans:property>

</beans:bean>

<beans:bean class="org.springframework.http.converter.FormHttpMessageConverter">

</beans:bean>

</util:list>

</beans:property>

</beans:bean>

//카멜케이스를 언더 스코어로 해주는 bean 등록

<beans:bean id="objectMapper" class="org.springframework.http.converter.json.Jackson2ObjectMapperFactoryBean" autowire="no">

<beans:property name="propertyNamingStrategy" value="CAMEL_CASE_TO_LOWER_CASE_WITH_UNDERSCORES" /> 

</beans:bean>

tomcat에서 waspool 설정시

tomcat의 Server.xml 에 resource를 수정하게 되는데

기존의

<Resource auth="Container" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" name="UserDatabase" pathname="conf/tomcat-users.xml" type="org.apache.catalina.UserDatabase"/>

을 지우지 않고

<Resource auth="Container" defaultAutoCommit="false" driverClassName="org.mariadb.jdbc.Driver" factory="org.apache.commons.dbcp.BasicDataSourceFactory" initialSize="2" maxActive="10" maxIdle="5" maxWait="15000" minIdle="2" name="jdbc/atvbo" password="1234" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/atv" username="root" validationQuery="SELECT 1"/>

위와 같이 추가하게되면

 javax.naming.NameNotFoundException

발생 하게된다.

그럴 경우 기존 resource를 지우거나 주석 처리하고 새로운 리소스를 추가하여야 한다.

WAS POOL 세팅 완성 코드

<?xml version="1.0" encoding="UTF-8"?>

<!--

  Licensed to the Apache Software Foundation (ASF) under one or more

  contributor license agreements.  See the NOTICE file distributed with

  this work for additional information regarding copyright ownership.

  The ASF licenses this file to You under the Apache License, Version 2.0

  (the "License"); you may not use this file except in compliance with

  the License.  You may obtain a copy of the License at

      http://www.apache.org/licenses/LICENSE-2.0

  Unless required by applicable law or agreed to in writing, software

  distributed under the License is distributed on an "AS IS" BASIS,

  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

  See the License for the specific language governing permissions and

  limitations under the License.

--><!-- Note:  A "Server" is not itself a "Container", so you may not

     define subcomponents such as "Valves" at this level.

     Documentation at /docs/config/server.html

 --><Server port="8005" shutdown="SHUTDOWN">

  <Listener className="org.apache.catalina.startup.VersionLoggerListener"/>

  <!-- Security listener. Documentation at /docs/config/listeners.html

  <Listener className="org.apache.catalina.security.SecurityListener" />

  -->

  <!--APR library loader. Documentation at /docs/apr.html -->

  <Listener SSLEngine="on" className="org.apache.catalina.core.AprLifecycleListener"/>

  <!-- Prevent memory leaks due to use of particular java/javax APIs-->

  <Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener"/>

  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>

  <Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener"/>

  <!-- Global JNDI resources

       Documentation at /docs/jndi-resources-howto.html

  -->

  <GlobalNamingResources>

    <!-- Editable user database that can also be used by

         UserDatabaseRealm to authenticate users

    -->

    <!-- <Resource auth="Container" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" name="UserDatabase" pathname="conf/tomcat-users.xml" type="org.apache.catalina.UserDatabase"/> -->

   <!-- WAS POOL 설정 -->

    <!-- 개발서버 -->

  <!-- 로컬서버 -->

    <Resource auth="Container" defaultAutoCommit="false" driverClassName="org.mariadb.jdbc.Driver" factory="org.apache.commons.dbcp.BasicDataSourceFactory" initialSize="2" maxActive="10" maxIdle="5" maxWait="15000" minIdle="2" name="jdbc/프로젝트 이름" password="1234" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/atv" username="root" validationQuery="SELECT 1"/>

  </GlobalNamingResources>

  <!-- A "Service" is a collection of one or more "Connectors" that share

       a single "Container" Note:  A "Service" is not itself a "Container",

       so you may not define subcomponents such as "Valves" at this level.

       Documentation at /docs/config/service.html

   -->

  <Service name="Catalina">

    <!--The connectors can use a shared executor, you can define one or more named thread pools-->

    <!--

    <Executor name="tomcatThreadPool" namePrefix="catalina-exec-"

        maxThreads="150" minSpareThreads="4"/>

    -->

    <!-- A "Connector" represents an endpoint by which requests are received

         and responses are returned. Documentation at :

         Java HTTP Connector: /docs/config/http.html (blocking & non-blocking)

         Java AJP  Connector: /docs/config/ajp.html

         APR (HTTP/AJP) Connector: /docs/apr.html

         Define a non-SSL/TLS HTTP/1.1 Connector on port 8080

    -->

    <Connector connectionTimeout="20000" port="8080" protocol="HTTP/1.1" redirectPort="8443"/>

    <!-- A "Connector" using the shared thread pool-->

    <!--

    <Connector executor="tomcatThreadPool"

               port="8080" protocol="HTTP/1.1"

               connectionTimeout="20000"

               redirectPort="8443" />

    -->

    <!-- Define a SSL/TLS HTTP/1.1 Connector on port 8443

         This connector uses the NIO implementation that requires the JSSE

         style configuration. When using the APR/native implementation, the

         OpenSSL style configuration is required as described in the APR/native

         documentation -->

    <!--

    <Connector port="8443" protocol="org.apache.coyote.http11.Http11NioProtocol"

               maxThreads="150" SSLEnabled="true" scheme="https" secure="true"

               clientAuth="false" sslProtocol="TLS" />

    -->

    <!-- Define an AJP 1.3 Connector on port 8009 -->

    <Connector port="8009" protocol="AJP/1.3" redirectPort="8443"/>

    <!-- An Engine represents the entry point (within Catalina) that processes

         every request.  The Engine implementation for Tomcat stand alone

         analyzes the HTTP headers included with the request, and passes them

         on to the appropriate Host (virtual host).

         Documentation at /docs/config/engine.html -->

    <!-- You should set jvmRoute to support load-balancing via AJP ie :

    <Engine name="Catalina" defaultHost="localhost" jvmRoute="jvm1">

    -->

    <Engine defaultHost="localhost" name="Catalina">

      <!--For clustering, please take a look at documentation at:

          /docs/cluster-howto.html  (simple how to)

          /docs/config/cluster.html (reference documentation) -->

      <!--

      <Cluster className="org.apache.catalina.ha.tcp.SimpleTcpCluster"/>

      -->

      <!-- Use the LockOutRealm to prevent attempts to guess user passwords

           via a brute-force attack -->

      <Realm className="org.apache.catalina.realm.LockOutRealm">

        <!-- This Realm uses the UserDatabase configured in the global JNDI

             resources under the key "UserDatabase".  Any edits

             that are performed against this UserDatabase are immediately

             available for use by the Realm.  -->

        <Realm className="org.apache.catalina.realm.UserDatabaseRealm" resourceName="UserDatabase"/>

      </Realm>

      <Host appBase="webapps" autoDeploy="true" name="localhost" unpackWARs="true">

        <!-- SingleSignOn valve, share authentication between web applications

             Documentation at: /docs/config/valve.html -->

        <!--

        <Valve className="org.apache.catalina.authenticator.SingleSignOn" />

        -->

        <!-- Access log processes all example.

             Documentation at: /docs/config/valve.html

             Note: The pattern used is equivalent to using pattern="common" -->

        <Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" pattern="%h %l %u %t &quot;%r&quot; %s %b" prefix="localhost_access_log" suffix=".txt"/>

      <Context docBase="프로젝트 기본이름" path="/프로젝트 이름" reloadable="true" source="org.eclipse.jst.jee.server:ATVweb">

      <ResourceLink global="jdbc/프로젝트이름" name="jdbc/프로젝트이름" type="javax.sql.DataSource"/>

      </Context>      

      </Host>

    </Engine>

  </Service>

</Server>

----------------------------------------------------------------------------------------------------------------------

참고 

http://www.linux-sxs.org/internet_serving/c619.html

클라이언트 에서 Form으로 submit(); 한 경우

스프링 컨트롤러에서 

@RequestParam

어노테이션을 사용하여 받으면 key, values 받아진다.

EX)

----CONTROLLER

@RequestMapping(value="/map", method = RequestMethod.POST)

public Response getMap(@RequestParam Map<String , Object> dataMap) {

Response res = new Response();

boolean result = false;

result = noticeService.insertMap(dataMap);

if(result) {

res.setData(result);

}

return res;

}

-----CLIENT

.

.

.

.

document.noticeCreateForm.submit();

return true;

}

Maven install 시 ERROR 

Window > Preferences > Java > Installed JREs > 

Add > Type 

 - Standard VM 

> JRE home

 - C:\Program Files\Java\jdk1.8.0_65 (자기 컴퓨터의 java jdk 경로)

Finish

Window > Preferences > Java > Installed JREs > 

Execution Environments 탭

JavaSE-1.8 > jdk1.8.0_65[perfect match] 선택

• DispatcherServlet에도 transation 세팅을 해줘야한다.

( Application Context의 설정이 DispatcherServlet의 설정과 공유되는것이 아니기때문에 각각 해줘야함. )

try catch 문으로 되어있으면 exception이 catch문에서 printStackTrace로 잡히기 때문에

public class UserMapperDaoImpl implements UserMapperDao{

	private SqlSession sqlSession;
	//gettter and setter for sqlSession
	@Override
	public void saveUser(User user) {
		// TODO Auto-generated method stub
		try {	
			UserMapperDao userMapper=sqlSession.getMapper(UserMapperDao.clas s);
			userMapper.saveUser(user);
			if(user.getName().equalsIgnoreCase("abc")){
				throw new Exception("Simulate Error...");
			}
		}catch(Exception e){
			e.printStackTrace();
		}
	}
}

} catch(Exception e) {

e.printStackTrace();

thows new RuntimeException();

}

OR 

Try catch 문을 없애고 

public FourPillarsData getSajuFourPillars(FourPillarsInputData inputData) throws Exception{

이렇게 처리한다.

확인방법 

트랜잭션 처리가 되었으면,

처리가 되지 않았으면,

그리고 DefaultSqlSession 객체 주소가 각각의 프로세스 처리 Session 아이디와 같아야 된다

그래야만 롤백할때 한번에 날릴수있다.

참고

http://forum.spring.io/forum/spring-projects/data/125994-transaction-not-rolling-back-in-spring-mybatis-mysql

http://lunal.tistory.com/entry/spring-mybatis-%ED%8A%B8%EB%9E%9C%EC%9E%AD%EC%85%98-%EC%84%A4%EC%A0%95