HSQLDB-无效的授权规范 [英] HSQLDB - invalid authorization specification

问题描述

在hsqldb-2.2.8上通过JPA/Hibernate进行数据库连接期间，我需要有关问题的帮助:

I need help with an issue during the database connection via JPA/Hibernate on hsqldb-2.2.8:

[AWT-EventQueue-0] ERROR org.hibernate.util.JDBCExceptionReporter - invalid authorization specification - not found: manasouza

我用以下密码创建了一个用户(manasouza):

I created some user (manasouza) with some password as:

CREATE USER manasouza PASSWORD 123 ADMIN

我正在使用SQLWorkbench作为数据库可视化工具，并可以使用它正常登录. 使用JPA/Hibernate，我已经尝试使用大写的用户名，密码为"123"或SYSTEM_USERS数据库表的PASSWORD_DIGEST列上显示的加密值，但没有成功.

I'm using SQLWorkbench as my database visualizer, and with it I can log on normally. Using JPA/Hibernate I already tried the username on uppercase and the password as '123' or as the value cryptographed showed on the PASSWORD_DIGEST column at SYSTEM_USERS database table, but had no success at all.

推荐答案

使用CREATE USER manasouza PASSWORD 123 ADMIN时，HSQLDB 2.2.8会引发异常.因此，您必须使用其他密码.

When you use CREATE USER manasouza PASSWORD 123 ADMIN, HSQLDB 2.2.8 throws an exception. Therefore you must have used a different password.

该用户名被转换为全部大写，因为它没有被双引号引起来.对于密码，您应该在字符串周围使用单引号.如果定义密码时不带单引号，则密码必须以字母开头，并转换为全部大写.因此，如果需要确切的情况，请使用CREATE USER "manasouza" PASSWORD '123' ADMIN

The user name is converted to all uppercase because it is not double quoted. For the password, you should use single quotes around the string. If you define the password without the single quotes, it must start with a letter and is converted to all uppercase. Therefore if you want the exact case, use CREATE USER "manasouza" PASSWORD '123' ADMIN

这篇关于HSQLDB-无效的授权规范的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！