Programmatically connecting to SQL Server with Hibernate

CompiledMonkey · **Posted:** Mon Jul 07, 2008 1:56 pm

I've been all over looking for what I could be doing wrong. I've had an external cfg.xml file for a SQL Server 2005 database that has been working fine. I now need to bring it internal and programmatically set the values for my connection. I've attempted to set the configuration properties as I have with an Oracle connection, but it's just not making the connection. Any help is greatly appreciated.

Code:

configuration.setProperty("hibernate.connection.url", "jdbc:sqlserver://myserver");
configuration.setProperty("hibernate.connection.database", "db");
configuration.setProperty("hibernate.connection.username", "user");
configuration.setProperty("hibernate.connection.password", "pwd");

Code:

configuration.setProperty("hibernate.connection.url", "jdbc:sqlserver://myserver:1433;databaseName=db");
configuration.setProperty("hibernate.connection.username", "user");
configuration.setProperty("hibernate.connection.password", "pwd");

Cameron McKenzie · **Posted:** Mon Jul 07, 2008 3:07 pm

Have you set the dialect properly?

http://www.hiberbook.com/HiberBookWeb/l ... hhibernate

Code:

<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>

CompiledMonkey · **Posted:** Mon Jul 07, 2008 3:25 pm

Yes, I've set it to the appropriate dialect for SQL Server. And like I mentioned, it works fine if the values live in the hibernate.cfg.xml file. It's when I attempt to set them programmatically when I see the problems connecting to the data source.