Armin Waibel wrote:
Hi Sergio,
I never used the 3.x driver, but the 5.x driver works without any
problems.
Seems to be a classpath issue, if you run the ant task in debug mode
(ant build -debug) do you get any other warnings or more detailed
error message?
regards,
Armin
Hi Armin,
Sorry for the delay answering but it is being difficult for me to go in
internet during the summer. I tried downloading 5.x driver but still i
am getting the same error. This is the error i am getting after using
"ant build setup-db -debug" as you told me.
[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-3.1.12-bin.jar:/home/sdelamo/Desktop/ojb-blank/lib/mysql-connector-java-5.0.2-beta-bin.jar:/home/sdelamo/Desktop/ojb-blank/lib/servlet2_3.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/xerces.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:
[] }
Class com.mysql.jdbc.Driver 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)
Total time: 15 seconds
Any idea?,
thanks in advanced,
Sergio
I downloaded the ojb-blank and the tutorials from
http://db.apache.org/ojb/docu/getting-started.html.
I set the build.properties to:
------------------------------------------------------------------------------------------
jcdAlias=default
databaseName=productmanager
databaseUser=db_user
databasePassword=db_user
# For MySQL this would look like:
dbmsName=MySQL
jdbcLevel=3.0
jdbcRuntimeDriver=com.mysql.jdbc.Driver
urlProtocol=jdbc
urlSubprotocol=mysql
urlDbalias=//localhost/productmanager
torque.database=mysql
torque.database.createUrl=${urlProtocol}:${urlSubprotocol}:${build.dir}/database/${databaseName}
torque.database.buildUrl=${torque.database.createUrl}
jar.name=my-project.jar
source.dir=src
source.java.dir=${source.dir}/java
source.resource.dir=${source.dir}/resources
source.test.dir=${source.dir}/test
source.schema.dir=${source.dir}/schema
build.dir=build
lib.dir=lib
target.dir=target
-------------------------------------------------------------------------------------------------------
But when i run:
-----------------------------------------------------------------------------------
ojb-blank]$ echo $CLASSPATH
/opt/lampp/lib/mysql-connector-java-3.1.13-bin.jar
ojb-blank]$ ant build setup-db
...
..
.
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
Total time: 5 seconds
----------------------------------------------------------------------------------
Kann anyone help me.?
Thanks in advanced,
Sergio del Amo
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
