Hibernate居然JDBC连不上

2009-11-08 03:52:13 112 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Windows系统3D Gaussian Splatting环境搭建全攻略：从零开始到成功运行本文详细介绍了在Windows系统上搭建3D Gaussian Splatting环境的完整流程，包括CUDA 12.6安装、Anaconda环境配置、代码获取与依赖安装等关键步骤。针对Windows平台特有的环境配置问题，提供了实用的解决方案和常见错误排查方法，帮助开发者快速实现3D Gaussian Splatting的成功运行。阅读详情

各种配置都弄好了，Hibernate 3的那些库都加上了，SqlServer的3个Jar也加了，msbase.jar,mssqlserver.jar,msutil.jar

现在写了个简单的代码测试session创建



        org.hibernate.SessionFactory sessionFactory = new org.hibernate.cfg.

                Configuration().configure().buildSessionFactory();

        org.hibernate.Session session = sessionFactory.openSession();

        System.out.println("----------qry1----------");

        org.hibernate.Query qry = session.createQuery("from FriendBean");

        java.util.List list = qry.list();

        for (int i = 0; i < list.size(); i++) {

            FriendBean frdTest = (FriendBean) list.get(i);

            System.out.println(frdTest.getName());

        }

cfg配置文件是这么写的



<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

  <session-factory>

    <!-- Database connection settings -->

    <property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>

    <property name="connection.url">jdbc:sqlserver://localhost\BWL:1433;DatabaseName=Friends</property>

    <property name="connection.username">sa</property>

    <property name="connection.password">biweilun</property>

    <!-- JDBC connection pool (use the built-in) -->

    <property name="connection.pool_size">5</property>

    <!-- SQL dialect -->

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

    <!-- Enable Hibernate's automatic session context management -->

    <property name="current_session_context_class">thread</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>

    <mapping resource="hibernatetask/Friend.hbm.xml"/>

  </session-factory>

</hibernate-configuration>

运行就抛连接异常

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
----------qry1----------
Exception in thread "main" org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at hibernatetask.Main.main(Main.java:31)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
... 14 more
Java Result: 1
成功生成（总时间：13 秒）

...全文