기본웹프로젝트(샘플포함)생성후 hsql -> mysql로 전환시 에러가 납니다.
- 작성자 :
- 김*영
- 작성일 :
- 2014-05-19 19:09:08
- 조회수 :
- 982
- 구분 :
- 개발환경
- 진행상태 :
- 완료
Q
수정한 파일.
1. pom.xml 아래 구문추가
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
2. sql-map-config.xml 아래처럼 수정
<sqlMapConfig>
<!-- <sqlMap resource="egovframework/sqlmap/example/sample/EgovSample_Sample_SQL.xml"/> -->
<sqlMap resource="egovframework/sqlmap/example/sample/EgovSample_Sample_SQL_mysql.xml"/>
<!-- <sqlMap resource="egovframework/sqlmap/example/sample/EgovSample_Sample_SQL_oracle.xml"/> -->
</sqlMapConfig>
3. context-datasource.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:jdbc="http://www.springframework.org/schema/jdbc"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd">
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/crud"/>
<property name="username" value="crud"/>
<property name="password" value="crud"/>
</bean>
</beans>
위와 같이 세팅했는 데 에러가 나네요. DB에는 sampledb_mysql.script를 실행해서 생성해둔 상태입니다.
1. pom.xml 아래 구문추가
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
2. sql-map-config.xml 아래처럼 수정
<sqlMapConfig>
<!-- <sqlMap resource="egovframework/sqlmap/example/sample/EgovSample_Sample_SQL.xml"/> -->
<sqlMap resource="egovframework/sqlmap/example/sample/EgovSample_Sample_SQL_mysql.xml"/>
<!-- <sqlMap resource="egovframework/sqlmap/example/sample/EgovSample_Sample_SQL_oracle.xml"/> -->
</sqlMapConfig>
3. context-datasource.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:jdbc="http://www.springframework.org/schema/jdbc"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd">
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/crud"/>
<property name="username" value="crud"/>
<property name="password" value="crud"/>
</bean>
</beans>
위와 같이 세팅했는 데 에러가 나네요. DB에는 sampledb_mysql.script를 실행해서 생성해둔 상태입니다.
A
안녕하세요. 김우영님
pom.xml에 dbcp 관련 라이브러리를 추가하시면 됩니다.
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.3</version>
</dependency>
고맙습니다.
pom.xml에 dbcp 관련 라이브러리를 추가하시면 됩니다.
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.3</version>
</dependency>
고맙습니다.