hi every body, i already wasted the 31 trying to get hibernate up and running, i simly cant get the application running, im using this configurai0n structure:

<!-- Database connection settings -->
<property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
<!-- <property name="connection.url">jdbc:hsqldb:hsql://localhost</property>-->
<property name="connection.url">jdbc:microsoft:sqlserver:\\mancerainc/SQLExpress;SelectedMethod=cursor;DatabaseName=Empresa</property>
<property name="connection.username">user</property>
<property name="connection.password">usuario</property>

<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>

<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>


and i got this:



GRAVE: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.
Exception in thread "main" org.hibernate.exception.GenericJDBCException: Cannot open connection


please help

I use jTDS and it works with this configuration:



Your jdbc url is not right and it should look like jdbc:sqlserver://localhost;integratedSecurity=true;

For more information you can see their website at http://msdn2.microsoft.com/en-us/library/ms378428.aspx


Farzad-

Replace the two backward slashes with // in your URL and see if that helps.

I really appreciate your response Farzad, you pointed me in right direction, i almost got crazy, ill post the solution for everybody:

* First you were right the url sintax was wrong for a local sql server instance is jdbc:sqlserver://localhost:4033;databaseName=MyDatabase

* The sql express express edition generates a dinamic tcp/ip port, so on
we must configure it : http://kamhungsoh.com/blog/labels/Database.html

Thanks again.