Re: o suitable Driver for jdbc

Mon, 31 Jul 2006 04:11:13 -0700 

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: [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]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]























					Reply via email to