我的HSQLDB上的更改不一致(Changes on my HSQLDB are inconsistent)

 我一直在努力学习如何使用HSQLDB，但似乎我所做的任何更改都被确认，然后被忽略或者做错了。 例如，我创建了一个新用户（internal_admin）作为SA，但在尝试以此用户身份登录后，我收到以下错误： 
 
 not found: internal_admin 
 
 用于create user internal_admin password somepassword ADMIN;命令： create user internal_admin password somepassword ADMIN; 
 
 为了解决我的问题，我将SA的密码更改为我从.txt文件复制的随机密码（以确保密码输入正确）但在尝试使用SA上的完全相同的密码登录后，我获得了invalid authorization specification密码invalid authorization specification 。 检查日志后，我发送的所有命令都成功完成并记录，但更改没有反映出来。 HSQLDB是绝对的，不可原谅的糟糕还是我做错了什么？ 我已经尝试重新启动数据库，但它没有任何区别。 
 
 用于更改密码的命令： Alter User SA set password somepassword; 
 
 我应该补充一点，我正在本地计算机上进行此测试，而不是在远程或专用服务器上进行此测试。 

I've been trying to learn how to use HSQLDB but it seems like any changes I make are acknowledged and then either ignored or done incorrectly. For instance, I created a new user (internal_admin) as SA but after attempting to log in as this user I get the following error:
 
not found: internal_admin
 
Command used to make user: create user internal_admin password somepassword ADMIN;
 
To add to my issues, I changed the password of SA to a randomized password that I copied from a .txt file (to ensure the password was entered correctly) but after trying to log in with the exact same password on SA I get an invalid authorization specification. Checking the logs, all commands I sent went through successfully and were logged, but the changes are not being reflected. Is HSQLDB just absolutely, unforgivably awful or am I doing something wrong? I've tried restarting the db but it makes no difference. 
 
Command used to change password: Alter User SA set password somepassword;
 
I should add that I'm doing this testing on my local computer, not on a remote or dedicated server. 

原文：https://stackoverflow.com/questions/38618710