You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Sergio del Amo Caballero <se...@sbox.tugraz.at> on 2006/08/16 23:56:56 UTC
Re: o suitable Driver for jdbc
Hi Armin,
Armin Waibel wrote:
> Seems to be really a classpath problem. But both myssql driver jars
> (5.0.1 and 3.1) are in your classpath - strange (maybe a classloader
> issue).
This was because testing i copied both under the lib directory
> Did you try to use the old driver class in build.properties file to
> lookup the driver class ('org.gjt.mm.mysql.Driver')? Will this cause
> the same error?
Yes, the same error.
i decided to begin from scratch again. Steps:
1) Download ojb-blank
2) Download tutorial 1 and uncompress it under src directory
3) Configure build.properties
---------------------------------------------------------
jcdAlias=default
databaseName=productmanager
databaseUser=db_user
databasePassword=db_user
dbmsName=MySQL
jdbcLevel=5.0
jdbcRuntimeDriver=com.mysql.jdbc.Driver
urlProtocol=jdbc
urlSubprotocol=mysql
urlDbalias=//localhost/productmanager
torque.database=mysql
4) Download jdbc driver form mysql site.
mysql-connector-java-5.0.3-bin.jar and copied in lib directory
5) Run "ant build setup-db -debug
Still i am getting the driver error. However it seems it loads through
the log. Can it be anything about the urlDbalias?
append-shutdown-sql:
Skipped because property 'torque.internal.shutdownAfterSql' not set.
[antcall] Exiting
/home/sdelamo/Desktop/ojb-blank/src/schema/build-torque.xml.
[echo]
[echo] Executing the create-db.sql script ...
[echo]
[sql] connecting to jdbc:mysql:build/database/productmanager
fileset: Setup scanner in dir /home/sdelamo/Desktop/ojb-blank/lib with
patternSet{ includes: [**/commons-collections-3.1.jar,
**/commons-lang-1.0.1.jar, **/log4j-1.2.8.jar, **/torque-gen-3.1.1.jar,
**/velocity-1.3.1.jar, **/village-2.0-dev-20030825.jar,
**/xercesImpl-2.0.2.jar, **/xmlParserAPIs-2.0.2.jar, **/*.jar] excludes:
[] }
[sql] Loading com.mysql.jdbc.Driver using AntClassLoader with
classpath
/home/sdelamo/Desktop/ojb-blank/lib/antlr-2.7.5.jar:/home/sdelamo/Desktop/ojb-blank/lib/commons-beanutils-1.7.0.jar:/home/sdelamo/Desktop/ojb-blank/lib/commons-betwixt-0.8-dev.jar:/home/sdelamo/Desktop/ojb-blank/lib/commons-collections-3.1.jar:/home/sdelamo/Desktop/ojb-blank/lib/commons-dbcp-1.2.1.jar:/home/sdelamo/Desktop/ojb-blank/lib/commons-digester-1.7.jar:/home/sdelamo/Desktop/ojb-blank/lib/commons-lang-2.1.jar:/home/sdelamo/Desktop/ojb-blank/lib/commons-logging-1.0.4.jar:/home/sdelamo/Desktop/ojb-blank/lib/commons-pool-1.2.jar:/home/sdelamo/Desktop/ojb-blank/lib/commons-transaction-1.1.jar:/home/sdelamo/Desktop/ojb-blank/lib/db-ojb-1.0.4.jar:/home/sdelamo/Desktop/ojb-blank/lib/hsqldb.jar:/home/sdelamo/Desktop/ojb-blank/lib/log4j-1.2.8.jar:/home/sdelamo/Desktop/ojb-blank/lib/mysql-connector-java-5.0.3-bin.jar:/home/sdelamo/Desktop/ojb-blank/lib/torque-gen-3.1.1.jar:/home/sdelamo/Desktop/ojb-blank/lib/velocity-1.3.1.jar:/home/sdelamo/Desktop/ojb-blank/lib/xdoclet-1.2.3.jar:/home/sdelamo/Desktop/ojb-blank/lib/xdoclet-ojb-module-1.2.3.jar:/home/sdelamo/Desktop/ojb-blank/lib/xjavadoc-1.1.jar
fileset: Setup scanner in dir /home/sdelamo/Desktop/ojb-blank/lib with
patternSet{ includes: [**/commons-collections-3.1.jar,
**/commons-lang-1.0.1.jar, **/log4j-1.2.8.jar, **/torque-gen-3.1.1.jar,
**/velocity-1.3.1.jar, **/village-2.0-dev-20030825.jar,
**/xercesImpl-2.0.2.jar, **/xmlParserAPIs-2.0.2.jar, **/*.jar] excludes:
[] }
Finding class com.mysql.jdbc.Driver
Loaded from
/home/sdelamo/Desktop/ojb-blank/lib/mysql-connector-java-5.0.3-bin.jar
com/mysql/jdbc/Driver.class
Class java.sql.Driver loaded from parent loader (parentFirst)
Finding class com.mysql.jdbc.NonRegisteringDriver
Loaded from
/home/sdelamo/Desktop/ojb-blank/lib/mysql-connector-java-5.0.3-bin.jar
com/mysql/jdbc/NonRegisteringDriver.class
Class java.lang.Object loaded from parent loader (parentFirst)
Class com.mysql.jdbc.NonRegisteringDriver loaded from ant loader
(parentFirst)
Class com.mysql.jdbc.Driver loaded from ant loader (parentFirst)
Class java.lang.Throwable loaded from parent loader (parentFirst)
Class java.lang.Exception loaded from parent loader (parentFirst)
Class java.sql.SQLException loaded from parent loader (parentFirst)
Class java.sql.Connection loaded from parent loader (parentFirst)
Class java.io.IOException loaded from parent loader (parentFirst)
Class java.lang.ClassNotFoundException loaded from parent loader
(parentFirst)
Class java.lang.IllegalAccessException loaded from parent loader
(parentFirst)
Class java.lang.InstantiationException loaded from parent loader
(parentFirst)
Class java.lang.NoSuchMethodError loaded from parent loader (parentFirst)
Class java.io.UnsupportedEncodingException loaded from parent loader
(parentFirst)
Class java.lang.NumberFormatException loaded from parent loader
(parentFirst)
Class java.lang.RuntimeException loaded from parent loader (parentFirst)
Class java.sql.DriverManager loaded from parent loader (parentFirst)
Class java.util.Properties loaded from parent loader (parentFirst)
Finding class com.mysql.jdbc.StringUtils
Loaded from
/home/sdelamo/Desktop/ojb-blank/lib/mysql-connector-java-5.0.3-bin.jar
com/mysql/jdbc/StringUtils.class
Class com.mysql.jdbc.StringUtils loaded from ant loader (parentFirst)
Class java.util.List loaded from parent loader (parentFirst)
Class java.lang.IllegalArgumentException loaded from parent loader
(parentFirst)
Class java.lang.NoSuchMethodException loaded from parent loader
(parentFirst)
Class java.lang.reflect.InvocationTargetException loaded from parent
loader (parentFirst)
Class java.lang.NoClassDefFoundError loaded from parent loader (parentFirst)
Class java.lang.String loaded from parent loader (parentFirst)
Class java.lang.Class loaded from parent loader (parentFirst)
Class java.math.BigDecimal loaded from parent loader (parentFirst)
[ant] Exiting
/home/sdelamo/Desktop/ojb-blank/src/schema/build-torque.xml.
BUILD FAILED
/home/sdelamo/Desktop/ojb-blank/build.xml:189: The following error
occurred while executing this line:
/home/sdelamo/Desktop/ojb-blank/src/schema/build-torque.xml:383:
java.sql.SQLException: No suitable Driver for
jdbc:mysql:build/database/productmanager
at
org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:539)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:384)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.Main.runBuild(Main.java:668)
at org.apache.tools.ant.Main.startAnt(Main.java:187)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
Caused by:
/home/sdelamo/Desktop/ojb-blank/src/schema/build-torque.xml:383:
java.sql.SQLException: No suitable Driver for
jdbc:mysql:build/database/productmanager
at
org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:314)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:37)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)
... 12 more
Caused by: java.sql.SQLException: No suitable Driver for
jdbc:mysql:build/database/productmanager
at
org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:308)
... 21 more
--- Nested Exception ---
/home/sdelamo/Desktop/ojb-blank/src/schema/build-torque.xml:383:
java.sql.SQLException: No suitable Driver for
jdbc:mysql:build/database/productmanager
at
org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:314)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:37)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.Main.runBuild(Main.java:668)
at org.apache.tools.ant.Main.startAnt(Main.java:187)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
Caused by: java.sql.SQLException: No suitable Driver for
jdbc:mysql:build/database/productmanager
at
org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:308)
... 21 more
--- Nested Exception ---
java.sql.SQLException: No suitable Driver for
jdbc:mysql:build/database/productmanager
at
org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:308)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:37)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.Main.runBuild(Main.java:668)
at org.apache.tools.ant.Main.startAnt(Main.java:187)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
help is really, really appreciated!.
regards,
Sergio
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org