mysql 연결
- 작성자 :
- 김*수
- 작성일 :
- 2010-12-23 11:20:56
- 조회수 :
- 3,512
- 구분 :
- 실행환경
- 진행상태 :
- 완료
Q
context-datasource.xml 내용입니다.
<bean id="dataSource-mysql" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="net.sf.log4jdbc.DriverSpy"/>
<property name="url" value="jdbc:mysql://localhost:3306/com" />
<property name="username" value="com"/>
<property name="password" value="com01"/>
</bean>
<alias name="dataSource-mysql" alias="dataSource"/>
위와 같이 DB연결을 설정하고 mysql Table (db, user, host)에 권한 설정을 했습니다.
그런데, mysql driver를 못 찾는것 같은데요..
심각: Servlet.service() for servlet action threw exception
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:264)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy6.userInfo(Unknown Source)
at rest.controller.client.RestClientController.userSync(RestClientController.java:79)
<bean id="dataSource-mysql" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="net.sf.log4jdbc.DriverSpy"/>
<property name="url" value="jdbc:mysql://localhost:3306/com" />
<property name="username" value="com"/>
<property name="password" value="com01"/>
</bean>
<alias name="dataSource-mysql" alias="dataSource"/>
위와 같이 DB연결을 설정하고 mysql Table (db, user, host)에 권한 설정을 했습니다.
그런데, mysql driver를 못 찾는것 같은데요..
심각: Servlet.service() for servlet action threw exception
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:264)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy6.userInfo(Unknown Source)
at rest.controller.client.RestClientController.userSync(RestClientController.java:79)
A
안녕하세요.. 김학수님..
mysql의 경우는 pom.xml에 해당 mysql 버전에 맞는 jdbc driver library를 dependency로 지정하시면 됩니다.
예)
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
추가적으로 DriverSpy가 지정된 경우는 다음도 추가하시면 됩니다.
<dependency>
<groupId>net.sf</groupId>
<artifactId>log4jdbc3</artifactId>
<version>1.1</version>
</dependency>
그럼.. 즐거운 하루되십시오.
감사합니다.
mysql의 경우는 pom.xml에 해당 mysql 버전에 맞는 jdbc driver library를 dependency로 지정하시면 됩니다.
예)
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
추가적으로 DriverSpy가 지정된 경우는 다음도 추가하시면 됩니다.
<dependency>
<groupId>net.sf</groupId>
<artifactId>log4jdbc3</artifactId>
<version>1.1</version>
</dependency>
그럼.. 즐거운 하루되십시오.
감사합니다.
