Hello,
i'm stating to use hibernate with ms sql server...
some time ago i used with postgresql.

retrevieng data from sql server has not been a problem, however invocation of save method is not working, yet the proper sql sentences are been generated:



but no register is created on the db, no exception thrown neither.
what could be the problem?

i must also mention some strange warning after the first data fetch,




this is the only configuration (in adition to the .hbm.xml) i include, i'm using springframework.

<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">net.sf.hibernate.dialect.SQLServerDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.connection.url">jdbc:microsoft:sqlserver://server;DatabaseName=myDB;PortNumber=1433;User=***;Password=***;schema=dbo;catalog=myDB</prop>
<prop key="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</prop>
<prop key="hibernate.connection.username">***</prop>
<prop key="hibernate.connection.password">***</prop>
</props>
</property>


i'm confused about this strange (alt least, to me) behaviour, what i'm missing??

any help will be deeply appreciated.
Gerardo

Are you doing transaction handling in your saving code? You should.

ups, no i'm not.... thanks

i thought not setting up transaction was like using atomic trans

would it be too much to ask you to point me to some docs? :)

The Hibernate reference documentation has a chapter that is named "Transactions". Also start reading on transactions wrt your database documentation.

http://www.hibernate.org/hib_docs/refer ... tions.html
As christan has already mentioned.

thanks both of you!