数据库创建表的时候,column为关键字的错误

[framework] 2017-06-02 15:22:31,495 - org.springframework.context.support.ClassPathXmlApplicationContext -12   [main] INFO  org.springframework.context.support.ClassPathXmlApplicationContext  - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@16c0663d: startup date [Fri Jun 02 15:22:31 GMT+08:00 2017]; root of context hierarchy
[framework] 2017-06-02 15:22:31,594 - org.springframework.beans.factory.xml.XmlBeanDefinitionReader -111  [main] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader  - Loading XML bean definitions from class path resource [bean1.xml]
[framework] 2017-06-02 15:22:31,767 - org.springframework.context.annotation.ClassPathBeanDefinitionScanner -284  [main] INFO  org.springframework.context.annotation.ClassPathBeanDefinitionScanner  - JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning
[framework] 2017-06-02 15:22:31,961 - org.springframework.beans.factory.config.PropertyPlaceholderConfigurer -478  [main] INFO  org.springframework.beans.factory.config.PropertyPlaceholderConfigurer  - Loading properties file from class path resource [jdbc.properties]
[framework] 2017-06-02 15:22:32,030 - org.springframework.beans.factory.support.DefaultListableBeanFactory -547  [main] INFO  org.springframework.beans.factory.support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@34c4973: defining beans [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,dataSource,sessionFactory,hibernateTransactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor]; root of factory hierarchy
[framework] 2017-06-02 15:22:32,057 - com.mchange.v2.log.MLog -574  [main] INFO  com.mchange.v2.log.MLog  - MLog clients using log4j logging.
[framework] 2017-06-02 15:22:32,425 - com.mchange.v2.c3p0.C3P0Registry -942  [main] INFO  com.mchange.v2.c3p0.C3P0Registry  - Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
[framework] 2017-06-02 15:22:32,663 - org.hibernate.cfg.Environment -1180 [main] INFO  org.hibernate.cfg.Environment  - Hibernate 3.5.6-Final
[framework] 2017-06-02 15:22:32,666 - org.hibernate.cfg.Environment -1183 [main] INFO  org.hibernate.cfg.Environment  - hibernate.properties not found
[framework] 2017-06-02 15:22:32,670 - org.hibernate.cfg.Environment -1187 [main] INFO  org.hibernate.cfg.Environment  - Bytecode provider name : javassist
[framework] 2017-06-02 15:22:32,674 - org.hibernate.cfg.Environment -1191 [main] INFO  org.hibernate.cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
[framework] 2017-06-02 15:22:32,791 - org.hibernate.cfg.Configuration -1308 [main] INFO  org.hibernate.cfg.Configuration  - configuring from url: file:/D:/eclipse/Eclips%20IDE%20for%20javaEE%20Developers/javaWeb/wifi1/build/classes/hibernate.cfg.xml
[framework] 2017-06-02 15:22:36,211 - org.hibernate.cfg.Configuration -4728 [main] INFO  org.hibernate.cfg.Configuration  - Reading mappings from resource : cn/hbmy/entity/Phone.hbm.xml
[framework] 2017-06-02 15:22:44,916 - org.hibernate.cfg.HbmBinder -13433 [main] INFO  org.hibernate.cfg.HbmBinder  - Mapping class: cn.hbmy.entity.Phone -> t_detail1
[framework] 2017-06-02 15:22:45,018 - org.hibernate.cfg.Configuration -13535 [main] INFO  org.hibernate.cfg.Configuration  - Reading mappings from resource : cn/hbmy/entity/Data.hbm.xml
[framework] 2017-06-02 15:22:51,731 - org.hibernate.cfg.HbmBinder -20248 [main] INFO  org.hibernate.cfg.HbmBinder  - Mapping class: cn.hbmy.entity.Data -> t_data1
[framework] 2017-06-02 15:22:51,741 - org.hibernate.cfg.Configuration -20258 [main] INFO  org.hibernate.cfg.Configuration  - Configured SessionFactory: null
[framework] 2017-06-02 15:22:51,759 - org.hibernate.cfg.HbmBinder -20276 [main] INFO  org.hibernate.cfg.HbmBinder  - Mapping collection: cn.hbmy.entity.Data.phone -> t_detail1
[framework] 2017-06-02 15:22:51,762 - org.springframework.orm.hibernate3.LocalSessionFactoryBean -20279 [main] INFO  org.springframework.orm.hibernate3.LocalSessionFactoryBean  - Building new Hibernate SessionFactory
[framework] 2017-06-02 15:22:51,770 - org.hibernate.connection.ConnectionProviderFactory -20287 [main] INFO  org.hibernate.connection.ConnectionProviderFactory  - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
[framework] 2017-06-02 15:22:51,831 - com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource -20348 [main] INFO  com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource  - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge17a9osro8cd10tx05c|75c072cb, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge17a9osro8cd10tx05c|75c072cb, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql:///wifi, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
[framework] 2017-06-02 15:22:52,131 - org.hibernate.cfg.SettingsFactory -20648 [main] INFO  org.hibernate.cfg.SettingsFactory  - RDBMS: MySQL, version: 5.6.21
[framework] 2017-06-02 15:22:52,132 - org.hibernate.cfg.SettingsFactory -20649 [main] INFO  org.hibernate.cfg.SettingsFactory  - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.10 ( Revision: ${svn.Revision} )
[framework] 2017-06-02 15:22:52,146 - org.hibernate.dialect.Dialect -20663 [main] INFO  org.hibernate.dialect.Dialect  - Using dialect: org.hibernate.dialect.MySQLDialect
[framework] 2017-06-02 15:22:52,150 - org.hibernate.engine.jdbc.JdbcSupportLoader -20667 [main] INFO  org.hibernate.engine.jdbc.JdbcSupportLoader  - Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
[framework] 2017-06-02 15:22:52,153 - org.hibernate.transaction.TransactionFactoryFactory -20670 [main] INFO  org.hibernate.transaction.TransactionFactoryFactory  - Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
[framework] 2017-06-02 15:22:52,154 - org.hibernate.transaction.TransactionManagerLookupFactory -20671 [main] INFO  org.hibernate.transaction.TransactionManagerLookupFactory  - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[framework] 2017-06-02 15:22:52,155 - org.hibernate.cfg.SettingsFactory -20672 [main] INFO  org.hibernate.cfg.SettingsFactory  - Automatic flush during beforeCompletion(): disabled
[framework] 2017-06-02 15:22:52,155 - org.hibernate.cfg.SettingsFactory -20672 [main] INFO  org.hibernate.cfg.SettingsFactory  - Automatic session close at end of transaction: disabled
[framework] 2017-06-02 15:22:52,155 - org.hibernate.cfg.SettingsFactory -20672 [main] INFO  org.hibernate.cfg.SettingsFactory  - JDBC batch size: 15
[framework] 2017-06-02 15:22:52,156 - org.hibernate.cfg.SettingsFactory -20673 [main] INFO  org.hibernate.cfg.SettingsFactory  - JDBC batch updates for versioned data: disabled
[framework] 2017-06-02 15:22:52,157 - org.hibernate.cfg.SettingsFactory -20674 [main] INFO  org.hibernate.cfg.SettingsFactory  - Scrollable result sets: enabled
[framework] 2017-06-02 15:22:52,157 - org.hibernate.cfg.SettingsFactory -20674 [main] INFO  org.hibernate.cfg.SettingsFactory  - JDBC3 getGeneratedKeys(): enabled
[framework] 2017-06-02 15:22:52,158 - org.hibernate.cfg.SettingsFactory -20675 [main] INFO  org.hibernate.cfg.SettingsFactory  - Connection release mode: auto
[framework] 2017-06-02 15:22:52,159 - org.hibernate.cfg.SettingsFactory -20676 [main] INFO  org.hibernate.cfg.SettingsFactory  - Maximum outer join fetch depth: 2
[framework] 2017-06-02 15:22:52,160 - org.hibernate.cfg.SettingsFactory -20677 [main] INFO  org.hibernate.cfg.SettingsFactory  - Default batch fetch size: 1
[framework] 2017-06-02 15:22:52,160 - org.hibernate.cfg.SettingsFactory -20677 [main] INFO  org.hibernate.cfg.SettingsFactory  - Generate SQL with comments: disabled
[framework] 2017-06-02 15:22:52,160 - org.hibernate.cfg.SettingsFactory -20677 [main] INFO  org.hibernate.cfg.SettingsFactory  - Order SQL updates by primary key: disabled
[framework] 2017-06-02 15:22:52,161 - org.hibernate.cfg.SettingsFactory -20678 [main] INFO  org.hibernate.cfg.SettingsFactory  - Order SQL inserts for batching: disabled
[framework] 2017-06-02 15:22:52,161 - org.hibernate.cfg.SettingsFactory -20678 [main] INFO  org.hibernate.cfg.SettingsFactory  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[framework] 2017-06-02 15:22:52,163 - org.hibernate.hql.ast.ASTQueryTranslatorFactory -20680 [main] INFO  org.hibernate.hql.ast.ASTQueryTranslatorFactory  - Using ASTQueryTranslatorFactory
[framework] 2017-06-02 15:22:52,163 - org.hibernate.cfg.SettingsFactory -20680 [main] INFO  org.hibernate.cfg.SettingsFactory  - Query language substitutions: {}
[framework] 2017-06-02 15:22:52,163 - org.hibernate.cfg.SettingsFactory -20680 [main] INFO  org.hibernate.cfg.SettingsFactory  - JPA-QL strict compliance: disabled
[framework] 2017-06-02 15:22:52,164 - org.hibernate.cfg.SettingsFactory -20681 [main] INFO  org.hibernate.cfg.SettingsFactory  - Second-level cache: enabled
[framework] 2017-06-02 15:22:52,164 - org.hibernate.cfg.SettingsFactory -20681 [main] INFO  org.hibernate.cfg.SettingsFactory  - Query cache: disabled
[framework] 2017-06-02 15:22:52,164 - org.hibernate.cfg.SettingsFactory -20681 [main] INFO  org.hibernate.cfg.SettingsFactory  - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
[framework] 2017-06-02 15:22:52,165 - org.hibernate.cfg.SettingsFactory -20682 [main] INFO  org.hibernate.cfg.SettingsFactory  - Optimize cache for minimal puts: disabled
[framework] 2017-06-02 15:22:52,165 - org.hibernate.cfg.SettingsFactory -20682 [main] INFO  org.hibernate.cfg.SettingsFactory  - Structured second-level cache entries: disabled
[framework] 2017-06-02 15:22:52,168 - org.hibernate.cfg.SettingsFactory -20685 [main] INFO  org.hibernate.cfg.SettingsFactory  - Echoing all SQL to stdout
[framework] 2017-06-02 15:22:52,169 - org.hibernate.cfg.SettingsFactory -20686 [main] INFO  org.hibernate.cfg.SettingsFactory  - Statistics: disabled
[framework] 2017-06-02 15:22:52,170 - org.hibernate.cfg.SettingsFactory -20687 [main] INFO  org.hibernate.cfg.SettingsFactory  - Deleted entity synthetic identifier rollback: disabled
[framework] 2017-06-02 15:22:52,170 - org.hibernate.cfg.SettingsFactory -20687 [main] INFO  org.hibernate.cfg.SettingsFactory  - Default entity-mode: pojo
[framework] 2017-06-02 15:22:52,170 - org.hibernate.cfg.SettingsFactory -20687 [main] INFO  org.hibernate.cfg.SettingsFactory  - Named query checking : enabled
[framework] 2017-06-02 15:22:52,171 - org.hibernate.cfg.SettingsFactory -20688 [main] INFO  org.hibernate.cfg.SettingsFactory  - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
[framework] 2017-06-02 15:22:52,200 - org.hibernate.impl.SessionFactoryImpl -20717 [main] INFO  org.hibernate.impl.SessionFactoryImpl  - building session factory
[framework] 2017-06-02 15:22:52,406 - org.hibernate.impl.SessionFactoryObjectFactory -20923 [main] INFO  org.hibernate.impl.SessionFactoryObjectFactory  - Not binding factory to JNDI, no JNDI name configured
[framework] 2017-06-02 15:22:52,413 - org.hibernate.tool.hbm2ddl.SchemaUpdate -20930 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaUpdate  - Running hbm2ddl schema update
[framework] 2017-06-02 15:22:52,414 - org.hibernate.tool.hbm2ddl.SchemaUpdate -20931 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaUpdate  - fetching database metadata
[framework] 2017-06-02 15:22:52,418 - org.hibernate.tool.hbm2ddl.SchemaUpdate -20935 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaUpdate  - updating schema
[framework] 2017-06-02 15:22:52,451 - org.hibernate.tool.hbm2ddl.TableMetadata -20968 [main] INFO  org.hibernate.tool.hbm2ddl.TableMetadata  - table found: wifi.t_data1
[framework] 2017-06-02 15:22:52,452 - org.hibernate.tool.hbm2ddl.TableMetadata -20969 [main] INFO  org.hibernate.tool.hbm2ddl.TableMetadata  - columns: [mmac, lon, id, lat]
[framework] 2017-06-02 15:22:52,452 - org.hibernate.tool.hbm2ddl.TableMetadata -20969 [main] INFO  org.hibernate.tool.hbm2ddl.TableMetadata  - foreign keys: []
[framework] 2017-06-02 15:22:52,452 - org.hibernate.tool.hbm2ddl.TableMetadata -20969 [main] INFO  org.hibernate.tool.hbm2ddl.TableMetadata  - indexes: [primary]
[framework] 2017-06-02 15:22:52,468 - org.hibernate.tool.hbm2ddl.TableMetadata -20985 [main] INFO  org.hibernate.tool.hbm2ddl.TableMetadata  - table found: wifi.t_detail1
[framework] 2017-06-02 15:22:52,468 - org.hibernate.tool.hbm2ddl.TableMetadata -20985 [main] INFO  org.hibernate.tool.hbm2ddl.TableMetadata  - columns: [rssi, ch, phoneid, tmc, mac, tc, ds, essid3, essid2, essid1, dataid, essid6, essid5, essid4, id, time, ts]
[framework] 2017-06-02 15:22:52,469 - org.hibernate.tool.hbm2ddl.TableMetadata -20986 [main] INFO  org.hibernate.tool.hbm2ddl.TableMetadata  - foreign keys: [fk186ae535ca70b695, fk186ae535f6c0a359]
[framework] 2017-06-02 15:22:52,469 - org.hibernate.tool.hbm2ddl.TableMetadata -20986 [main] INFO  org.hibernate.tool.hbm2ddl.TableMetadata  - indexes: [fk186ae535ca70b695, fk186ae535f6c0a359, primary]
[framework] 2017-06-02 15:22:52,479 - org.hibernate.tool.hbm2ddl.SchemaUpdate -20996 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate  - Unsuccessful: alter table t_detail1 add column range varchar(255)
[framework] 2017-06-02 15:22:52,480 - org.hibernate.tool.hbm2ddl.SchemaUpdate -20997 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate  - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range varchar(255)' at line 2
[framework] 2017-06-02 15:22:52,480 - org.hibernate.tool.hbm2ddl.SchemaUpdate -20997 [main] INFO  org.hibernate.tool.hbm2ddl.SchemaUpdate  - schema update complete
[framework] 2017-06-02 15:22:52,582 - org.springframework.orm.hibernate3.HibernateTransactionManager -21099 [main] INFO  org.springframework.orm.hibernate3.HibernateTransactionManager  - Using DataSource [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge17a9osro8cd10tx05c|75c072cb, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge17a9osro8cd10tx05c|75c072cb, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql:///wifi, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] of Hibernate SessionFactory for HibernateTransactionManager
org.hibernate.impl.SessionFactoryImpl@7d9e8ef7
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值