SQLNestedException: Cannot create JDBC driver

27 de julho de 2010 6 respostas

vinicius_roc 27 de julho de 2010

Olah pessoal,

Estou com um problema que não tenho ideia do que seja.

Aparentemente esta tudo ok, porem esta dando uma sessão. Vou postar o web.xml e o server.xml para vocês darem uma olhada para poderem me ajudar.

Web.xml

<resource-ref> <description>ACOL DataSource</description> <res-ref-name>jdbc/ACOLDS</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>

Server.xml

<Context docBase="acol" path="/acol" reloadable="false" source="org.eclipse.jst.jee.server:acol"> <Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="100" maxIdle="100" maxWait="10000" name="jdbc/ACOLDS" password="senha" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/meu_banco" username="root"/> </Context>

Valew pela ajuda pessoal não sei mais oque fazer.

Segue a excessão abaixo:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class ‘’ for connect URL ‘null’

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)

at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114)

at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)

at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)

at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774)

at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)

at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4323)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4771)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)

at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:990)

at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:772)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)

at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:990)

at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:275)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)

at org.apache.catalina.core.StandardService.startInternal(StandardService.java:424)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)

at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:648)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:138)

at org.apache.catalina.startup.Catalina.start(Catalina.java:576)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:415)

Caused by: java.lang.NullPointerException

at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)

at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)

at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)

at java.sql.DriverManager.getDriver(DriverManager.java:253)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)

… 45 more

6 Respostas

vinicius_roc 27 de jul. de 2010

Não sei se ajuda mas antes da excessão tem essas 3 linhas

3195 [main] INFO org.hibernate.cfg.search.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
3230 [main] INFO org.hibernate.connection.ConnectionProviderFactory - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
3237 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null

Hebert_Coelho 27 de jul. de 2010

Cara, onde que está seu JDBC JAR?

vinicius_roc 27 de jul. de 2010

Bom,

O driver do mysql esta na pasta lib do tomcat. O do jdbc que eu tenho esta na lib da minha aplicação junto com os outros do hibernate

org.springframework.jdbc-3.0.2.RELEASE.jar

hibernate3.jar
hibernate-jpa-2.0-api-1.0.0.Final.jar
slf4j-simple-1.5.8.jar
jta-1.1.jar
javassist-3.9.0.GA.jar
c3p0-0.9.1.jar
dom4j-1.6.1
commons-collections-3.1
antlr-2.7.6
ehcache-1.5.0.jar

vinicius_roc 27 de jul. de 2010

Tentei mudar o jeito como faço mas pareceu q piorou. =/

Onde estou errando e qual maneira e a mais indicada? Antes de mudar para o Tomcat 7 funcionava muito bem assim. =[

Mudei o resource para o GlobalNamingResources

<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="100" maxIdle="100" maxWait="10000" name="global/jdbc/acol" password="senha" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/meu_banco" username="usuario"/>

e indiquei no META-INF/context.xml

<Context> <ResourceLink name="jdbc/ACOLDS" global="global/jdbc/acol" type="javax.sql.DataSource"/> </Context>

Deu a seguinte a excessão:

27/07/2010 10:33:02 org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: F:\JAVA\jdk1.6.0_19\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;F:\JAVA\jdk1.6.0_19\jre\bin;W:/java/jdk1.6.0_13/bin/…/jre/bin/client;W:/java/jdk1.6.0_13/bin/…/jre/bin;W:/java/jdk1.6.0_13/bin/…/jre/lib/i386;W:\java\jdk1.6.0_13\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WindowsPowerShell\v1.0;W:\java\atlassian-plugin-sdk-3.1.3\bin

27/07/2010 10:33:02 org.apache.tomcat.util.digester.SetPropertiesRule begin

WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source’ to ‘org.eclipse.jst.jee.server:acol’ did not find a matching property.

27/07/2010 10:33:02 org.apache.tomcat.util.digester.Digester endElement

SEVERE: End event threw exception

java.lang.NullPointerException

at org.apache.catalina.core.StandardContext.getObjectNameKeyProperties(StandardContext.java:5551)

at org.apache.catalina.core.StandardContext.setNamingResources(StandardContext.java:1757)

at org.apache.catalina.core.StandardContext.getNamingResources(StandardContext.java:1735)

at org.apache.catalina.startup.SetNextNamingRule.end(SetNextNamingRule.java:99)

at org.apache.tomcat.util.digester.Digester.endElement(Digester.java:1058)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)

at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:180)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1343)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2755)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:511)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:808)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)

at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1544)

at org.apache.catalina.startup.Catalina.load(Catalina.java:515)

at org.apache.catalina.startup.Catalina.load(Catalina.java:551)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:260)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

27/07/2010 10:33:02 org.apache.catalina.startup.Catalina load

WARNING: Catalina.start using conf/server.xml:

