hibernate C3P0数据连接池问题

chanlda 2010-02-09 10:28:16

出错：



1063 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)   

1063 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size:20  

1063 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false  

1078 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: org.hibernate.connection.C3P0ConnectionProvider at URL: jdbc:mysql://localhost:3306/test   

1078 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=****}   

1078 [main] WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection to query metadata   

java.sql.SQLException: No suitable driver   

    at java.sql.DriverManager.getConnection(Unknown Source)   

    at java.sql.DriverManager.getConnection(Unknown Source)   

    at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)   

    at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)   

    at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)   

    at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)   

    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)   

    at com.gdcc.util.HiberanteSessionFactoryUtil.<clinit>(HiberanteSessionFactoryUtil.java:14)   

    at com.gdcc.test.HibernateTest.load(HibernateTest.java:46)   

    at com.gdcc.test.HibernateTest.main(HibernateTest.java:21)



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

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

    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)   

    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)   

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

    at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)   

    at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)   

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

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

    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:342)   

    at $Proxy0.beginTransaction(Unknown Source)   

    at com.gdcc.test.HibernateTest.load(HibernateTest.java:47)   

    at com.gdcc.test.HibernateTest.main(HibernateTest.java:21)   

Caused by: java.sql.SQLException: No suitable driver   

    at java.sql.DriverManager.getConnection(Unknown Source)   

    at java.sql.DriverManager.getConnection(Unknown Source)   

    at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)   

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

    ... 12 more

hiberante.cfg.xml



<session-factory>   

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

    <property name="connection.url">jdbc:mysql://localhost:3306/demo</property>   

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

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

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

    <property name="connection.driver_class">   

        com.mysql.jdbc.Driver   

    </property>   

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

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

  

    <property name="connection.driver_class">org.hibernate.connection.C3P0ConnectionProvider</property>   

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

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

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

    <property name="c3p0.max_statements">10</property>   

  

  

    <mapping resource="com/gdcc/bean/Book.hbm.xml" />   

  

  

</session-factory>