dltjdgur327

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.

기본적으로 safe mode가 적용되어 있어 바로 update나 delete가 불가능한 상태이다.

이를 해결하기 위한 방법은 2가지가 존재한다.

1. 명령어를 이용하는 방법

SET SQL_SAFE_UPDATES = 0;

2. workbench 설정변경

edit - preferences - sql editor

아래의 체크를 해제하면 된다.

2018--10-21 update

java-version 1.8

spring-version 5.0.7

javax.servlet 3.1.0

mybatis

<!--?xml version="1.0" encoding="UTF-8"?-->
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
	<modelversion>4.0.0</modelversion>
	<groupid>org.zerock</groupid>
	<artifactid>controller</artifactid>
	<name>ex02</name>
	<packaging>war</packaging>
	<version>1.0.0-BUILD-SNAPSHOT</version>
	<properties>
		<java-version>1.8</java-version>
		<org.springframework-version>5.0.7.RELEASE</org.springframework-version>
		<org.aspectj-version>1.6.10</org.aspectj-version>
		<org.slf4j-version>1.6.6</org.slf4j-version>
	</properties>
	<dependencies>

		<!-- Spring -->
		<dependency>
			<groupid>org.springframework</groupid>
			<artifactid>spring-context</artifactid>
			<version>${org.springframework-version}</version>
			<exclusions>
				<!-- Exclude Commons Logging in favor of SLF4j -->
				<exclusion>
					<groupid>commons-logging</groupid>
					<artifactid>commons-logging</artifactid>
				 </exclusion>
			</exclusions>
		</dependency>

		<dependency>
			<groupid>org.springframework</groupid>
			<artifactid>spring-webmvc</artifactid>
			<version>${org.springframework-version}</version>
		</dependency>

		<dependency>
			<groupid>org.springframework</groupid>
			<artifactid>spring-test</artifactid>
			<version>${org.springframework-version}</version>
		</dependency>
		
		<dependency>
			<groupid>org.springframework</groupid>
			<artifactid>spring-tx</artifactid>
			<version>${org.springframework-version}</version>
		</dependency>
		
		<dependency>
			<groupid>org.springframework</groupid>
			<artifactid>spring-jdbc</artifactid>
			<version>${org.springframework-version}</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
		<dependency>
			<groupid>org.mybatis</groupid>
			<artifactid>mybatis</artifactid>
			<version>3.4.6</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
		<dependency>
			<groupid>org.mybatis</groupid>
			<artifactid>mybatis-spring</artifactid>
			<version>1.3.2</version>
		</dependency>

		<!-- AspectJ -->
		<dependency>
			<groupid>org.aspectj</groupid>
			<artifactid>aspectjrt</artifactid>
			<version>${org.aspectj-version}</version>
		</dependency>	
		
		<!-- Logging -->
		<dependency>
			<groupid>org.slf4j</groupid>
			<artifactid>slf4j-api</artifactid>
			<version>${org.slf4j-version}</version>
		</dependency>

		<dependency>
			<groupid>org.slf4j</groupid>
			<artifactid>jcl-over-slf4j</artifactid>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>

		<dependency>
			<groupid>org.slf4j</groupid>
			<artifactid>slf4j-log4j12</artifactid>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>

		<dependency>
			<groupid>log4j</groupid>
			<artifactid>log4j</artifactid>
			<version>1.2.15</version>
			<exclusions>
				<exclusion>
					<groupid>javax.mail</groupid>
					<artifactid>mail</artifactid>
				</exclusion>
				<exclusion>
					<groupid>javax.jms</groupid>
					<artifactid>jms</artifactid>
				</exclusion>
				<exclusion>
					<groupid>com.sun.jdmk</groupid>
					<artifactid>jmxtools</artifactid>
				</exclusion>
				<exclusion>
					<groupid>com.sun.jmx</groupid>
					<artifactid>jmxri</artifactid>
				</exclusion>
			</exclusions>
			<scope>runtime</scope>
		</dependency>

		<!-- @Inject -->
		<dependency>
			<groupid>javax.inject</groupid>
			<artifactid>javax.inject</artifactid>
			<version>1</version>
		</dependency>
				
		<!-- Servlet -->
		<dependency>
			<groupid>javax.servlet</groupid>
			<artifactid>javax.servlet-api</artifactid>
			<version>3.1.0</version>
			<scope>provided</scope>
		</dependency>

		<dependency>
			<groupid>javax.servlet.jsp</groupid>
			<artifactid>jsp-api</artifactid>
			<version>2.1</version>
			<scope>provided</scope>
		</dependency>

		<dependency>
			<groupid>javax.servlet</groupid>
			<artifactid>jstl</artifactid>
			<version>1.2</version>
		</dependency>

		<!-- Test -->
		<dependency>
			<groupid>junit</groupid>
			<artifactid>junit</artifactid>
			<version>4.12</version>
			<scope>test</scope>
		</dependency>

	</dependencies>
	<build>
		<plugins>
			<plugin>
				<artifactid>maven-eclipse-plugin</artifactid>
				<version>2.9</version>
				<configuration>
					<additionalprojectnatures>
						<projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>
					</additionalprojectnatures>
					<additionalbuildcommands>
						<buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>
					</additionalbuildcommands>
					<downloadsources>true</downloadsources>
					<downloadjavadocs>true</downloadjavadocs>
				</configuration>
			</plugin>
			<plugin>
				<groupid>org.apache.maven.plugins</groupid>
				<artifactid>maven-compiler-plugin</artifactid>
				<version>2.5.1</version>
				<configuration>
					<source>1.8
					<target>1.8</target>
					<compilerargument>-Xlint:all</compilerargument>
					<showwarnings>true</showwarnings>
					<showdeprecation>true</showdeprecation>
				</configuration>
			</plugin>
			<plugin>
				<groupid>org.codehaus.mojo</groupid>
				<artifactid>exec-maven-plugin</artifactid>
				<version>1.2.1</version>
				<configuration>
					<mainclass>org.test.int1.Main</mainclass>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

오늘은 Dynamic Web Project 에서 maven을 적용하는 방법을 알아보겠습니다.

먼저 Dynamic Web Project를 생성하도록 하겠습니다.

우클릭 - New - Dynamic Web Project

그리고 Project name을 적어준 뒤 Finish를 눌러줍니다.

만들어진 프로젝트에서 우클릭 - Configure - Convert to Maven Project 를 클릭!

그리고 다른 설정은 건들지 않고 바로 Finish를 눌러줍니다.

이렇게 되면 기존에 없던 pom.xml 이 생성되고 여기에서 라이브러리를 관리할 수 있게 됩니다.