netbeans derby，在Mac上的新数据库中未创建用户名模式 [英] netbeans derby, no username-schema created in new database on mac

问题描述

我是一个初学者，所以我可能会丢失一些东西，但是当我在Windows的netbeans中创建一个新的derby数据库时，如果指定了用户名和密码，则会创建一个与该用户名同名的架构，但是当我在Mac OS X上的netbeans中使用用户名创建数据库，未创建任何模式，数据库仅具有默认模式，应用程序，nullid等，这是错误还是对此行为有设置? netbeans和derby均为最新版本. 谢谢.

I'm a beginner so I might be missing something, but when I create a new derby database in netbeans on windows, if I specify username and password, a schema with the same name of the username is created, but when I create database with username in netbeans on mac osx, no schema is created, the database has just the default schemas, app, nullid etc, is this a bug or is there a setting for this behavior? both netbeans and derby are newest version. thanks.

推荐答案

我认为您只是误解了行为. Windows和Mac上的行为是相同的. Derby动态地隐式创建一个以用户名命名的架构.但是您也可以通过完全限定表名等方式，使用CREATE SCHEMA语句等方式来显式引用架构.您可能只是未使用您认为的用户名，或者没有在查看同一数据库认为自己或类似的东西.

I think you're just misreading the behavior. The behavior on Windows and Mac is identical. Derby implicitly creates a schema named with the username on-the-fly. But you can explicitly reference schemas too, by fully-qualifying table names, etc., by using the CREATE SCHEMA statement, etc. You are probably just not using the username that you think you are, or you are not looking at the same database that you think you, or something like that.

通过发布正在执行的确切脚本来尝试使问题更具体，例如，在两台计算机上都使用"ij"工具，以便我们可以看到您可能正在做的不同.我经常在Windows，Mac和Linux上使用Derby，而且我总是发现用户名/架构名称的处理是一致的.

Try making your question more concrete by posting exact scripts of what you're doing, e.g., using the 'ij' tool on both machines, so we can see what you might be doing differently. I routinely use Derby across Windows, Mac, and Linux, and I've always found the username/schemaname handling to be consistent.

这篇关于netbeans derby，在Mac上的新数据库中未创建用户名模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！