我正在努力使用本地MySQL数据库(仅在WAMP上)设置我的Grails 3.1.0应用程序,但我尝试了现有来源中的所有方法都没有成功。
以下解决方案都没有成功:
grails-app/conf/application.yml:
dataSource:
pooled: true
jmxExport: true
driverClassName: com.mysql.jdbc.Driver
dialect: org.hibernate.dialect.MySQL5InnoDBDialect
username: sa
password:
environments:
development:
dataSource:
dbCreate: create-drop
url: jdbc:mysql://liveip.com/liveDb
build.gradle:
runtime 'mysql:mysql-connector-java:5.1.36'
非解决方案2
相似的方法,但是复制这个Github起始项目中的application.yml和build.gradle文件。
非解决方案3
下载MySQL连接器jar包,并按照以下答案在build.gradle文件中引用:
dependencies {
...
compile files('libs/a.jar')
}
在每次尝试后,我都运行了
grails clean
并在IntelliJ中重新构建。每种方法都会导致以下堆栈跟踪:ERROR org.apache.tomcat.jdbc.pool.ConnectionPool - Unable to create initial connections of pool.
java.sql.SQLException: Unable to load class: com.mysql.jdbc.Driver" from ClassLoader:sun.misc.Launcher$AppClassLoader@736e9adb;ClassLoader:sun.misc.Launcher$AppClassLoader@736e9adb
...
Caused by: java.lang.ClassNotFoundException: Unable to load class: com.mysql.jdbc.Driver" from ClassLoader:sun.misc.Launcher$AppClassLoader@736e9adb;ClassLoader:sun.misc.Launcher$AppClassLoader@736e9adb
at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:56) ~[tomcat-jdbc-8.0.30.jar:na]
...
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver"
at java.net.URLClassLoader$1.run(URLClassLoader.java:372) ~[na:1.8.0_05]