Forum Discussion

BenX's avatar
BenX
Contributor
17 years ago

[SOLVED]MySql

Hi!

I can't connect to database with 3.0.2:
Build 3.0-pro-daily-build-2009-11-19-[1], Build Date 2009/11/19 05:19

mysql-connector-java-5.1.7-bin.jar, sqljdbc.jar and postgresql-8.3-604.jdbc4.jar are in in ext folder. This was working good in 3.0.1.



Fri Nov 20 14:22:06 CET 2009:ERROR:java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
   java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at groovy.sql.Sql.loadDriver(Sql.java:291)
    at groovy.sql.Sql.newInstance(Sql.java:184)
    at groovy.sql.Sql$newInstance.call(Unknown Source)
    at Script1.run(Script1.groovy:4)
    at com.eviware.soapui.support.scripting.groovy.SoapUIGroovyScriptEngine.run(SoapUIGroovyScriptEngine.java:93)
    at com.eviware.soapui.support.scripting.groovy.SoapUIProGroovyScriptEngineFactory$SoapUIProGroovyScriptEngine.run(SourceFile:51)
    at com.eviware.soapui.impl.wsdl.teststeps.WsdlGroovyScriptTestStep.run(WsdlGroovyScriptTestStep.java:148)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.GroovyScriptStepDesktopPanel$RunAction$1.run(GroovyScriptStepDesktopPanel.java:274)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)



Thanks for help!

Beno

7 Replies

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    17 years ago
    Hi!

    can you see soapUI picking up these jars when it starts? (ie in the soapUI log tab..)

    regards,

    /Ole
    eviware.com
  • BenX's avatar
    BenX
    Contributor
    17 years ago
    soapUI log:
    Fri Nov 20 15:09:01 CET 2009:ERROR:An error occured [com.mysql.jdbc.Driver], see error log for details

    that's all.

    error log is the same as i posted earlier.

    Beno
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    17 years ago
    Hi!

    I meant when soapUI starts, it says something like:

    14:39:37,173 INFO  [SoapUI] Added [file:/D:/workspace/soapui-pro-3.0.x/ext/mysql-connector-java-5.1.6-bin.jar] to classpath
    14:39:37,516 INFO  [DefaultSoapUICore] initialized soapui-settings from [C:\Users\Ole\soapui-settings.xml]
    14:39:38,003 WARN  [SoapUIProGroovyScriptEngineFactory] Missing scripts folder [D:\workspace\soapui-pro-3.0.x\scripts]
    etc..

    what does it say for you?

    regards,

    /Ole
    eviware.com
  • BenX's avatar
    BenX
    Contributor
    17 years ago
    Ah...

    Here it is:

    Fri Nov 20 17:37:39 CET 2009:INFO:Added [file:/C:/Program%20Files/eviware/soapUI-Pro-3.0.2/bin/ext/mysql-connector-java-5.1.7-bin.jar] to classpath
    Fri Nov 20 17:37:39 CET 2009:INFO:Added [file:/C:/Program%20Files/eviware/soapUI-Pro-3.0.2/bin/ext/postgresql-8.3-604.jdbc3.jar] to classpath
    Fri Nov 20 17:37:39 CET 2009:INFO:Added [file:/C:/Program%20Files/eviware/soapUI-Pro-3.0.2/bin/ext/postgresql-8.3-604.jdbc4.jar] to classpath
    Fri Nov 20 17:37:39 CET 2009:INFO:Added [file:/C:/Program%20Files/eviware/soapUI-Pro-3.0.2/bin/ext/sqljdbc.jar] to classpath
    Fri Nov 20 17:37:40 CET 2009:INFO:initialized soapui-settings from [C:\Documents and Settings\b.zurman\soapui-settings.xml]
    Fri Nov 20 17:37:42 CET 2009:WARN:Missing scripts folder [C:\Program Files\eviware\soapUI-Pro-3.0\bin\scripts]
    Fri Nov 20 17:37:42 CET 2009:INFO:Adding listeners from [C:\Program Files\eviware\soapUI-Pro-3.0.2\bin\listeners\demo-listeners.xml]
    Fri Nov 20 17:37:44 CET 2009:INFO:Loading workspace from [C:\Documents and Settings\b.zurman\My Documents\Projects-workspace.xml]
    Fri Nov 20 17:37:44 CET 2009:INFO:Loaded project from [file:C:/Documents and Settings/b.zurman/My Documents/Avaya_Matej-soapui-project.xml]
    Fri Nov 20 17:37:48 CET 2009:INFO:Loaded project from [file:C:/Documents and Settings/b.zurman/My Documents/Avaya-soapui-project.xml]
    Fri Nov 20 17:37:49 CET 2009:INFO:Loaded project from [file:C:/Documents and Settings/b.zurman/My Documents/Weather.xml]
    Fri Nov 20 17:37:49 CET 2009:INFO:Loaded project from [file:C:/Documents and Settings/b.zurman/My Documents/IP-locator-soapui-project.xml]
    Fri Nov 20 17:37:49 CET 2009:INFO:Loaded project from [file:C:/Documents and Settings/b.zurman/My Documents/Televoting-soapui-project.xml]
    Fri Nov 20 17:37:49 CET 2009:INFO:Loaded project from [file:C:/Documents and Settings/b.zurman/My Documents/REST-soapui-project.xml]
    Fri Nov 20 17:37:49 CET 2009:INFO:Loaded project from [file:C:/Documents and Settings/b.zurman/My Documents/habic-soapui-project.xml]
    Fri Nov 20 17:37:49 CET 2009:INFO:Loaded project from [file:C:/Documents and Settings/b.zurman/My Documents/NBProvisioning.mak-soapui-project.xml]
    Fri Nov 20 17:37:49 CET 2009:INFO:Loaded project from [file:C:/Documents and Settings/b.zurman/My Documents/Open_MN mnserver1.xml]
    Scheduling garbage collection every 60 seconds
    Fri Nov 20 17:37:55 CET 2009:INFO:Adding actions from [C:\Program Files\eviware\soapUI-Pro-3.0.2\bin\actions\demo-actions.xml]
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    17 years ago
    Hi!

    hmm... strange indeed.. can you show the script you are executing that uses the JDBC driver?

    regards!

    /Ole
    eviware.com
  • BenX's avatar
    BenX
    Contributor
    17 years ago
    Hi!

    I just open the project, run the script and it's working.
    I don't know what was wrong. I didn't change anything.
    Strange...

    Case closed?

    Sorry for bothering you. If I'll find out anything I'll let you know.

    Beno