java.lang.NullPointerException

at org.apache.tomcat.util.digester.Digester.createSAXException(Digester.java:2688)

at org.apache.tomcat.util.digester.Digester.createSAXException(Digester.java:2714)

at org.apache.tomcat.util.digester.Digester.endElement(Digester.java:1061)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)

at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:180)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1343)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2755)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:511)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:808)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)

at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1544)

at org.apache.catalina.startup.Catalina.load(Catalina.java:515)

at org.apache.catalina.startup.Catalina.load(Catalina.java:551)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:260)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: java.lang.NullPointerException

at org.apache.catalina.core.StandardContext.getObjectNameKeyProperties(StandardContext.java:5551)

at org.apache.catalina.core.StandardContext.setNamingResources(StandardContext.java:1757)

at org.apache.catalina.core.StandardContext.getNamingResources(StandardContext.java:1735)

at org.apache.catalina.startup.SetNextNamingRule.end(SetNextNamingRule.java:99)

at org.apache.tomcat.util.digester.Digester.endElement(Digester.java:1058)

… 20 more

27/07/2010 10:33:02 org.apache.tomcat.util.digester.SetPropertiesRule begin

WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source’ to ‘org.eclipse.jst.jee.server:acol’ did not find a matching property.

27/07/2010 10:33:02 org.apache.tomcat.util.digester.Digester endElement

SEVERE: End event threw exception

java.lang.NullPointerException

at org.apache.catalina.core.StandardContext.getObjectNameKeyProperties(StandardContext.java:5551)

at org.apache.catalina.core.StandardContext.setNamingResources(StandardContext.java:1757)

at org.apache.catalina.core.StandardContext.getNamingResources(StandardContext.java:1735)

at org.apache.catalina.startup.SetNextNamingRule.end(SetNextNamingRule.java:99)

at org.apache.tomcat.util.digester.Digester.endElement(Digester.java:1058)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)

at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:180)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1343)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2755)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:511)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:808)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)

at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1544)

at org.apache.catalina.startup.Catalina.load(Catalina.java:515)

at org.apache.catalina.startup.Catalina.start(Catalina.java:564)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:415)

27/07/2010 10:33:02 org.apache.catalina.startup.Catalina load

WARNING: Catalina.start using conf/server.xml:

java.lang.NullPointerException

at org.apache.tomcat.util.digester.Digester.createSAXException(Digester.java:2688)

at org.apache.tomcat.util.digester.Digester.createSAXException(Digester.java:2714)

at org.apache.tomcat.util.digester.Digester.endElement(Digester.java:1061)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)

at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:180)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1343)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2755)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:511)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:808)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)

at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1544)

at org.apache.catalina.startup.Catalina.load(Catalina.java:515)

at org.apache.catalina.startup.Catalina.start(Catalina.java:564)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:415)

Caused by: java.lang.NullPointerException

at org.apache.catalina.core.StandardContext.getObjectNameKeyProperties(StandardContext.java:5551)

at org.apache.catalina.core.StandardContext.setNamingResources(StandardContext.java:1757)

at org.apache.catalina.core.StandardContext.getNamingResources(StandardContext.java:1735)

at org.apache.catalina.startup.SetNextNamingRule.end(SetNextNamingRule.java:99)

at org.apache.tomcat.util.digester.Digester.endElement(Digester.java:1058)

… 20 more

Hebert_Coelho 27 de jul. de 2010

É cara, eu não entendo muito de mapeamento de JDBC não, mas a mensagem que ele está passando é que ele não está conseguindo achar a Library!

27/07/2010 10:33:02 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: F:\JAVA\jdk1.6.0_19\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;F:\JAVA\jdk1.6.0_19\jre\bin;W:/java/jdk1.6.0_13/bin/…/jre/bin/client;W:/java/jdk1.6.0_13/bin/…/jre/bin;W:/java/jdk1.6.0_13/bin/…/jre/lib/i386;W:\java\jdk1.6.0_13\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WindowsPowerShell\v1.0;W:\java\atlassian-plugin-sdk-3.1.3\bin

vinicius_roc 28 de jul. de 2010

Acredito que esse não seja o problema, pois li em alguns site que isso pode ser ignorado.

Por favor me ajudem pessoal, to atrasado com essa parte e se ela não funcionar nada na aplicação funciona, o estranho é que no tomcat 6 funcionava e no 7 parou d funcionar e agora tambem não consigo voltar para o 6 q ele da a excessão javax.naming.NameNotFoundException: Name global is not bound in this Context sendo que esta tudo igual a antes.

Por favor me ajudem, estou desesperado.

Como eu devo configurar meu jndi datasource para funcionar?

Valew

Abss

Criado 27 de julho de 2010

Ultima resposta 28 de jul. de 2010

Respostas 6

Participantes 2

6 Respostas

Topicos relacionados