使用mysql时能提交 ,使用sqlserver 时 控制台Hibernate: insert into users (address, email, name, passQuestion, passReply, password, phone, trueName) values (?, ?, ?, ?, ?, ?, ?, ?)
但数据库users表中还是空的 配置都差不多 用的是hql 谁知道为什么啊 hibernate配置
<session-factory> <!-- Database connection settings -->
<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="connection.url">jdbc:sqlserver://localhost:1433; DatabaseName=community</property>
<property name="connection.username">sa</property>
<property name="connection.password">123654123</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<property name="current_session_context_class">thread</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property> <!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> <!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<property name="format_sql">false</property>
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">update</property>
<!--采用注释 -->
<mapping class="com.lin.community.model.PersonalMsg"></mapping>
<mapping class="com.lin.community.model.Contact"></mapping>
<mapping class="com.lin.community.model.Users"></mapping>
<!--采用xml配置model-->
<!--<mapping resource="com/lin/query/model/PersonalMsg.hbm.xml"></mapping>-->
</session-factory></hibernate-configuration>
但数据库users表中还是空的 配置都差不多 用的是hql 谁知道为什么啊 hibernate配置
<session-factory> <!-- Database connection settings -->
<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="connection.url">jdbc:sqlserver://localhost:1433; DatabaseName=community</property>
<property name="connection.username">sa</property>
<property name="connection.password">123654123</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<property name="current_session_context_class">thread</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property> <!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> <!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<property name="format_sql">false</property>
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">update</property>
<!--采用注释 -->
<mapping class="com.lin.community.model.PersonalMsg"></mapping>
<mapping class="com.lin.community.model.Contact"></mapping>
<mapping class="com.lin.community.model.Users"></mapping>
<!--采用xml配置model-->
<!--<mapping resource="com/lin/query/model/PersonalMsg.hbm.xml"></mapping>-->
</session-factory></hibernate-configuration>
System.out.println(u);
SessionFactory sf=hibernateTemplate.getSessionFactory();
Session s=sf.openSession();
s.beginTransaction();
s.save(u);
s.getTransaction().commit();
hibernateTemplate.save(u);
return true;
}改成这样还不行 应该不是事务提交问题吧 谁遇到过帮下忙啊
<property name="connection.url">jdbc:jtds:sqlserver://localhost:1433; DatabaseName=community</property>
你的save()方法中最后需要关闭session