If the exception “Could not get JDBC Connection; nested exception is java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/schema” is raised probably you forgot to add the
<property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property> |
property to your dataSource bean:
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property> <property name="url"><value>jdbc:mysql://172.16.0.11:3306/test_vale</value></property> <property name="username"><value>root</value></property> <property name="password"><value>password</value></property> </bean> |