[Kalle-lumi]

Hello

I am building a webapp with a database and get an exception: “java.lang.ClassNotFoundException: com.mysql.jdbc.Driver”.

There are no problems loging in with MySql Query Browser so the database user account is set up correctly.

I have read so many FAQ and forums and installation guides and can’t see what I am missing.

Programs:
———
* Windows XP Pro SP2
* C:\Program\Java\jdk1.5.0_06
* Eclipse SDK Version: 3.1.2
* MyEclipse 4.1.0 GA
* MySql 5.0

Settings:
———
* JDK path is added to Eclipse > Window > Preferences > Java > Installed JREs
* the file mysql-connector-java-3.1.12-bin.jar is copied into C:\Program\Tomcat-5.5.15\common\lib
* the connector is added to Eclipse > Window > Preferences > My Eclipse > Application Server > Tomcat 5 > Paths > Append to classpath
* the connector is ALSO added to Eclipse > Window > Preferences > Java > Build Path > Claspath Variables

Connect code:
————-
Class.forName(“com.mysql.jdbc.Driver”);
Connection con = DriverManager.getConnection(“jdbc:mysql://localhost/webapp3?user=user3&password=password3”);
Statement stat = con.createStatement();

Some long shot questions at the end:
– Is it a problem having the connector referenced twice (se above)
– Is it a problem that this perticular connection comes from a https web server

Thanks!!
Regards,
Kalle-lumi

[Kalle-lumi]

Do you need to see any of my log files or my other settings?

Can anyone point me to one direction or help me to divide my problem into digestable chunks.

For example what is the easiest possible jsp page that should work.

*** Date: Thu Mar 23 10:22:40 CET 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_06

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.1.0 GA
Build id: 20060122-4.1-GA

*** Eclipse details:
Eclipse SDK

Version: 3.1.2
Build id: M20060118-1600

Eclipse Platform

Version: 3.1.2
Build id: M20060118-1600

Eclipse RCP

Version: 3.1.2
Build id: M20060118-1600

Eclipse Java Development Tools

Version: 3.1.2
Build id: M20060118-1600

Eclipse Plug-in Development Environment

Version: 3.1.2
Build id: M20060118-1600

Eclipse Project SDK

Version: 3.1.2
Build id: M20060118-1600

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\Program\eclipse\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
e8c_2c
-vm
C:\WINDOWS\system32\javaw.exe

!SESSION 2006-03-01 18:39:03.984 ———————————————–
eclipse.buildId=M20060118-1600
java.version=1.5.0_06
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=sv_SE
Command-line arguments: -os win32 -ws win32 -arch x86 -clean

!ENTRY org.eclipse.ui 4 4 2006-03-01 18:53:11.953
!MESSAGE Unable to find Action Set: org.objectweb.lomboz.ws.axis.AxisActionSet
!SESSION 2006-03-06 14:19:18.359 ———————————————–
eclipse.buildId=M20060118-1600
java.version=1.5.0_06
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=sv_SE
Command-line arguments: -os win32 -ws win32 -arch x86

!ENTRY com.genuitec.eclipse.wdt.jsp.debug 1 1 2006-03-16 11:48:07.921
!MESSAGE 2006-mar-16 11:48:07 com.genuitec.eclipse.wdt.jsp.jasper.compiler.Compiler ?

!ENTRY com.genuitec.eclipse.wdt.jsp.debug 1 1 2006-03-16 11:48:07.937
!MESSAGE ALLVARLIG: Env: Compile: javaFileName=/C:/DOCUME~1/BRANEM~1/LOKALA~1/Temp/myeclipse-jspcc//org/apache/jsp\login_005faction_jsp.java

!ENTRY com.genuitec.eclipse.wdt.jsp.debug 1 1 2006-03-16 11:48:07.937
!MESSAGE classpath=C:\Program\Java\jdk1.5.0_06\jre\lib\rt.jar;
C:\Program\Java\jdk1.5.0_06\jre\lib\jsse.jar;
C:\Program\Java\jdk1.5.0_06\jre\lib\jce.jar;
C:\Program\Java\jdk1.5.0_06\jre\lib\charsets.jar;
C:\Program\Java\jdk1.5.0_06\jre\lib\ext\dnsns.jar;
C:\Program\Java\jdk1.5.0_06\jre\lib\ext\localedata.jar;
C:\Program\Java\jdk1.5.0_06\jre\lib\ext\sunjce_provider.jar;
C:\Program\Java\jdk1.5.0_06\jre\lib\ext\sunpkcs11.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\activation.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\javax.servlet.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\javax.servlet.jsp.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\jboss-j2ee.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\jboss-jaxrpc.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\jboss-jsr77.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\jboss-saaj.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\mail.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\namespace.jar;
C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\xml-apis.jar;
C:\Documents and Settings\Branemark Distrib\workspace\branemark\WebRoot\WEB-INF\classes;
c:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.wdt.jsp.debug_4.1.0\lib\jasper-runtime.jar;
c:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.wdt.jsp.debug_4.1.0\lib\jsp-api.jar
cp=C:\Program\eclipse\startup.jar
cp=C:\Program\Java\jdk1.5.0_06\jre\lib\rt.jar
cp=C:\Program\Java\jdk1.5.0_06\jre\lib\jsse.jar
cp=C:\Program\Java\jdk1.5.0_06\jre\lib\jce.jar
cp=C:\Program\Java\jdk1.5.0_06\jre\lib\charsets.jar
cp=C:\Program\Java\jdk1.5.0_06\jre\lib\ext\dnsns.jar
cp=C:\Program\Java\jdk1.5.0_06\jre\lib\ext\localedata.jar
cp=C:\Program\Java\jdk1.5.0_06\jre\lib\ext\sunjce_provider.jar
cp=C:\Program\Java\jdk1.5.0_06\jre\lib\ext\sunpkcs11.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\activation.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\javax.servlet.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\javax.servlet.jsp.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\jboss-j2ee.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\jboss-jaxrpc.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\jboss-jsr77.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\jboss-saaj.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\mail.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\namespace.jar
cp=C:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_4.1.0\data\libraryset\1.4\xml-apis.jar
cp=C:\Documents and Settings\Branemark Distrib\workspace\branemark\WebRoot\WEB-INF\classes
cp=c:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.wdt.jsp.debug_4.1.0\lib\jasper-runtime.jar
cp=c:\Program\MyEclipse\Workbench\eclipse\plugins\com.genuitec.eclipse.wdt.jsp.debug_4.1.0\lib\jsp-api.jar
work dir=C:\DOCUME~1\BRANEM~1\LOKALA~1\Temp\myeclipse-jspcc
extension dir=C:\Program\Java\jre1.5.0_06\lib\ext
srcDir=C:\DOCUME~1\BRANEM~1\LOKALA~1\Temp\myeclipse-jspcc
compiler=extJavac
include=org/apache/jsp/login_005faction_jsp.java

!SESSION 2006-03-16 17:29:40.468 ———————————————–
eclipse.buildId=M20060118-1600
java.version=1.5.0_06
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=sv_SE
Command-line arguments: -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.ui 4 0 2006-03-17 14:36:05.921
!MESSAGE Warning: Detected recursive attempt by part com.genuitec.eclipse.webdesigner.jsp to create itself (this is probably, but not necessarily, a bug)
!STACK 1
org.eclipse.ui.PartInitException: Warning: Detected recursive attempt by part com.genuitec.eclipse.webdesigner.jsp to create itself (this is probably, but not necessarily, a bug)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:543)
at org.eclipse.ui.internal.EditorReference.getEditor(EditorReference.java:223)
at org.eclipse.ui.internal.EditorManager.findEditor(EditorManager.java:477)
at org.eclipse.ui.internal.EditorManager.findEditor(EditorManager.java:402)
at org.eclipse.ui.internal.EditorManager.findEditor(EditorManager.java:372)
at org.eclipse.ui.internal.WorkbenchPage.findEditor(WorkbenchPage.java:1780)
at com.genuitec.eclipse.core.util.EditorUtil.getEditorForInput(EditorUtil.java:156)
at com.genuitec.eclipse.core.util.EditorUtil.checkConflictingEditor(EditorUtil.java:217)
at com.genuitec.eclipse.webdesigner2.HTMLMultiPageEditorPart.init(HTMLMultiPageEditorPart.java:873)
at org.eclipse.ui.internal.EditorManager.createSite(EditorManager.java:778)
at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:596)
at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:384)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:552)
at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:283)
at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:126)
at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:269)
at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:391)
at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1102)
at org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:1051)
at org.eclipse.ui.internal.PartStack.presentationSelectionChanged(PartStack.java:785)
at org.eclipse.ui.internal.PartStack.access$0(PartStack.java:771)
at org.eclipse.ui.internal.PartStack$1.selectPart(PartStack.java:119)
at org.eclipse.ui.internal.presentations.BasicPartList.gotoSelectedElement(BasicPartList.java:242)
at org.eclipse.ui.internal.presentations.AbstractTableInformationControl$4.mouseUp(AbstractTableInformationControl.java:302)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:137)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)
!SUBENTRY 1 org.eclipse.ui 4 0 2006-03-17 14:36:05.921
!MESSAGE Warning: Detected recursive attempt by part com.genuitec.eclipse.webdesigner.jsp to create itself (this is probably, but not necessarily, a bug)
!SESSION 2006-03-21 14:54:21.765 ———————————————–
eclipse.buildId=M20060118-1600
java.version=1.5.0_06
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=sv_SE
Command-line arguments: -os win32 -ws win32 -arch x86 -clean

