pulsedrone [
https://community.jboss.org/people/pulsedrone] created the discussion
"No suitable driver found for jdbc:mysql://localhost:3306/test"
To view the discussion, visit:
https://community.jboss.org/message/827505#827505
--------------------------------------------------------------
Hello, im using JBoss 7.1.1 AS, Mysql Connector 5.1.24. i googled a lot and found many
posts relating this topic and i tried all solution but nothing works for me. So i hope
here anyone can help. This is my standalone.xml:
jdbc:mysql://localhost:3306/test
mysql root
root
false
false
false
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource The module.xml:
the hibernate.cfg.xml:
root root
thread com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/test org.hibernate.dialect.MySQLDialect 5
i created the folder JBOSSHOME/modules/com/mysql/main and iside are the module.xml
and the connector jar file. Further i have the jar file included into WEB-INF/lib folder
and added it to the class path. The exception: ERROR
[org.hibernate.tool.hbm2ddl.SchemaExport] (http-localhost-127.0.0.1-8080-1) HHH000231:
Schema export unsuccessful: java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/test at
java.sql.DriverManager.getConnection(DriverManager.java:602) [classes.jar:1.6.0_51]
at java.sql.DriverManager.getConnection(DriverManager.java:154)
[classes.jar:1.6.0_51] at
org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:173)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.tool.hbm2ddl.DatabaseExporter.(DatabaseExporter.java:52)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:368)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:305)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:294)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:452)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1737)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
MyApp.WebApp.util.HibernateUtil.(HibernateUtil.java:26) [classes:] at
MyApp.WebApp.model.Member.save(Member.java:152) [classes:] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [classes.jar:1.6.0_51] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[classes.jar:1.6.0_51] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[classes.jar:1.6.0_51] at java.lang.reflect.Method.invoke(Method.java:597)
[classes.jar:1.6.0_51] at org.apache.el.parser.AstValue.invoke(AstValue.java:262)
[jbossweb-7.0.13.Final.jar:] at
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.13.Final.jar:] at
org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:39)
[weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at
org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50)
[weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at
com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.7-jbossorg-2.jar:] at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.7-jbossorg-2.jar:] at
javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.7-jbossorg-2.jar:] at
com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl-2.1.7-jbossorg-2.jar:]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.7-jbossorg-2.jar:] at
javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.13.Final.jar:] at
org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
[weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.13.Final.jar:] at
org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
[jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final] at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
[jboss-as-web-7.1.1.Final.jar:7.1.1.Final] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
[jbossweb-7.0.13.Final.jar:] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
[jbossweb-7.0.13.Final.jar:] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
[jbossweb-7.0.13.Final.jar:] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
[jbossweb-7.0.13.Final.jar:] at java.lang.Thread.run(Thread.java:680)
[classes.jar:1.6.0_51] 11:30:30,393 INFO [org.hibernate.tool.hbm2ddl.SchemaExport]
(http-localhost-127.0.0.1-8080-1) HHH000230: Schema export complete 11:30:30,457 WARN
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost-127.0.0.1-8080-1) SQL
Error: 0, SQLState: 08001 11:30:30,458 ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost-127.0.0.1-8080-1) No
suitable driver found for jdbc:mysql://localhost:3306/test 11:30:30,461 WARNUNG
[javax.enterprise.resource.webcontainer.jsf.lifecycle] (http-localhost-127.0.0.1-8080-1)
#{Member.save}: org.hibernate.exception.JDBCConnectionException: Could not open
connection: javax.faces.FacesException: #{Member.save}:
org.hibernate.exception.JDBCConnectionException: Could not open connection at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
[jsf-impl-2.1.7-jbossorg-2.jar:] at
javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.7-jbossorg-2.jar:] at
com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl-2.1.7-jbossorg-2.jar:]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.7-jbossorg-2.jar:] at
javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.13.Final.jar:] at
org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
[weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.13.Final.jar:] at
org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
[jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final] at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
[jboss-as-web-7.1.1.Final.jar:7.1.1.Final] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.13.Final.jar:] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
[jbossweb-7.0.13.Final.jar:] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
[jbossweb-7.0.13.Final.jar:] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
[jbossweb-7.0.13.Final.jar:] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
[jbossweb-7.0.13.Final.jar:] at java.lang.Thread.run(Thread.java:680)
[classes.jar:1.6.0_51] Caused by: javax.faces.el.EvaluationException:
org.hibernate.exception.JDBCConnectionException: Could not open connection at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.7-jbossorg-2.jar:] ... 24 more Caused by:
org.hibernate.exception.JDBCConnectionException: Could not open connection at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:131)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:304)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:169)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1263)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
MyApp.WebApp.model.Member.save(Member.java:154) [classes:] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [classes.jar:1.6.0_51] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[classes.jar:1.6.0_51] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[classes.jar:1.6.0_51] at java.lang.reflect.Method.invoke(Method.java:597)
[classes.jar:1.6.0_51] at org.apache.el.parser.AstValue.invoke(AstValue.java:262)
[jbossweb-7.0.13.Final.jar:] at
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.13.Final.jar:] at
org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:39)
[weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at
org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50)
[weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at
com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.7-jbossorg-2.jar:] at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final] ... 25 more Caused by:
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
[classes.jar:1.6.0_51] at
java.sql.DriverManager.getConnection(DriverManager.java:154) [classes.jar:1.6.0_51]
at
org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:173)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:276)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297)
[hibernate-core-4.0.1.Final.jar:4.0.1.Final] ... 40 more If anyone may help?
--------------------------------------------------------------
Reply to this message by going to Community
[
https://community.jboss.org/message/827505#827505]
Start a new discussion in JBoss AS 7 Development at Community
[
https://community.jboss.org/choose-container!input.jspa?contentType=1&...]