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/07/21 09:15:22 UTC

o suitable Driver for jdbc

Hello,
I wanted to use OJB for a web application. So, i went to the ojb site 
and follewed the getting started tutorial. Unfortunately i got stacked 
with a mysql driver issue. I try not to write here because i guess this 
is a common problem but i googled and try to look for the solution into 
the mailing list archive (by the way the link to archive within  
http://db.apache.org/ojb/mail-lists.html seems to be broken.) without 
success.

I am runing:
- Ubuntu draper machine
- XAMPP for Linux 1.5.3a
- MySQL - 5.0.21
- Apache Ant version 1.6.5
- Apache Tomcat-5.5.17
- jdbc mysql driver: mysql-connector-java-3.1.13-bin.jar

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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: o suitable Driver for jdbc

Posted by Sergio del Amo Caballero <se...@sbox.tugraz.at>.
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

Re: o suitable Driver for jdbc

Posted by Armin Waibel <ar...@apache.org>.
Hi Sergio,

Sergio del Amo Caballero wrote:
> 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.
> 

Seems to be really a classpath problem. But both mysql driver jars 
(5.0.1 and 3.1) are in your classpath - strange (maybe a classloader issue).
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?

regards,
Armin


>     [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: ojb-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: o suitable Driver for jdbc

Posted by Sergio del Amo Caballero <se...@sbox.tugraz.at>.
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: ojb-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: o suitable Driver for jdbc

Posted by Armin Waibel <ar...@apache.org>.
Hi Sergio,

Sergio del Amo Caballero wrote:
> Hello,
> I wanted to use OJB for a web application. So, i went to the ojb site 
> and follewed the getting started tutorial. Unfortunately i got stacked 
> with a mysql driver issue. I try not to write here because i guess this 
> is a common problem but i googled and try to look for the solution into 
> the mailing list archive (by the way the link to archive within  
> http://db.apache.org/ojb/mail-lists.html seems to be broken.) 

Did you tried the alternative links?
http://db.apache.org/ojb/mail-archives.html


> without 
> success.
> 
> I am runing:
> - Ubuntu draper machine
> - XAMPP for Linux 1.5.3a
> - MySQL - 5.0.21
> - Apache Ant version 1.6.5
> - Apache Tomcat-5.5.17
> - jdbc mysql driver: mysql-connector-java-3.1.13-bin.jar
> 

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


> 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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org