Eclipse findet JDBC Treiber nicht

[rockin_duck]

Hallo Miteinander,

Ich scheitere im Moment daran, via Java eine MySQL Datenbankverbindung aufzubauen. Da ich Eclipse (V3.3) benutze, habe ich den JDBC Treiber in den Build Path des Projektes eingebunden, auch der Quellcode scheint, nachdem ich diverse Beispiele im Netz studiert habe, zu stimmen. Trotzdem kriege ich eine "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver" Exception.

Ich wäre sehr, sehr froh, wenn mir jemand bei diesem Problem weiterhelfen könnte!

Liebe Grüsse,
Elias

Source:

import java.sql.*;

public class MySQL {
	
	public MySQL() {
		 String driver = "com.mysql.jdbc.Driver";
		 String username = "root";
		 String password = "";
		 String host = "jdbc:mysql://localhost:3306/test";
		 try {
		 Class.forName(driver);
		 Connection con = DriverManager.getConnection(host,username,password);
		 Statement stmt = con.createStatement();
		 String sql = "CREATE TABLE ghost(name varchar(30))";
		 stmt.executeUpdate(sql);
		 } catch (ClassNotFoundException e1) {
		 System.out.println(e1.getMessage());
		 e1.printStackTrace();
		 } catch (SQLException e2) {
		 System.out.println(e2.getMessage());
		 e2.printStackTrace();
		 }
	}
}

Stacktrace:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at cashman.exercise.MySQL.<init>(MySQL.java:13)
at cashman.exercise.AdressData.<init>(AdressData.java:30)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sun.faces.config.ManagedBeanFactoryImpl.newInstance(ManagedBeanFactoryImpl.java:277)
at com.sun.faces.application.ApplicationAssociate.createAndMaybeStoreManagedBeans(ApplicationAssociate.java:531)
at com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:82)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
at org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:45)
at org.apache.el.parser.AstValue.getValue(AstValue.java:86)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at com.sun.faces.application.ValueBindingValueExpressionAdapter.getValue(ValueBindingValueExpressionAdapter.java:102)
at com.infragistics.faces.shared.helpers.DataBindingHelper.getParameterisedBoundProperty(DataBindingHelper.java:695)
at com.infragistics.faces.shared.component.DataRepeater.getDataSourceValueBinding(DataRepeater.java:681)
at com.infragistics.faces.shared.component.DataRepeater.getDataSource(DataRepeater.java:665)
at com.infragistics.faces.shared.component.DataRepeater.getDataModel(DataRepeater.java:637)
at com.infragistics.faces.shared.component.DataList.getDataModel(DataList.java:181)
at com.infragistics.faces.shared.component.DataRepeater.createChildHierarchy(DataRepeater.java:442)
at com.infragistics.faces.shared.component.DataRepeater.dataBind(DataRepeater.java:496)
at com.infragistics.faces.shared.component.DataRepeater.encodeBegin(DataRepeater.java:515)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:269)
at com.sun.faces.renderkit.html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:117)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:809)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:271)
at com.sun.faces.renderkit.html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:117)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:809)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:137)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:809)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)
at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:244)
at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:175)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

 

[SlaterB]

die Klasse ist zur Ausführung nicht bekannt,
der Buildpath spielt dafür keine Rolle,

unter Run musst du die Run-Konfiguration bearbeiten,
das Jar in den Classpath einfügen

 

[rockin_duck]

Wow, danke für die schnelle Antwort, funktioniert jetzt einwandfrei!

Liebe Grüsse!