[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
[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