我如何使用Spring Security和默认数据库H2来使用Grails数据库迁移？ [英] How can I use Grails DB Migration with Spring Security and the default DB, H2?

查看：261
本文介绍了我如何使用Spring Security和默认数据库H2来使用Grails数据库迁移？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在运行由 Grails数据库迁移插件生成的异常。

在 JIRA ，它表示这是一个不会修正的错误。

但是，我想用默认数据库 H2 来使用 Spring Security ，因为它很容易用来制作简单的应用程序。



除了将DB更改为 MYSQL 或 ORACLE ？







UPDATE



继JIRA解决方案后，在User.groovy中将发生错误的列的名称 password 更改为 passwd 。



下面显示的User.groovy的一部分。

 字符串用户名
字符串密码
静态瞬态= ['springSecurityService'] 
静态约束= {
 username blank：false，unique：true 
密码空白：false 
} 
静态映射= {
密码列：``passwd`'
}

运行命令 gradle grails-dbm-gorm-diff -PgrailsArgs =2015- 5-23-first-diff.groovy --add，我得到如下错误。

> |开始dbm-gorm-diff
liquibase.exception.DatabaseException：org.h2.jdbc.JdbcSQLException：列PASSWD查看
列未找到PASSWD; SQL语句：
SELECT passwd FROM USER WHERE 1 = 0 [42122-176]
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot（JdbcDatabaseSnapshotGenerator.java:251）
at liquibase.snapshot。 DatabaseSnapshotGeneratorFactory.createSnapshot（DatabaseSnapshotGeneratorFactory.java:69）
at liquibase.diff.Diff.compare（Diff.java:71）
at grails.plugin.databasemigration.GormDiff.compare（GormDiff.groovy：45）
at grails.plugin.databasemigration.ScriptUtils.createAndPrintFixedDiff（ScriptUtils.groovy：244）
at DbmGormDiff $ _run_closure1_closure2_closure3.doCall（DbmGormDiff：53）
at grails.plugin.databasemigration.MigrationUtils.executeInSession （MigrationUtils.groovy：133）
at DbmGormDiff $ _run_closure1_closure2.doCall（DbmGormDiff：50）
at grails.plugin.databasemigration.ScriptUtils.executeAndWrite（ScriptUtils.groovy：104）
at DbmGormDiff $ _run_closure1.doCall（DbmGormDiff：49）
在org.grails.launcher.util.Reflec tionUtils.invokeMethod（ReflectionUtils.java:57）
at org.grails.launcher.context.DelegatingGrailsLaunchContext.launch（DelegatingGrailsLaunchContext.java:409）
at org.grails.launcher.ReflectiveGrailsLauncher.launch（ReflectiveGrailsLauncher。 java：32）
at org.grails.launcher.InProcessGrailsLauncher.launch（InProcessGrailsLauncher.java:27）
at org.grails.launcher.Main.run（Main.java:62）
在org.grails.launcher.Main.main（Main.java:38）
导致：org.h2.jdbc.JdbcSQLException：列PASSWDが见つかりまんん
未找到PASSWD列; SQL语句：
SELECT passwd FROM USER WHERE 1 = 0 [42122-176]
at org.h2.message.DbException.getJdbcSQLException（DbException.java:344）
at org.h2。 message.DbException.get（DbException.java:178）
at org.h2.message.DbException.get（DbException.java:154）
at org.h2.expression.ExpressionColumn.optimize（ExpressionColumn。
at org.h2.command.dml.Select.prepare（Select.java:831）
at org.h2.command.Parser.prepareCommand（Parser.java:248）
在org.h2.engine.Session.prepareLocal（Session.java:442）
在org.h2.engine.Session.prepareCommand（Session.java:384）
在org.h2.jdbc .JdbcConnection.prepareCommand（JdbcConnection.java:1188）
at org.h2.jdbc.JdbcStatement.executeQuery（JdbcStatement.java:75）
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.isColumnAutoIncrement（JdbcDatabaseSnapshotGenerator.java ：842）
在liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumns（JdbcDatabaseSnapsho
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot（JdbcDatabaseSnapshotGenerator.java:244）
... 15 more
：grails-dbm-gorm-diff FAILED


解决方案

正如JIRA所述，解决方案如下：


这是由于生成的用户类中
中的'password'字段的反引号引起的。 'password'是一些
数据库中的保留字，所以脚本默认转义它，因为如果它不是
保留字，它将不起作用。因此，如果它不是保留字，或者将其更改为
非保留字，请移除密码列：
'密码'如果没有反拨，例如密码列：
'passwd'


这意味着您需要编辑您的用户域名类。



更新您的域名类应如下所示：

 字符串用户名
字符串密码
静态瞬态= ['springSecurityService'] 
静态约束= {
 username blank：false ，unique：true 
密码空白：false 
} 
静态映射= {
 //注意以下字段没有背景！ 
密码栏：'passwd'
}


I'm running into an exception generated by the Grails Database Migration plugin.

In JIRA, it says this is a bug won't fixed.

But, I want to use Spring Security with the default DB, H2, because it's easy to use to make a simple application.

How can I avoid this bug except changing DB to MYSQL or ORACLE?

UPDATE

Following the solution in JIRA, I changed the name of the column which has made the error, password, to passwd in User.groovy.

A part of User.groovy shown below.

    String username
    String password
    static transients = ['springSecurityService']
    static constraints = {
        username blank: false, unique: true
        password blank: false
    }
    static mapping = {
        password column: '`passwd`'
    }

After I run the command gradle grails-dbm-gorm-diff -PgrailsArgs="2015-5-23-first-diff.groovy --add", I got error like below.

| Starting dbm-gorm-diff
liquibase.exception.DatabaseException: org.h2.jdbc.JdbcSQLException: 列 "PASSWD" が見つかりません
Column "PASSWD" not found; SQL statement:
SELECT passwd FROM USER WHERE 1 = 0 [42122-176]
    at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:251)
    at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(DatabaseSnapshotGeneratorFactory.java:69)
    at liquibase.diff.Diff.compare(Diff.java:71)
    at grails.plugin.databasemigration.GormDiff.compare(GormDiff.groovy:45)
    at grails.plugin.databasemigration.ScriptUtils.createAndPrintFixedDiff(ScriptUtils.groovy:244)
    at DbmGormDiff$_run_closure1_closure2_closure3.doCall(DbmGormDiff:53)
    at grails.plugin.databasemigration.MigrationUtils.executeInSession(MigrationUtils.groovy:133)
    at DbmGormDiff$_run_closure1_closure2.doCall(DbmGormDiff:50)
    at grails.plugin.databasemigration.ScriptUtils.executeAndWrite(ScriptUtils.groovy:104)
    at DbmGormDiff$_run_closure1.doCall(DbmGormDiff:49)
    at org.grails.launcher.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:57)
    at org.grails.launcher.context.DelegatingGrailsLaunchContext.launch(DelegatingGrailsLaunchContext.java:409)
    at org.grails.launcher.ReflectiveGrailsLauncher.launch(ReflectiveGrailsLauncher.java:32)
    at org.grails.launcher.InProcessGrailsLauncher.launch(InProcessGrailsLauncher.java:27)
    at org.grails.launcher.Main.run(Main.java:62)
    at org.grails.launcher.Main.main(Main.java:38)
Caused by: org.h2.jdbc.JdbcSQLException: 列 "PASSWD" が見つかりません
Column "PASSWD" not found; SQL statement:
SELECT passwd FROM USER WHERE 1 = 0 [42122-176]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
    at org.h2.message.DbException.get(DbException.java:178)
    at org.h2.message.DbException.get(DbException.java:154)
    at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:148)
    at org.h2.command.dml.Select.prepare(Select.java:831)
    at org.h2.command.Parser.prepareCommand(Parser.java:248)
    at org.h2.engine.Session.prepareLocal(Session.java:442)
    at org.h2.engine.Session.prepareCommand(Session.java:384)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
    at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:75)
    at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.isColumnAutoIncrement(JdbcDatabaseSnapshotGenerator.java:842)
    at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumns(JdbcDatabaseSnapshotGenerator.java:369)
    at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:244)
    ... 15 more
:grails-dbm-gorm-diff FAILED

解决方案

As stated in the JIRA the solution is as follows:

This is caused by the backticks that escape the 'password' field in the generated user class. 'password' is a reserved word in some databases so the script escapes it by default since if it's not a reserved word it has no effect. So either remove "password column: 'password'" if it isn't a reserved word, or change it to a non-reserved word without a backtick if it is, e.g. "password column: 'passwd'"

This means you need to edit your User domain class.

Update Your domain class should look like this:

String username
String password
static transients = ['springSecurityService']
static constraints = {
    username blank: false, unique: true
    password blank: false
}
static mapping = {
    // NOTICE THE FOLLOWING FIELD DOES NOT HAVE BACKTICKS!
    password column: 'passwd'
}

这篇关于我如何使用Spring Security和默认数据库H2来使用Grails数据库迁移？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