Databases
StackOverflow2013
Postsdbo
POSetup of maven plugin for using QueryDSL with a MySQL database
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSetup of maven plugin for using QueryDSL with a MySQL database
    text
    copied!<p>I'm trying to setup my project so that I can use querydsl-sql against a MySQL database. I'd like to get the classes and generate the classes using maven and am having problems setting up the plugin.</p> <p>I've tried configuring the pom.xml from the example available <a href="http://blog.mysema.com/2011/01/querying-in-sql-with-querydsl.html" rel="nofollow">here</a></p> <pre><code>&lt;plugin&gt; &lt;groupId&gt;com.mysema.querydsl&lt;/groupId&gt; &lt;artifactId&gt;querydsl-maven-plugin&lt;/artifactId&gt; &lt;version&gt;2.1.0&lt;/version&gt; &lt;executions&gt; &lt;execution&gt; &lt;goals&gt; &lt;goal&gt;export&lt;/goal&gt; &lt;/goals&gt; &lt;/execution&gt; &lt;/executions&gt; &lt;configuration&gt; &lt;jdbcDriver&gt;com.mysql.jdbc.Driver&lt;/jdbcDriver&gt; &lt;jdbcUrl&gt;jdbc:mysql:mydb:3306/alltrades&lt;/jdbcUrl&gt; &lt;jdbcUser&gt;mvaz&lt;/jdbcUser&gt; &lt;packageName&gt;com.three60t.tools.bonus.persistence&lt;/packageName&gt; &lt;targetFolder&gt;${project.basedir}/target/generated-sources/java&lt;/targetFolder&gt; &lt;/configuration&gt; &lt;dependencies&gt; &lt;dependency&gt; &lt;groupId&gt;mysql&lt;/groupId&gt; &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt; &lt;version&gt;5.1.6&lt;/version&gt; &lt;/dependency&gt; &lt;/dependencies&gt; &lt;/plugin&gt; </code></pre> <p>The dependency to mysql-connector-java is also given in the pom. The problem that I'm getting is that it doesn't seem to find the driver:</p> <pre><code>[INFO] Scanning for projects... [INFO] ------------------------------------------------------------------------ [INFO] Building tools-bonus [INFO] task-segment: [clean, install] [INFO] ------------------------------------------------------------------------ [INFO] [clean:clean {execution: default-clean}] [INFO] [querydsl:export {execution: default}] SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". SLF4J: Defaulting to no-operation (NOP) logger implementation SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. [ERROR] java.sql.SQLException: No suitable driver found for jdbc:mysql:mydb:3306/alltrades at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at com.mysema.query.maven.AbstractMetaDataExportMojo.execute(AbstractMetaDataExportMojo.java:134) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:490) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:694) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:556) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:535) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:387) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:348) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:180) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:328) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138) at org.apache.maven.cli.MavenCli.main(MavenCli.java:362) at org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430) at org.codehaus.classworlds.Launcher.main(Launcher.java:375) [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] No suitable driver found for jdbc:mysql:mydb:3306/alltrades [INFO] ------------------------------------------------------------------------ [INFO] For more information, run Maven with the -e switch [INFO] ------------------------------------------------------------------------ [INFO] Total time: 1 second [INFO] Finished at: Tue Mar 01 16:34:47 CET 2011 [INFO] Final Memory: 23M/219M [INFO] ------------------------------------------------------------------------ </code></pre> <p>Can someone help me with this? How can I specify the driver?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload