Java Spring mysql 연동시 root.xml

mysql 로 연결 하려면 

serverTimeZone 설정과 

java 에서 mysql procedure call 을 사용하기위해 noAccessToProcedureBodies=true 설정이 필요하다 

 

	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
		<property name="url" value="jdbc:mysql://localhost:3306/DB이름?serverTimezone=UTC&amp;noAccessToProcedureBodies=true"/>
			<property name="username" value="DB이름"/>
			<property name="password" value="비밀번호" />
	</bean>