Question

急！急!求高手帮忙啊！hibernate连接sqlserver数据库 出现以下问题

Exception in thread "main" java.lang.AbstractMethodError: com.microsoft.jdbc.base.BaseDatabaseMetaData.getJDBCMajorVersion()I
at org.hibernate.engine.jdbc.JdbcSupportLoader.useContextualLobCreation(JdbcSupportLoader.java:78)
at org.hibernate.engine.jdbc.JdbcSupportLoader.loadJdbcSupport(JdbcSupportLoader.java:52)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:118)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
at com.hibernarte.test.PepoleTest.main(PepoleTest.java:24)

部分代码如下：

配置文件

<property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
<property name="connection.url">jdbc:microsoft:sqlserver://localhost:1433;databasename=HibernateTest</property>
<property name="connection.username">sa</property>
<property name="connection.password">123456</property>

<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<mapping resource="Pepole.hbm.xml"/>
</session-factory>
</hibernate-configuration
>

映射文件

<hibernate-mapping package="com.hibernarte.test">

<class name="Pepole" table="pepole">
<id name="id" column="id"></id>
<property name="name" column="name" type="string"></property>
<property name="sex" column="sex" type="string"></property>
<property name="age" column="age" type="int"></property>
</class>

</hibernate-mapping>

测试类
public class PepoleTest {

public static void main(String[] args) throws Exception{

Configuration conf = new Configuration().configure();

SessionFactory sf = conf.buildSessionFactory();

Session sess = sf.openSession();

Transaction t = sess.beginTransaction();

Pepole p = new Pepole();

p.setId("1");
p.setName("1");
p.setAge(1);
p.setSex("male");
sess.save(p);
t.commit();
sess.close();
}

}

Answer 1

会不会是你的数据库驱动的那个jar包，版本错误。你确定jar包和你的microsoft的sqlserver版本一致

Answer 2

jdbc写错了。那个Localhost的双杠要反过来 0_o