!ENTRY org.eclipse.ui 4 0 2006-03-21 18:50:36.812
!MESSAGE Warning: Detected recursive attempt by part com.genuitec.eclipse.webdesigner.jsp to create itself (this is probably, but not necessarily, a bug)
!STACK 1
org.eclipse.ui.PartInitException: Warning: Detected recursive attempt by part com.genuitec.eclipse.webdesigner.jsp to create itself (this is probably, but not necessarily, a bug)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:543)
at org.eclipse.ui.internal.EditorReference.getEditor(EditorReference.java:223)
at org.eclipse.ui.internal.EditorManager.findEditor(EditorManager.java:477)
at org.eclipse.ui.internal.EditorManager.findEditor(EditorManager.java:402)
at org.eclipse.ui.internal.EditorManager.findEditor(EditorManager.java:372)
at org.eclipse.ui.internal.WorkbenchPage.findEditor(WorkbenchPage.java:1780)
at com.genuitec.eclipse.core.util.EditorUtil.getEditorForInput(EditorUtil.java:156)
at com.genuitec.eclipse.core.util.EditorUtil.checkConflictingEditor(EditorUtil.java:217)
at com.genuitec.eclipse.webdesigner2.HTMLMultiPageEditorPart.init(HTMLMultiPageEditorPart.java:873)
at org.eclipse.ui.internal.EditorManager.createSite(EditorManager.java:778)
at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:596)
at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:384)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:552)
at org.eclipse.ui.internal.EditorReference.getEditor(EditorReference.java:223)
at org.eclipse.ui.internal.EditorManager.findEditor(EditorManager.java:477)
at org.eclipse.ui.internal.EditorManager.findEditor(EditorManager.java:402)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2311)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2295)
at org.eclipse.ui.internal.WorkbenchPage.access$9(WorkbenchPage.java:2287)
at org.eclipse.ui.internal.WorkbenchPage$9.run(WorkbenchPage.java:2273)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2268)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2249)
at org.eclipse.ui.ide.IDE.openEditor(IDE.java:371)
at org.eclipse.ui.ide.IDE.openEditor(IDE.java:334)
at org.eclipse.jdt.internal.ui.javaeditor.EditorUtility.openInEditor(EditorUtility.java:251)
at org.eclipse.jdt.internal.ui.javaeditor.EditorUtility.openInEditor(EditorUtility.java:131)
at org.eclipse.jdt.internal.ui.actions.OpenActionUtil.open(OpenActionUtil.java:49)
at org.eclipse.jdt.ui.actions.OpenAction.run(OpenAction.java:169)
at org.eclipse.jdt.ui.actions.OpenAction.run(OpenAction.java:153)
at org.eclipse.jdt.ui.actions.SelectionDispatchAction.dispatchRun(SelectionDispatchAction.java:222)
at org.eclipse.jdt.ui.actions.SelectionDispatchAction.run(SelectionDispatchAction.java:198)
at org.eclipse.jdt.internal.ui.packageview.PackageExplorerActionGroup.handleOpen(PackageExplorerActionGroup.java:296)
at org.eclipse.jdt.internal.ui.packageview.PackageExplorerPart$4.open(PackageExplorerPart.java:869)
at org.eclipse.jface.viewers.StructuredViewer$2.run(StructuredViewer.java:741)
at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044)
at org.eclipse.core.runtime.Platform.run(Platform.java:783)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148)
at org.eclipse.jface.viewers.StructuredViewer.fireOpen(StructuredViewer.java:739)
at org.eclipse.jface.viewers.StructuredViewer.handleOpen(StructuredViewer.java:968)
at org.eclipse.jface.viewers.StructuredViewer$6.handleOpen(StructuredViewer.java:1067)
at org.eclipse.jface.util.OpenStrategy.fireOpenEvent(OpenStrategy.java:243)
at org.eclipse.jface.util.OpenStrategy.access$2(OpenStrategy.java:238)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:277)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)
!SUBENTRY 1 org.eclipse.ui 4 0 2006-03-21 18:50:36.812
!MESSAGE Warning: Detected recursive attempt by part com.genuitec.eclipse.webdesigner.jsp to create itself (this is probably, but not necessarily, a bug)

