i have grails application works fine in environments i.e development, testing , production deploy on specific machines. have deployed war on 2 different machines not able deploy on machine. seems jtds driver not load. got following error:
2015-06-03 07:22:16,955] error initializing application: error creating bean name 'transactionmanagerpostprocessor': initialization of bean failed; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'transactionmanager': cannot resolve reference bean 'sessionfactory' while setting bean property 'sessionfactory'; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'sessionfactory': cannot resolve reference bean 'hibernateproperties' while setting bean property 'hibernateproperties'; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'hibernateproperties': cannot resolve reference bean 'dialectdetector' while setting bean property 'properties' key [hibernate.dialect]; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'dialectdetector': invocation of init method failed; nested exception org.springframework.jdbc.support.metadataaccessexception: error while extracting databasemetadata; nested exception java.sql.sqlexception: net.sourceforge.jtds.jdbc.driver org.springframework.beans.factory.beancreationexception: error creating bean name 'transactionmanagerpostprocessor': initialization of bean failed; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'transactionmanager': cannot resolve reference bean 'sessionfactory' while setting bean property 'sessionfactory'; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'sessionfactory': cannot resolve reference bean 'hibernateproperties' while setting bean property 'hibernateproperties'; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'hibernateproperties': cannot resolve reference bean 'dialectdetector' while setting bean property 'properties' key [hibernate.dialect]; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'dialectdetector': invocation of init method failed; nested exception org.springframework.jdbc.support.metadataaccessexception: error while extracting databasemetadata; nested exception java.sql.sqlexception: net.sourceforge.jtds.jdbc.driver @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:529) @ org.codehaus.groovy.grails.commons.spring.reloadawareautowirecapablebeanfactory.docreatebean(reloadawareautowirecapablebeanfactory.java:123) @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:458) @ org.springframework.beans.factory.support.abstractbeanfactory$1.getobject(abstractbeanfactory.java:296) @ org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:223) @ org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:293) @ org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:198) @ org.springframework.context.support.abstractapplicationcontext.registerbeanpostprocessors(abstractapplicationcontext.java:720) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:464) @ org.codehaus.groovy.grails.commons.spring.defaultruntimespringconfiguration.getapplicationcontext(defaultruntimespringconfiguration.java:156) @ org.codehaus.groovy.grails.commons.spring.grailsruntimeconfigurator.configure(grailsruntimeconfigurator.java:169) @ org.codehaus.groovy.grails.commons.spring.grailsruntimeconfigurator.configure(grailsruntimeconfigurator.java:127) @ org.codehaus.groovy.grails.web.context.grailsconfigutils.configurewebapplicationcontext(grailsconfigutils.java:122) @ org.codehaus.groovy.grails.web.context.grailscontextloader.initwebapplicationcontext(grailscontextloader.java:108) @ org.springframework.web.context.contextloaderlistener.contextinitialized(contextloaderlistener.java:112) @ org.apache.catalina.core.standardcontext.listenerstart(standardcontext.java:4810) @ org.apache.catalina.core.standardcontext.startinternal(standardcontext.java:5248) @ org.apache.catalina.util.lifecyclebase.start(lifecyclebase.java:150) @ org.apache.catalina.manager.managerservlet.start(managerservlet.java:1265) @ org.apache.catalina.manager.htmlmanagerservlet.start(htmlmanagerservlet.java:695) @ org.apache.catalina.manager.htmlmanagerservlet.dopost(htmlmanagerservlet.java:225) @ javax.servlet.http.httpservlet.service(httpservlet.java:647) @ javax.servlet.http.httpservlet.service(httpservlet.java:728) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:303) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) @ org.apache.catalina.filters.csrfpreventionfilter.dofilter(csrfpreventionfilter.java:213) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) @ org.apache.tomcat.websocket.server.wsfilter.dofilter(wsfilter.java:52) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) @ org.apache.catalina.filters.setcharacterencodingfilter.dofilter(setcharacterencodingfilter.java:108) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:221) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:107) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:616) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:155) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:76) @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:934) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:90) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:522) @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1015) @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:646) @ org.apache.coyote.http11.http11nioprotocol$http11connectionhandler.process(http11nioprotocol.java:223) @ org.apache.tomcat.util.net.nioendpoint$socketprocessor.dorun(nioendpoint.java:1576) @ org.apache.tomcat.util.net.nioendpoint$socketprocessor.run(nioendpoint.java:1534) @ java.util.concurrent.threadpoolexecutor.runworker(unknown source) @ java.util.concurrent.threadpoolexecutor$worker.run(unknown source) @ java.lang.thread.run(unknown source) caused by: org.springframework.beans.factory.beancreationexception: error creating bean name 'transactionmanager': cannot resolve reference bean 'sessionfactory' while setting bean property 'sessionfactory'; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'sessionfactory': cannot resolve reference bean 'hibernateproperties' while setting bean property 'hibernateproperties'; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'hibernateproperties': cannot resolve reference bean 'dialectdetector' while setting bean property 'properties' key [hibernate.dialect]; nested exception org.springframework.beans.factory.beancreationexception: error creating bean name 'dialectdetector': invocation of init method failed; nested exception org.springframework.jdbc.support.metadataaccessexception: error while extracting databasemetadata; nested exception java.sql.sqlexception: net.sourceforge.jtds.jdbc.driver caused by: java.sql.sqlexception: net.sourceforge.jtds.jdbc.driver @ org.apache.tomcat.jdbc.pool.pooledconnection.connectusingdriver(pooledconnection.java:254) @ org.apache.tomcat.jdbc.pool.pooledconnection.connect(pooledconnection.java:182) @ org.apache.tomcat.jdbc.pool.connectionpool.createconnection(connectionpool.java:701) @ org.apache.tomcat.jdbc.pool.connectionpool.borrowconnection(connectionpool.java:635) @ org.apache.tomcat.jdbc.pool.connectionpool.init(connectionpool.java:486) @ org.apache.tomcat.jdbc.pool.connectionpool.<init>(connectionpool.java:144) @ org.apache.tomcat.jdbc.pool.datasourceproxy.pcreatepool(datasourceproxy.java:116) @ org.apache.tomcat.jdbc.pool.datasourceproxy.createpool(datasourceproxy.java:103) @ org.apache.tomcat.jdbc.pool.datasourceproxy.getconnection(datasourceproxy.java:127) @ org.springframework.jdbc.datasource.lazyconnectiondatasourceproxy$lazyconnectioninvocationhandler.gettargetconnection(lazyconnectiondatasourceproxy.java:400) @ org.springframework.jdbc.datasource.lazyconnectiondatasourceproxy$lazyconnectioninvocationhandler.invoke(lazyconnectiondatasourceproxy.java:375) @ com.sun.proxy.$proxy78.getmetadata(unknown source) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(unknown source) @ sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) @ java.lang.reflect.method.invoke(unknown source) @ org.springframework.jdbc.datasource.transactionawaredatasourceproxy$transactionawareinvocationhandler.invoke(transactionawaredatasourceproxy.java:239) @ com.sun.proxy.$proxy78.getmetadata(unknown source) @ org.springframework.jdbc.support.jdbcutils.extractdatabasemetadata(jdbcutils.java:285) ... 98 more caused by: java.lang.classnotfoundexception: net.sourceforge.jtds.jdbc.driver @ java.net.urlclassloader$1.run(unknown source) @ java.net.urlclassloader$1.run(unknown source) @ java.security.accesscontroller.doprivileged(native method) @ java.net.urlclassloader.findclass(unknown source) @ java.lang.classloader.loadclass(unknown source) @ java.lang.classloader.loadclass(unknown source) @ java.lang.class.forname0(native method) @ java.lang.class.forname(unknown source) @ org.apache.tomcat.jdbc.pool.pooledconnection.connectusingdriver(pooledconnection.java:246) ... 116 more my datasource.groovy looks this,
datasource { pooled = true jmxexport = true driverclassname = "net.sourceforge.jtds.jdbc.driver" } hibernate { cache.use_second_level_cache = true cache.use_query_cache = false cache.region.factory_class = 'net.sf.ehcache.hibernate.ehcacheregionfactory' // hibernate 3 // cache.region.factory_class = 'org.hibernate.cache.ehcache.ehcacheregionfactory' // hibernate 4 singlesession = true // configure osiv singlesession mode } // environment specific settings environments { production { datasource { pooled = true jmxexport = true dbcreate = "update" url = "jdbc:jtds:sqlserver://localhost:1433/databasename;mvcc=true;lock_timeout=10000;db_close_on_exit=false" username = "user" password = "password" driverclassname = "net.sourceforge.jtds.jdbc.driver" properties { //http://grails.org/doc/latest/guide/conf.html#datasource documentation jmxenabled = true initialsize = 5 maxactive = 50 minidle = 5 maxidle = 25 maxwait = 10000 maxage = 10 * 60000 timebetweenevictionrunsmillis = 5000 minevictableidletimemillis = 60000 validationquery = "select 1" validationquerytimeout = 3 validationinterval = 15000 testonborrow = true testwhileidle = true testonreturn = false jdbcinterceptors = "connectionstate" defaulttransactionisolation = java.sql.connection.transaction_read_committed } } } } i have jar file in lib folder under web-inf. same war file works on other machine not on specific machine. java version same on both machines (1.7.0_75). grails version 2.3.8. have tried cleaning , re-creating war file. other applications same driver install on machine. appreciated.
you can put jar file inside tomcat lib folder
Comments
Post a Comment