Hibernate 链接MSSQL出现错误了。

贾米森 2009-06-29 02:05:44

请大家帮忙找一下，谢谢



log4j:WARN No appenders could be found for logger (persistence.HibernateUtil).

log4j:WARN Please initialize the log4j system properly.

Exception in thread "main" org.hibernate.exception.GenericJDBCException: Cannot open connection

	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)

	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.JDBCContext.connection(JDBCContext.java:119)

	at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)

	at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

	at java.lang.reflect.Method.invoke(Unknown Source)

	at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301)

	at $Proxy0.beginTransaction(Unknown Source)

	at test.ImportDB.main(ImportDB.java:19)

Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!

	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)

	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236)

	at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)

	at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)

	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)

	... 11 more

Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)

	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)

	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)

	... 14 more

...全文

90 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

FireElement 2009-06-29

打赏
举报

<property name="myeclipse.connection.profile">sql</property>
这句话没有用

oklinsong 2009-06-29

打赏
举报

不用Hibernate，用jdbc连连看能不能连上，Cannot open connection这是不能打开连接啊

贾米森 2009-06-29

打赏
举报



<?xml version='1.0' encoding='utf-8'?>

<!DOCTYPE hibernate-configuration

        PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"

        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

	<!-- Settings for a MySQL database.-->

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

	<property name="connection.driver_class">

		com.microsoft.jdbc.sqlserver.SQLServerDriver

	</property>

	<property name="connection.url">

		jdbc:microsoft:sqlserer://localhost:1433;DatabaseName=qq

	</property>

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

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

	<property name="myeclipse.connection.profile">sql</property>

	<!-- Use the C3P0 connection pool.-->

	<property name="c3p0.min_size">3</property>

	<property name="c3p0.max_size">5</property>

	<property name="c3p0.timeout">1800</property>

	<property name="current_session_context_class">thread</property>

	<property name="hibernate.show_sql">true</property>

	<mapping resource="com/dzjOa/model/Admin.hbm.xml" />

</session-factory>

</hibernate-configuration>