[Riyad Kalla]

Kalle-lumi,
I’m really sorry for the delay, this didn’t popup in my unread list. The problem is you need to copy your driver to the /lib dir of the application server you are deploying to (common/lib for Tomcat). After that the app server will be able to find the driver and fire it up in your app for you.

[Kalle-lumi]

Hello again

This are my settings (see below) and as you can se I already have put the driver in the tomcat common/lib directory. So do you have any other suggestions?

thanks

kalle-lumi

Settings:
———
* JDK path is added to Eclipse > Window > Preferences > Java > Installed JREs
* the file mysql-connector-java-3.1.12-bin.jar is copied into C:\Program\Tomcat-5.5.15\common\lib
* the connector is added to Eclipse > Window > Preferences > My Eclipse > Application Server > Tomcat 5 > Paths > Append to classpath
* the connector is ALSO added to Eclipse > Window > Preferences > Java > Build Path > Claspath Variables

[Kalle-lumi]

We have found the solution and recreated the whole project from scrach. The problem was that the customer gave me a load of GoLive generated web pages with a spagettis structure of javascript and jsp code snippets… Thanks for your work… Cheers and 1000 thanks 🙂

kalle-lumi

[Riyad Kalla]

Glad it’s working now, thank you for following up.

[Author]

Posts