Re: o suitable Driver for jdbc
Armin Waibel <[email protected]>
| Newsgroups | gmane.comp.jakarta.ojb.user |
|---|---|
| Message-ID | <[email protected]> |
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-bi
n.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]
>
>