can anyone guide me how can i configure my project so hibernate can work with Microsoft SQL Server as it is working fine with Oracle, I am using Tomcat 5.0.18 and Hibernate 3.0.3.

i mean changes in server.xml and hibernate.cfg.xml

Thanks in advance.

Documentation:

Configure JDBC Connections

[url=http://www.hibernate.org/hib_docs/v3/reference/en/html/session-configuration.html#configuration-optional-dialects]DB Dialects available in Hibernate[url]

Forgot slash

DB Dialects available in Hibernate

thanks sir,
but this is only dialect for Microsoft SQL Server. now how to set the Server.xml following prperties parameters

1) factory
2) driverClassName
3) url

thanks in advance.

Using tomcat datasource or hibernate managed connections? If the latter, then see the first link above.

If using tomcat datasource, some examples for other databases are at Tomcat Documentation

The format for MSSql values using the MS JDBC driver is:



If you're using other drivers, consult the driver documentation for these values.

(If this helped, please rate)