No suitable driver found for jdbc:mysql from tomcat 8.0 -
No suitable driver found for jdbc:mysql from tomcat 8.0 -
i trying application in tomcat 8.0, error
org.springframework.jdbc.cannotgetjdbcconnectionexception: not jdbc connection; nested exception java.sql.sqlexception: no suitable driver found jdbc:mysql://ip:3306/durga_dev?characterencoding=utf-8
at org.springframework.jdbc.datasource.datasourceutils.getconnection(datasourceutils.java:80) ~[spring-jdbc-4.1.6.release.jar:4.1.6.release] @ org.springframework.jdbc.core.jdbctemplate.execute(jdbctemplate.java:630) ~[spring-jdbc-4.1.6.release.jar:4.1.6.release] @ org.springframework.jdbc.core.jdbctemplate.query(jdbctemplate.java:695) ~[spring-jdbc-4.1.6.release.jar:4.1.6.release] @ org.springframework.jdbc.core.jdbctemplate.query(jdbctemplate.java:727) ~[spring-jdbc-4.1.6.release.jar:4.1.6.release] @ org.springframework.jdbc.core.jdbctemplate.query(jdbctemplate.java:737) ~[spring-jdbc-4.1.6.release.jar:4.1.6.release] @ org.springframework.jdbc.core.jdbctemplate.query(jdbctemplate.java:787) ~[spring-jdbc-4.1.6.release.jar:4.1.6.release] i using
tomcat 8.0.21 spring 4.1.6 mysql conector : mysql-connector-java-5.1.27.jarmy context.xml file given below.
context.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:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p" xmlns:util="http://www.springframework.org/schema/util" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemalocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd"> <bean id="datasourceproperties" class="org.springframework.beans.factory.config.propertyplaceholderconfigurer"> <property name="locations"> <list> <value>classpath:meta-inf/config/datasource.properties</value> </list> </property> <property name="ignoreunresolvableplaceholders" value="true"/> </bean> <bean id="batchupdatedatasource" class="org.springframework.jdbc.datasource.drivermanagerdatasource"> <property name="driverclassname"> <value>com.mysql.jdbc.jdbc2.optional.mysqldatasource</value> </property> <property name="url"> <value>${jdbc.components.url.durga}</value> </property> <property name="username"> <value>${jdbc.components.username.durga}</value> </property> <property name="password"> <value>${jdbc.components.password.durga}</value> </property> </bean> <bean id="batchjdbctemplate" class="com.nri.durga.maf.batch.mafbatchjdbctemplate"> <constructor-arg type="org.springframework.jdbc.datasource.drivermanagerdatasource" ref="batchupdatedatasource" /> </bean> <bean id="global" class="com.mysql.jdbc.jdbc2.optional.mysqldatasource" p:url="${jdbc.components.url.global}" p:user="${jdbc.components.username.global}" p:password="${jdbc.components.password.global}"> </bean> <bean id="durga" class="com.mysql.jdbc.jdbc2.optional.mysqldatasource" p:url="${jdbc.components.url.durga}" p:user="${jdbc.components.username.durga}" p:password="${jdbc.components.password.durga}"> </bean> <bean id="global-tm" class="org.springframework.orm.jpa.jpatransactionmanager"> <property name="entitymanagerfactory" ref="global-em" /> <property name="datasource" ref="global" /> </bean> <bean id="durga-tm" class="org.springframework.orm.jpa.jpatransactionmanager"> <property name="entitymanagerfactory" ref="durga-em" /> <property name="datasource" ref="durga" /> </bean> <tx:annotation-driven transaction-manager="transactionmanager"/> <bean id="jpavendoradapter" class="org.springframework.orm.jpa.vendor.hibernatejpavendoradapter"> <property name="showsql" value="false" /> <property name="generateddl" value="false" /> <property name="databaseplatform" value="${jpa.hibernate.dialectclass}" /> </bean> <bean id="global-em" class="org.springframework.orm.jpa.localcontainerentitymanagerfactorybean" p:packagestoscan="com.nrift.finch.*.model, com.nrift.finch.*.domain" p:datasource-ref="global" p:jpavendoradapter-ref="jpavendoradapter" /> <bean id="durga-em" class="org.springframework.orm.jpa.localcontainerentitymanagerfactorybean" p:packagestoscan="com.nri.durga.*.model, com.nri.durga.*.domain" p:datasource-ref="durga" p:jpavendoradapter-ref="jpavendoradapter" /> </beans> datasource.properties
jdbc.components.all=global # setting global component jdbc.components.url.global=jdbc:mysql://ip:3306/durga_dev jdbc.components.username.global=usr jdbc.components.password.global=pswd jdbc.components.minlimit.global=1 jdbc.components.maxlimit.global=200 jdbc.components.initiallimit.global=1 jdbc.components.querytimeout.global=0 # setting durga component jdbc.components.url.durga=jdbc:mysql://ip:3306/durga_dev jdbc.components.username.durga=usr jdbc.components.password.durga=pswd jdbc.components.minlimit.durga=1 jdbc.components.maxlimit.durga=200 jdbc.components.initiallimit.durga=1 jdbc.components.querytimeout.durga=0 # datasource properties mysql jdbc.database.driverclass=com.mysql.jdbc.driver jpa.hibernate.dialectclass=org.hibernate.dialect.mysql5dialect
this means mysql driver jar not in classpath. create sure in "$catalina_home/lib"
mysql spring-jdbc tomcat8
Comments
Post a Comment