DLOG4J部署问题 DLOG4J snoop - DLOG4J报错

"

最近想研究一款开源的BLog ，Java开源大全中选了DLOG4J，于是就当了份发布包，但是部署的时候老是报我的Hibernate配置有问题，我都按照setup.txt步骤来做的，郁闷。。。。

首先说下我的windows环境：JDK1.6 + Tomcat6.0 + Mysql 5.1

1、在MySql中创建了数据库`pdlog`（doc/dlog_mysql5.sql）我在原来基础上加了一句创建数据库代码

CREATE DATABASE /*!32312 IF NOT EXISTS*/`pdlog` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `pdlog`;

2、修改 webapp\WEB-INF\classes\下的hibernate.cfg.xml

<session-factory>
       
        <!-- ********** database relative settings ********** -->
       
        <!-- Microsoft Access (must comment the 'dscp.defaultTransactionIsolation' below) -->       
        <!--
        <property name="dialect">com.liusoft.util.db.ODBCDialect</property>
        <property name="dscp.driverClassName">sun.jdbc.odbc.JdbcOdbcDriver</property>
        <property name="dscp.url">jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ={DLOG4J}\WEB-INF\dlog.mdb</property>       
        <property name="dscp.username">admin</property>
        <property name="dscp.password"></property>
        <property name="dscp.encoding">false</property>       
        -->
        <!-- MySQL 3/4/5 -->
        <!-- ?useUnicode=true&characterEncoding=GBK -->
       
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="dscp.driverClassName">com.mysql.jdbc.Driver</property>
        <property name="dscp.url">jdbc:mysql://localhost:3306/pdlog</property>               
        <property name="dscp.username">root</property>
        <property name="dscp.password">root</property>
       
       
        <!-- Microsoft SQLServer (via jTDS) -->
        <!--
        <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
        <property name="dscp.driverClassName">net.sourceforge.jtds.jdbc.Driver</property>
        <property name="dscp.url">jdbc:jtds:sqlserver://localhost:1433/dlog;useCursors=true</property>               
        <property name="dscp.username">sa</property>
        <property name="dscp.password"></property>       
        -->
       
        <!-- IBM DB2 -->
        <!--
        <property name="dialect">org.hibernate.dialect.DB2Dialect</property>
        <property name="dscp.driverClassName">com.ibm.db2.jcc.DB2Driver</property>
        <property name="dscp.url">jdbc:db2://localhost:50000/dlog</property>               
        <property name="dscp.username">db2inst1</property>
        <property name="dscp.password"></property>       
        -->
       
        <!-- Oracle -->
        <!--
        <property name="dialect">org.hibernate.dialect.OracleDialect</property>
        <property name="dscp.driverClassName">oracle.jdbc.driver.OracleDriver</property>
        <property name="dscp.url">jdbc:oracle:thin:@localhost:1521:dlog</property>               
        <property name="dscp.username">ora</property>
        <property name="dscp.password"></property>       
        -->
       
        <!-- Informix -->
        <!--
        <property name="dialect">org.hibernate.dialect.InformixDialect</property>
        <property name="dscp.driverClassName">com.informix.jdbc.IfxDriver</property>
        <property name="dscp.url">jdbc:informix-sqli://localhost:1526/dlog:informixserver=server1</property>               
        <property name="dscp.username">root</property>
        <property name="dscp.password"></property>       
        <property name="dscp.encoding">true</property>
        -->
       
        <!-- Sybase (via jTDS) -->
        <!--
        <property name="dialect">org.hibernate.dialect.SybaseDialect</property>
        <property name="dscp.driverClassName">net.sourceforge.jtds.jdbc.Driver</property>
        <property name="dscp.url">jdbc:jtds:sybase://localhost:7100/dlog;useCursors=true</property>               
        <property name="dscp.username">root</property>
        <property name="dscp.password"></property>
        -->
       
        <!-- PostgreSQL -->
        <!--
        <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
        <property name="dscp.driverClassName">org.postgresql.Driver</property>
        <property name="dscp.url">jdbc:postgresql://localhost:5432/dlog</property>               
        <property name="dscp.username">root</property>
        <property name="dscp.password"></property>
        -->
       
        <!-- MaxDB(SAPDB) -->
        <!--
        <property name="dialect">org.hibernate.dialect.SAPDBDialect</property>
        <property name="dscp.driverClassName">com.sap.dbtech.jdbc.DriverSapDB</property>
        <property name="dscp.url">jdbc:sapdb://localhost/dlog</property>               
        <property name="dscp.username">root</property>
        <property name="dscp.password"></property>
        -->
       
        <!-- HSQLDB -->
        <!--
        <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
        <property name="dscp.driverClassName">org.hsqldb.jdbcDriver</property>
        <property name="dscp.url">jdbc:hsqldb:hsql://localhost/dlog</property>               
        <property name="dscp.username">admin</property>
        <property name="dscp.password"></property>
        -->
       
        <!-- ********** database independence settings ********** -->
        <property name="connection.provider_class">com.liusoft.dlog4j.db.DataSourceConnectionProvider</property>
       
        <!-- Connection Pool using DBCP -->       
        <property name="dscp.datasource">org.apache.commons.dbcp.BasicDataSource</property>
        <property name="dscp.initialSize">1</property>
        <property name="dscp.maxActive">200</property>
        <property name="dscp.maxIdle">10</property>
        <property name="dscp.maxWait">2000</property>
        <property name="dscp.defaultAutoCommit">false</property>
        <property name="dscp.poolPreparedStatements">true</property>
        <property name="dscp.maxOpenPreparedStatements">1000</property>
        <!-- TRANSACTION_READ_UNCOMMITTED -->
        <!--
        <property name="dscp.defaultTransactionIsolation">1</property>       
        -->
       
        <!-- ********** global settings ********** -->
        <property name="show_sql">false</property>
        <property name="jdbc.batch_size">100</property>
        <property name="use_outer_join">false</property>
        <property name="cache.use_query_cache">true</property>
        <property name="default_batch_fetch_size">20</property>
        <property name="jdbc.use_scrollable_resultset">true</property>
        <property name="jdbc.use_reflection_optimizer">true</property>
       
        <!-- ********** beans mapping **********
       
        <mapping resource="access/dlog.hbm.xml"/>
        <mapping resource="access/core.hbm.xml"/>
        <mapping resource="access/diary.hbm.xml"/>   
        <mapping resource="access/photo.hbm.xml"/>
        <mapping resource="access/music.hbm.xml"/>       
        <mapping resource="access/bbs.hbm.xml"/>
        <mapping resource="access/query.hbm.xml"/>
        <mapping resource="access/other.hbm.xml"/>
        -->
   
        <mapping resource="com/liusoft/dlog4j/hbm/dlog.hbm.xml"/>
        <mapping resource="com/liusoft/dlog4j/hbm/core.hbm.xml"/>
        <mapping resource="com/liusoft/dlog4j/hbm/diary.hbm.xml"/>   
        <mapping resource="com/liusoft/dlog4j/hbm/photo.hbm.xml"/>
        <mapping resource="com/liusoft/dlog4j/hbm/music.hbm.xml"/>       
        <mapping resource="com/liusoft/dlog4j/hbm/bbs.hbm.xml"/>
        <mapping resource="com/liusoft/dlog4j/hbm/query.hbm.xml"/>
        <mapping resource="com/liusoft/dlog4j/hbm/other.hbm.xml"/>
       
       
    </session-factory>

把Acess的链接注释掉了，把MySql数据库链接打开、口令端口啥的都改了，并且相应的beans mapping也做了注释、打开

3、之后把webapp拷贝到Tomcat下面，命名为dlog4j，然后启动服务，访问http://localhost:8099/dlog4j/snoop.vm

报错：

DLOG4J snoop

 Database

• Database error , check the db config (hibernate.cfg.xml)