mysql 自动创建表失败,MySQL不能自动创建表格缘故小结

hibernate.properties

######################

### Query Language ###

######################

## define query language constants / function names

hibernate.query.substitutions yes 'Y', no 'N'

## select the classic query parser

#hibernate.query.factory_class org.hibernate.hql.classic.ClassicQueryTranslatorFactory

#################

### Platforms ###

#################

## JNDI Datasource

#hibernate.connection.datasource jdbc/test

#hibernate.connection.username db2

#hibernate.connection.password db2

## HypersonicSQL

hibernate.dialect org.hibernate.dialect.HSQLDialect

hibernate.connection.driver_class org.hsqldb.jdbcDriver

hibernate.connection.username sa

hibernate.connection.password

hibernate.connection.url jdbc:hsqldb:./build/db/hsqldb/hibernate

#hibernate.connection.url jdbc:hsqldb:hsql://localhost

#hibernate.connection.url jdbc:hsqldb:test

## H2 (www.h2database.com)

#hibernate.dialect org.hibernate.dialect.H2Dialect

#hibernate.connection.driver_class org.h2.Driver

#hibernate.connection.username sa

#hibernate.connection.password

#hibernate.connection.url jdbc:h2:mem:./build/db/h2/hibernate

#hibernate.connection.url jdbc:h2:testdb/h2test

#hibernate.connection.url jdbc:h2:mem:imdb1

#hibernate.connection.url jdbc:h2:tcp://dbserv:8084/sample;

#hibernate.connection.url jdbc:h2:ssl://secureserv:8085/sample;

#hibernate.connection.url jdbc:h2:ssl://secureserv/testdb;cipher=AES

## MySQL

#hibernate.dialect org.hibernate.dialect.MySQLDialect

#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect

#hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect

#hibernate.connection.driver_class com.mysql.jdbc.Driver

#hibernate.connection.url jdbc:mysql:///test

#hibernate.connection.username gavin

#hibernate.connection.password

## Oracle

#hibernate.dialect org.hibernate.dialect.OracleDialect

#hibernate.dialect org.hibernate.dialect.Oracle9Dialect

#hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver

#hibernate.connection.username ora

#hibernate.connection.password ora

#hibernate.connection.url jdbc:oracle:thin:@localhost:1521:orcl

#hibernate.connection.url jdbc:oracle:thin:@localhost:1522:XE

## PostgreSQL

#hibernate.dialect org.hibernate.dialect.PostgreSQLDialect

#hibernate.connection.driver_class org.postgresql.Driver

#hibernate.connection.url jdbc:postgresql:template1

#hibernate.connection.username pg

#hibernate.connection.password

## DB2

#hibernate.dialect org.hibernate.dialect.DB2Dialect

#hibernate.connection.driver_class com.ibm.db2.jcc.DB2Driver

#hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver

#hibernate.connection.url jdbc:db2://localhost:50000/somename

#hibernate.connection.url jdbc:db2:somename

#hibernate.connection.username db2

#hibernate.connection.password db2

## TimesTen

#hibernate.dialect org.hibernate.dialect.TimesTenDialect

#hibernate.connection.driver_class com.timesten.jdbc.TimesTenDriver

#hibernate.connection.url jdbc:timesten:direct:test

#hibernate.connection.username

#hibernate.connection.password

## DB2/400

#hibernate.dialect org.hibernate.dialect.DB2400Dialect

#hibernate.connection.username user

#hibernate.connection.password password

## Native driver

#hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver

#hibernate.connection.url jdbc:db2://systemname

## Toolbox driver

#hibernate.connection.driver_class com.ibm.as400.access.AS400JDBCDriver

#hibernate.connection.url jdbc:as400://systemname

## Derby (not supported!)

#hibernate.dialect org.hibernate.dialect.DerbyDialect

#hibernate.connection.driver_class org.apache.derby.jdbc.EmbeddedDriver

#hibernate.connection.username

#hibernate.connection.password

#hibernate.connection.url jdbc:derby:build/db/derby/hibernate;create=true

## Sybase

#hibernate.dialect org.hibernate.dialect.SybaseDialect

#hibernate.connection.driver_class com.sybase.jdbc2.jdbc.SybDriver

#hibernate.connection.username sa

#hibernate.connection.password sasasa

#hibernate.connection.url jdbc:sybase:Tds:co3061835-a:5000/tempdb

## Mckoi SQL

#hibernate.dialect org.hibernate.dialect.MckoiDialect

#hibernate.connection.driver_class com.mckoi.JDBCDriver

#hibernate.connection.url jdbc:mckoi:///

#hibernate.connection.url jdbc:mckoi:local://C:/mckoi1.0.3/db.conf

#hibernate.connection.username admin

#hibernate.connection.password nimda

## SAP DB

#hibernate.dialect org.hibernate.dialect.SAPDBDialect

#hibernate.connection.driver_class com.sap.dbtech.jdbc.DriverSapDB

#hibernate.connection.url jdbc:sapdb://localhost/TST

#hibernate.connection.username TEST

#hibernate.connection.password TEST

#hibernate.query.substitutions yes 'Y', no 'N'

## MS SQL Server