Hibernate逆向工程向导-可用表为空-问题 [英] Hibernate Reverse Engineering Wizard - Available Tables Empty - issue

问题描述

我正在尝试将Hibernate集成到我的Netbeans项目中以连接到Microsoft SQL Server.我已经运行了Hibernate Configuration文件向导(并建立了一个新的数据库连接).我已将方言设置为SqlServerDialect.我最初使用db_owner模式建立连接.我在连接上运行了测试查询，它们都返回正确的信息.

I'm trying to integrate Hibernate into my Netbeans project to connect to Microsoft SQL Server. I've run the Hibernate Configuration file wizard (and set up a new database connection). I've set the dialect to SqlServerDialect. I initially set up the connection with the db_owner schema. I've run test queries on the connection and they all return the correct information.

但是，当我尝试运行休眠映射"向导或休眠逆向工程"向导时，没有可用的表可供选择.

However, when I try to run either the Hibernate Mapping wizard or the Hibernate Reverse Engineering wizard, there are no available tables to select.

我正在使用Microsoft的JDBC(版本4).还有其他类似的问题已经发布，但是没有提供有效的答案.

I'm using the JDBC from Microsoft (version 4). There are other similar questions already posted, but no answers that have been provided work.

推荐答案

事实证明我选择了错误的默认架构.我选择了db_owner，它应该是dbo.当我在服务"选项卡下检查连接并展开默认架构时，它没有显示任何表.显然，SQL执行程序使用默认模式以外的其他模式来查找结果.

It turns out I selected the wrong default schema. I selected db_owner and it should have been dbo. When I checked the connection under the services tab and expanded the default schema, it showed no tables. Apparently the SQL executor uses other schemas besides the default to find results.

这篇关于Hibernate逆向工程向导-可用表为空-问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！