如何将Grails与MySQL连接,以及为什么Grails编译显示“compileJava NO-SOURCE”。

huangapple 未分类评论55阅读模式
英文:

how to connect grails with mysql and why grails compile shows :compileJava NO-SOURCE

问题

我在使用Grails 3项目中遇到了使用MySql的问题。
Application.yml 文件--

---
hibernate:
    cache:
        queries: false
        use_second_level_cache: false
        use_query_cache: false
dataSource: # <- 修改 !!!
    pooled: true
    jmxExport: true
    driverClassName: com.mysql.jdbc.Driver
    dialect: org.hibernate.dialect.MySQL5InnoDBDialect

environments:
    development:
        dataSource: # <- 修改 !!!
            username: root
            password:
            dbCreate: create-drop # 选项有 'create', 'create-drop', 'update', 'validate', ''
            url: jdbc:mysql://localhost:8888/nsl_api
    test:
        dataSource:
            dbCreate: update
            url: jdbc:h2:mem:testDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE
    production:
        dataSource:
            dbCreate: none
            url: jdbc:h2:./prodDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE
            properties:
                jmxEnabled: true
                initialSize: 5
                maxActive: 50
                minIdle: 5
                maxIdle: 25
                maxWait: 10000
                maxAge: 600000
                timeBetweenEvictionRunsMillis: 5000
                minEvictableIdleTimeMillis: 60000
                validationQuery: SELECT 1
                validationQueryTimeout: 3
                validationInterval: 15000
                testOnBorrow: true
                testWhileIdle: true
                testOnReturn: false
                jdbcInterceptors: ConnectionState
                defaultTransactionIsolation: 2 # TRANSACTION_READ_COMMITTED

在 Build.gradle 中,我使用了 runtime 'mysql:mysql-connector-java:5.1.29' 依赖。
当我使用 grials compile 命令时,出现了 :compileJava NO-SOURCE 的错误。如何在 IntelliJ IDEA 中添加 Java 源代码?我不太清楚,因为我是新来的。请帮忙。
另一个错误是

ERROR --- [main] o.a.tomcat.jdbc.pool.ConnectionPool : Unable to create initial connections of pool.

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

还有一个错误是 Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 如何连接 MySQL 数据库到我的 Grails 项目?我也运行了 XAMPP 软件,其中包含了 Apache、MySQL 和 Tomcat。我应该怎么做?我如何将数据发送到 MySQL 数据库并逐行在网页上检索数据?

英文:

I am facing problem using MySql with Grails 3 project.
Application.yml file--

---
hibernate:
    cache:
        queries: false
        use_second_level_cache: false
        use_query_cache: false
dataSource: # &lt;- CHANGE !!!
    pooled: true
    jmxExport: true
    driverClassName: com.mysql.jdbc.Driver
    dialect: org.hibernate.dialect.MySQL5InnoDBDialect

environments:
    development:
        dataSource: # &lt;- CHANGE !!!
            username : root
            password :
            dbCreate : create-drop # one of &#39;create&#39;, &#39;create-drop&#39;, &#39;update&#39;, &#39;validate&#39;, &#39;&#39;
            url : jdbc:mysql://localhost:8888/nsl_api
    test:
        dataSource:
            dbCreate: update
            url: jdbc:h2:mem:testDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE
    production:
        dataSource:
            dbCreate: none
            url: jdbc:h2:./prodDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE
            properties:
                jmxEnabled: true
                initialSize: 5
                maxActive: 50
                minIdle: 5
                maxIdle: 25
                maxWait: 10000
                maxAge: 600000
                timeBetweenEvictionRunsMillis: 5000
                minEvictableIdleTimeMillis: 60000
                validationQuery: SELECT 1
                validationQueryTimeout: 3
                validationInterval: 15000
                testOnBorrow: true
                testWhileIdle: true
                testOnReturn: false
                jdbcInterceptors: ConnectionState
                defaultTransactionIsolation: 2 # TRANSACTION_READ_COMMITTED

in Build.gradle, I use runtime &#39;mysql:mysql-connector-java:5.1.29&#39; dependencies.
When in use grials compile command I am getting :compileJava NO-SOURCE. how to add java source in itellij? I donot know it as I am new here. Please help.
Another error I am getting is

 ERROR --- [           main] o.a.tomcat.jdbc.pool.ConnectionPool      : Unable to create initial connections of pool.

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

And another error is Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
How can I connect mysql database with my grails project? I also run xammp software where apache, mysql and tomcat is running. what should I do? How can I send data into mysql database and retrieve that data in a web page row by row.

huangapple
  • 本文由 发表于 2020年7月27日 22:35:44
  • 转载请务必保留本文链接:https://java.coder-hub.com/63117608.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定