Connecting to MSSQL using Hibernate

Question

How to connect to the MSSQL database by using Hibernate in Netbeans 6.7.1? Please advice. The dialect is disabled for me.

Answer 1

For MS SQL Server 2000 and 2005, you should use SQLServerDialect (that should be preferred over SybaseDialect that will be deprecated).

I can't verify how NetBeans Hibernate wizard behave with MS SQL Server but, according to this tutorial:

When you create a Hibernate configuration file using a wizard you specify the database connection by choosing from a list of database connection registered with the IDE. When generating the configuration file the IDE automatically adds the connection details and dialect information based on the selected database connection.

So, my question is: did you register a database connection for your MS SQL Server database? If not, go to Services, add a New Driver (right click on the Drivers node) for your SQL Server JDBC driver and add a New Connection (right click on the Databases node) with the right URL for your database.

Answer 2

for the neat bean the same problem i have face in my application then i change the database role and set this type to the sql server 2005