如何在NetBeans 8.2中为Grails 3.2项目配置MySQL连接？

Hey there! Let's get your Grails 3.2 project hooked up to MySQL smoothly. Unlike older Grails versions where you manually added JARs, Grails 3 uses Gradle for dependency management—so we'll handle things the modern way. Here's your step-by-step guide:

1. Add MySQL Driver Dependency via Gradle #

Grails 3 pulls dependencies through Gradle, so we don't need to hunt for mysql-connector.jar manually:

• Open your project's root build.gradle file in NetBeans.
• Locate the dependencies block, then add the MySQL runtime dependency (version 5.1.x is fully compatible with JDK 1.8):

  dependencies {
      // Keep all your existing dependencies here
      runtime 'mysql:mysql-connector-java:5.1.49'
  }
  

• Right-click your project in NetBeans → Gradle → Refresh Dependencies. Gradle will automatically download the driver and add it to your project.

2. Configure Database Connection in application.yml #

Next, replace the default H2 database config with MySQL settings:

• Navigate to grails-app/conf/application.yml in your project.
• Update the dataSource section with your MySQL details (replace placeholders with your actual info):

  dataSource:
      pooled: true
      jmxExport: true
      driverClassName: com.mysql.jdbc.Driver
      username: YOUR_MYSQL_USERNAME
      password: YOUR_MYSQL_PASSWORD
      dialect: org.hibernate.dialect.MySQL5InnoDBDialect
  
  environments:
      development:
          dataSource:
              dbCreate: update # Options: create, create-drop, update, validate
              url: jdbc:mysql://localhost:3306/YOUR_DATABASE_NAME?useSSL=false&serverTimezone=UTC&useLegacyDatetimeCode=false
      test:
          dataSource:
              dbCreate: update
              url: jdbc:mysql://localhost:3306/YOUR_TEST_DB_NAME?useSSL=false&serverTimezone=UTC&useLegacyDatetimeCode=false
      production:
          dataSource:
              dbCreate: validate
              url: jdbc:mysql://localhost:3306/YOUR_PROD_DB_NAME?useSSL=false&serverTimezone=UTC&useLegacyDatetimeCode=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
  

  • Quick notes:
    • dbCreate: update keeps your schema in sync without deleting existing data (use create/create-drop if you need a fresh database every run).
    • serverTimezone=UTC fixes common timezone mismatches between MySQL and your app.
    • useSSL=false disables SSL warnings in development (remove this for production environments).

3. Verify the Connection #

Before testing, make sure:

• Your local MySQL server is running.
• You've created the target database (e.g., YOUR_DATABASE_NAME) in MySQL.
• Your MySQL username has permission to access the database.

Then:

• Right-click your project in NetBeans → Run.
• If the project starts without errors, your MySQL connection is working! To confirm, create a simple domain class (like Book) and generate CRUD operations—you should be able to save and retrieve data from MySQL seamlessly.

4. Troubleshooting Common Issues #

• Dependency download fails: Check your network connection, or try a slightly older driver version like 5.1.47.
• Connection errors: Double-check your MySQL credentials, database name, and that the MySQL service is running on port 3306 (default).
• Timezone errors: Ensure the serverTimezone parameter is in your JDBC URL, or set the default timezone in your MySQL config file.

内容的提问来源于stack exchange，提问作者Muhaimenul Islam