MySQL check the manual that corresponds to your MySQL server version for the right syntax错误_samile6899的博客-程序员秘密

技术标签: jsp  j2ee  SSH  框架整合  javaee  

     最近在做一个Web项目的时候,SSH框架实体映射生成表的时候,其中一个实体无法生成相应的数据表,在仔细分析了日志的情况下,找到了相关的错误信息,错误信息显示“  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 'desc varchar(255), primary key (id))' at line 1 ”。

十月 10, 2016 3:03:54 下午 org.apache.catalina.core.AprLifecycleListener init
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\SoftWare\Java\JDK\jdk1.7\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;D:\SoftWare\Java\JDK\jdk1.7\jre\bin;D:/SoftWare/Java/JDK/jdk1.7/bin/server;D:/SoftWare/Java/JDK/jdk1.7/bin;D:/SoftWare/Java/JDK/jdk1.7/lib/amd64;D:\SoftWare\Java\Oracle\PATH\app\user\product\11.2.0\dbhome_1\bin;D:\app\user\product\11.2.0\dbhome_1\bin;C:\Program Files (x86)\Common Files\NetSarang;D:\SoftWare\Java\Oracle\Path\app\oracle\product\11.2.0\server\bin;;.;D:\SoftWare\Java\JDK\jdk1.7\bin;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;D:\SoftWare\Java\SVN\Path\bin;C:\Users\user\Desktop\Work\Other\网站\赚淘网\WebAPP\学习\Cordova\file\Path\notejs;%ANT_HOME%\bin;%ANDROID_HOME%/tools;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;D:\SoftWare\Linux\SSH\Path;C:\Users\user\AppData\Roaming\npm;;D:\SoftWare\Java\Eclipse\eclipse;;.
十月 10, 2016 3:03:54 下午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:Mi' did not find a matching property.
十月 10, 2016 3:03:54 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-bio-8342"]
十月 10, 2016 3:03:54 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-bio-8009"]
十月 10, 2016 3:03:54 下午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 1118 ms
十月 10, 2016 3:03:54 下午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
十月 10, 2016 3:03:54 下午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/7.0.42
十月 10, 2016 3:03:55 下午 org.apache.catalina.util.SessionIdGenerator createSecureRandom
信息: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [196] milliseconds.
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/core_rt is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/core is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jsp/jstl/functions is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jsp/jstl/sql is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jsp/jstl/xml is already defined
十月 10, 2016 3:04:01 下午 org.apache.catalina.core.ApplicationContext log
信息: No Spring WebApplicationInitializer types detected on classpath
十月 10, 2016 3:04:01 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
2016-10-10 15:04:01 [ INFO] - org.springframework.web.context.ContextLoader -ContextLoader.java(272) -Root WebApplicationContext: initialization started
  2016-10-10 15:04:02 [ INFO] - org.springframework.web.context.support.XmlWebApplicationContext -AbstractApplicationContext.java(495) -Refreshing Root WebApplicationContext: startup date [Mon Oct 10 15:04:02 CST 2016]; root of context hierarchy
  2016-10-10 15:04:02 [ INFO] - org.springframework.beans.factory.xml.XmlBeanDefinitionReader -XmlBeanDefinitionReader.java(315) -Loading XML bean definitions from file [D:\SoftWare\Java\Eclipse\Program\One\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Mi\WEB-INF\classes\applicationContext-Quartz.xml]
  2016-10-10 15:04:02 [ INFO] - org.springframework.beans.factory.xml.XmlBeanDefinitionReader -XmlBeanDefinitionReader.java(315) -Loading XML bean definitions from file [D:\SoftWare\Java\Eclipse\Program\One\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Mi\WEB-INF\classes\applicationContext.xml]
  2016-10-10 15:04:03 [ INFO] - org.springframework.beans.factory.config.PropertyPlaceholderConfigurer -PropertiesLoaderSupport.java(177) -Loading properties file from class path resource [jdbc.properties]
  2016-10-10 15:04:03 [ INFO] - org.springframework.beans.factory.support.DefaultListableBeanFactory -DefaultListableBeanFactory.java(557) -Pre-instantiating singletons in org.s[email protected]36b6f03a: defining beans [testService,jobFactory,Scheduler,jobManager,JobService,domainclass,domainrear,miDao,mishowall,mishow,miService,shwAction,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,txManager,txAdvice,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0]; root of factory hierarchy
  2016-10-10 15:04:03 [ INFO] - com.mchange.v2.log.MLog -MLog.java(80) -MLog clients using log4j logging.
  2016-10-10 15:04:04 [ INFO] - com.mchange.v2.c3p0.C3P0Registry -C3P0Registry.java(204) -Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
  2016-10-10 15:04:04 [ INFO] - org.hibernate.cfg.Environment -Environment.java(570) -Hibernate 3.5.6-Final
  2016-10-10 15:04:04 [ INFO] - org.hibernate.cfg.Environment -Environment.java(603) -hibernate.properties not found
  2016-10-10 15:04:04 [ INFO] - org.hibernate.cfg.Environment -Environment.java(781) -Bytecode provider name : javassist
  2016-10-10 15:04:04 [ INFO] - org.hibernate.cfg.Environment -Environment.java(662) -using JDK 1.4 java.sql.Timestamp handling
  2016-10-10 15:04:04 [ INFO] - org.hibernate.cfg.Configuration -Configuration.java(1533) -configuring from url: file:/D:/SoftWare/Java/Eclipse/Program/One/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/Mi/WEB-INF/classes/hibernate.cfg.xml
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.Configuration -Configuration.java(1633) -Configured SessionFactory: null
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.Configuration -Configuration.java(386) -Reading mappings from file: D:\SoftWare\Java\Eclipse\Program\One\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Mi\WEB-INF\classes\com\juyuan238\mi\domain\doMainclass.hbm.xml
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.HbmBinder -HbmBinder.java(348) -Mapping class: com.juyuan238.mi.domain.doMainclass -> domainclass
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.Configuration -Configuration.java(386) -Reading mappings from file: D:\SoftWare\Java\Eclipse\Program\One\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Mi\WEB-INF\classes\com\juyuan238\mi\domain\doMainrear.hbm.xml
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.HbmBinder -HbmBinder.java(348) -Mapping class: com.juyuan238.mi.domain.doMainrear -> domainrear
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.Configuration -Configuration.java(386) -Reading mappings from file: D:\SoftWare\Java\Eclipse\Program\One\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Mi\WEB-INF\classes\com\juyuan238\mi\domain\Mi.hbm.xml
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.HbmBinder -HbmBinder.java(348) -Mapping class: com.juyuan238.mi.domain.Mi -> mi
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.Configuration -Configuration.java(386) -Reading mappings from file: D:\SoftWare\Java\Eclipse\Program\One\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Mi\WEB-INF\classes\com\juyuan238\mi\domain\mishow.hbm.xml
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.HbmBinder -HbmBinder.java(348) -Mapping class: com.juyuan238.mi.domain.mishow -> mishow
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.Configuration -Configuration.java(386) -Reading mappings from file: D:\SoftWare\Java\Eclipse\Program\One\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Mi\WEB-INF\classes\com\juyuan238\mi\domain\mishowall.hbm.xml
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.HbmBinder -HbmBinder.java(348) -Mapping class: com.juyuan238.mi.domain.mishowall -> mishowall
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.Configuration -Configuration.java(386) -Reading mappings from file: D:\SoftWare\Java\Eclipse\Program\One\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Mi\WEB-INF\classes\com\juyuan238\mi\domain\schedulejob.hbm.xml
  2016-10-10 15:04:05 [ INFO] - org.hibernate.cfg.HbmBinder -HbmBinder.java(348) -Mapping class: com.juyuan238.mi.domain.schedulejob -> schedulejob
  2016-10-10 15:04:05 [ INFO] - org.springframework.orm.hibernate3.LocalSessionFactoryBean -LocalSessionFactoryBean.java(777) -Building new Hibernate SessionFactory
  2016-10-10 15:04:05 [ INFO] - org.hibernate.connection.ConnectionProviderFactory -ConnectionProviderFactory.java(173) -Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
  2016-10-10 15:04:05 [ INFO] - com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource -AbstractPoolBackedDataSource.java(462) -Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgey2p9j1c43kk91cxxfjm|5bf9dff9, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgey2p9j1c43kk91cxxfjm|5bf9dff9, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/mi, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 2, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(117) -RDBMS: MySQL, version: 5.5.28
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(118) -JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} )
  2016-10-10 15:04:06 [ INFO] - org.hibernate.dialect.Dialect -Dialect.java(206) -Using dialect: org.hibernate.dialect.MySQL5Dialect
  2016-10-10 15:04:06 [ INFO] - org.hibernate.engine.jdbc.JdbcSupportLoader -JdbcSupportLoader.java(79) -Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
  2016-10-10 15:04:06 [ INFO] - org.hibernate.transaction.TransactionFactoryFactory -TransactionFactoryFactory.java(62) -Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
  2016-10-10 15:04:06 [ INFO] - org.hibernate.transaction.TransactionManagerLookupFactory -TransactionManagerLookupFactory.java(80) -No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(169) -Automatic flush during beforeCompletion(): disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(173) -Automatic session close at end of transaction: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(180) -JDBC batch size: 15
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(183) -JDBC batch updates for versioned data: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(188) -Scrollable result sets: enabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(196) -JDBC3 getGeneratedKeys(): enabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(204) -Connection release mode: auto
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(228) -Maximum outer join fetch depth: 2
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(231) -Default batch fetch size: 1
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(235) -Generate SQL with comments: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(239) -Order SQL updates by primary key: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(243) -Order SQL inserts for batching: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(410) -Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
  2016-10-10 15:04:06 [ INFO] - org.hibernate.hql.ast.ASTQueryTranslatorFactory -ASTQueryTranslatorFactory.java(47) -Using ASTQueryTranslatorFactory
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(251) -Query language substitutions: {}
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(256) -JPA-QL strict compliance: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(261) -Second-level cache: enabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(265) -Query cache: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(395) -Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(275) -Optimize cache for minimal puts: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(284) -Structured second-level cache entries: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(304) -Echoing all SQL to stdout
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(313) -Statistics: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(317) -Deleted entity synthetic identifier rollback: disabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(332) -Default entity-mode: pojo
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(336) -Named query checking : enabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.cfg.SettingsFactory -SettingsFactory.java(340) -Check Nullability in Core (should be disabled when Bean Validation is on): enabled
  2016-10-10 15:04:06 [ INFO] - org.hibernate.impl.SessionFactoryImpl -SessionFactoryImpl.java(199) -building session factory
  2016-10-10 15:04:06 [ INFO] - org.hibernate.impl.SessionFactoryObjectFactory -SessionFactoryObjectFactory.java(105) -Not binding factory to JNDI, no JNDI name configured
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.SchemaUpdate -SchemaUpdate.java(155) -Running hbm2ddl schema update
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.SchemaUpdate -SchemaUpdate.java(167) -fetching database metadata
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.SchemaUpdate -SchemaUpdate.java(179) -updating schema
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(65) -table found: mi.domainclass
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(66) -columns: [id, decode, create_date, create_by, name, tab, update_date, update_by]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(68) -foreign keys: []
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(69) -indexes: [primary]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(65) -table found: mi.domainrear
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(66) -columns: [id, create_date, create_by, name, tab, update_date, update_by]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(68) -foreign keys: []
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(69) -indexes: [primary]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(65) -table found: mi.mi
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(66) -columns: [id, time, decode, pcount, domext, money, domain, type]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(68) -foreign keys: []
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(69) -indexes: [primary]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(65) -table found: mi.mishow
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(66) -columns: [id, upordown, pcount, decode, name, money, nowmaxmoney, nowminmoney, avemoney]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(68) -foreign keys: []
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(69) -indexes: [primary]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(65) -table found: mi.mishowall
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(66) -columns: [id, upordown, pcount, decode, domext, name, money, nowmaxmoney, nowminmoney, avemoney]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(68) -foreign keys: []
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.TableMetadata -TableMetadata.java(69) -indexes: [primary]
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.DatabaseMetadata -DatabaseMetadata.java(119) -table not found: schedulejob
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.DatabaseMetadata -DatabaseMetadata.java(119) -table not found: schedulejob
  2016-10-10 15:04:06 [ERROR] - org.hibernate.tool.hbm2ddl.SchemaUpdate -SchemaUpdate.java(212) -Unsuccessful: create table schedulejob (id integer not null auto_increment, jobname varchar(255), jobgroup varchar(255), jobstatus varchar(255), cronexpression varchar(255), desc varchar(255), primary key (id))
  2016-10-10 15:04:06 [ERROR] - org.hibernate.tool.hbm2ddl.SchemaUpdate -SchemaUpdate.java(213) -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 'desc varchar(255), primary key (id))' at line 1
  2016-10-10 15:04:06 [ INFO] - org.hibernate.tool.hbm2ddl.SchemaUpdate -SchemaUpdate.java(217) -schema update complete
  2016-10-10 15:04:06 [ INFO] - org.springframework.orm.hibernate3.HibernateTransactionManager -HibernateTransactionManager.java(415) -Using DataSource [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgey2p9j1c43kk91cxxfjm|5bf9dff9, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgey2p9j1c43kk91cxxfjm|5bf9dff9, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/mi, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 2, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] of Hibernate SessionFactory for HibernateTransactionManager
  2016-10-10 15:04:07 [ INFO] - org.quartz.impl.StdSchedulerFactory -StdSchedulerFactory.java(1184) -Using default implementation for ThreadExecutor
  2016-10-10 15:04:07 [ INFO] - org.quartz.core.SchedulerSignalerImpl -SchedulerSignalerImpl.java(61) -Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  2016-10-10 15:04:07 [ INFO] - org.quartz.core.QuartzScheduler -QuartzScheduler.java(240) -Quartz Scheduler v.2.2.1 created.
  2016-10-10 15:04:07 [ INFO] - org.quartz.simpl.RAMJobStore -RAMJobStore.java(155) -RAMJobStore initialized.
  2016-10-10 15:04:07 [ INFO] - org.quartz.core.QuartzScheduler -QuartzScheduler.java(305) -Scheduler meta-data: Quartz Scheduler (v2.2.1) 'Scheduler' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

  2016-10-10 15:04:07 [ INFO] - org.quartz.impl.StdSchedulerFactory -StdSchedulerFactory.java(1339) -Quartz scheduler 'Scheduler' initialized from an externally provided properties instance.
  2016-10-10 15:04:07 [ INFO] - org.quartz.impl.StdSchedulerFactory -StdSchedulerFactory.java(1343) -Quartz scheduler version: 2.2.1
  2016-10-10 15:04:07 [ INFO] - org.quartz.core.QuartzScheduler -QuartzScheduler.java(2311) -JobFactory set to: [email protected]
  2016-10-10 15:04:07 [ INFO] - org.springframework.context.support.DefaultLifecycleProcessor -DefaultLifecycleProcessor.java(334) -Starting beans in phase 2147483647
  2016-10-10 15:04:07 [ INFO] - org.springframework.scheduling.quartz.SchedulerFactoryBean -SchedulerFactoryBean.java(648) -Starting Quartz Scheduler now
  2016-10-10 15:04:07 [ INFO] - org.quartz.core.QuartzScheduler -QuartzScheduler.java(575) -Scheduler Scheduler_$_NON_CLUSTERED started.
  2016-10-10 15:04:07 [ INFO] - org.springframework.web.context.ContextLoader -ContextLoader.java(301) -Root WebApplicationContext: initialization completed in 5707 ms
  2016-10-10 15:04:07 [ INFO] - com.opensymphony.xwork2.config.providers.XmlConfigurationProvider -CommonsLogger.java(42) -Parsing configuration file [struts-default.xml]
  2016-10-10 15:04:07 [ INFO] - com.opensymphony.xwork2.config.providers.XmlConfigurationProvider -CommonsLogger.java(42) -Parsing configuration file [struts-plugin.xml]
  2016-10-10 15:04:07 [ INFO] - com.opensymphony.xwork2.config.providers.XmlConfigurationProvider -CommonsLogger.java(42) -Parsing configuration file [struts.xml]
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (spring) for class com.opensymphony.xwork2.ObjectFactory
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for class com.opensymphony.xwork2.conversion.impl.XWorkConverter
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface com.opensymphony.xwork2.TextProvider
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface com.opensymphony.xwork2.ActionProxyFactory
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface com.opensymphony.xwork2.conversion.ObjectTypeDeterminer
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface org.apache.struts2.dispatcher.mapper.ActionMapper
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (jakarta) for interface org.apache.struts2.dispatcher.multipart.MultiPartRequest
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for class org.apache.struts2.views.freemarker.FreemarkerManager
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface org.apache.struts2.components.UrlRenderer
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface com.opensymphony.xwork2.validator.ActionValidatorManager
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface com.opensymphony.xwork2.util.ValueStackFactory
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface com.opensymphony.xwork2.util.reflection.ReflectionProvider
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface com.opensymphony.xwork2.util.reflection.ReflectionContextFactory
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface com.opensymphony.xwork2.util.PatternMatcher
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface org.apache.struts2.dispatcher.StaticContentLoader
  2016-10-10 15:04:07 [ INFO] - org.apache.struts2.config.BeanSelectionProvider -CommonsLogger.java(42) -Choosing bean (struts) for interface com.opensymphony.xwork2.UnknownHandlerManager
  2016-10-10 15:04:08 [ INFO] - org.apache.struts2.spring.StrutsSpringObjectFactory -CommonsLogger.java(42) -Initializing Struts-Spring integration...
  2016-10-10 15:04:08 [ INFO] - com.opensymphony.xwork2.spring.SpringObjectFactory -CommonsLogger.java(42) -Setting autowire strategy to name
  2016-10-10 15:04:08 [ INFO] - org.apache.struts2.spring.StrutsSpringObjectFactory -CommonsLogger.java(42) -... initialized Struts-Spring integration successfully
  十月 10, 2016 3:04:09 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-bio-8342"]
十月 10, 2016 3:04:09 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-bio-8009"]
十月 10, 2016 3:04:09 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 14488 ms


       刚开始的时候,没有仔细看错误信息,网上各种百度,根据百度的一处信息得到了提示,  http://blog.csdn.net/vanezuo/article/details/6686089,后来又仔细查看了日志信息(第141行)。发现是实体中的一个属性desc和SQL语句中的desc关键字重复了,所以导致实体映射生成数据表的时候不能成功生成。之后,把desc字段改成descp问题就解决了!

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/samile6899/article/details/52787435

智能推荐

用java编程实现基于管程法的消费者生产者模式_振云博客的博客-程序员秘密

/** * 测试:生产者消费者模型-->利用缓冲区解决:管程法 * * @author * *///生产者,消费者,产品,缓冲区public class testPC { public static void main(String[] args) { // 新建一个空的容器 SynContainer container = new SynContainer(); // 开启生产者线程,并将其放入容器中 new Productor(container).start()

发掘女性“数”能量,绽放科技新魅力_Informatica-小殷的博客-程序员秘密

曾有人说,女人与数字科技绝缘,她们对“0”和“1”的世界天生就没有感觉。但你知道吗?世界上第一位电脑程序员是女性!19世纪中期,数学家Ada Lovelace是第一个认识到机器除了单纯的计算以外,还有其他的用途,她进而发表了第一个算法,被视为历史上第一个电脑程序员。今天,以数字化、智能化和自动化为标志的技术变革正在影响几乎所有的行业,女性凭借同理心设计更好的产品;女性怀着对世界和他人强烈...

多数据源/动态数据源的解决方案_程大帅气的博客-程序员秘密_动态多数据源

多数据源/动态数据源的解决方案一. DAO层的解决方案1.配置数据源2.创建切点注解3.AbstractRoutingDataSource4.读取数据源配置5.切面拦截6.使用验证二.ORM框架层三.驱动层四.代理层五.数据库服务项目中用到了多个数据源,MySql+Oracle。一条语句的执行一般要经过以下流程:DAO、Mapper、JDBC、代理、数据库。那么就可以从这几个方面入手来解决多数据源或者动态数据源的问题。一. DAO层的解决方案在DAO层,我们可以在获取连接的时候进行拦截扩展,根据

c语言数组怎么存放坐标,在c语言中二维数组元素在内存中的存放顺序是什么_林欢喜的博客-程序员秘密

在c语言中二维数组元素在内存中的存放顺序是什么在c语言里二维数组元素在内存中是按行存放的。二维数组A[m][n],这是一个m行,n列的二维数组;设a[p][q]为A的第一个元素,则可根据“行优先顺序”存储或“列优先顺序”存储来计算元素a[i][j]的地址。在c语言里二维数组元素在内存中是按行存放的。二维数组A[m][n],这是一个m行,n列的二维数组。设a[p][q]为A的第一个元素,即二维数组的...

把枚举转化为相应的字符串_vonzhou的博客-程序员秘密_枚举转换成字符串

把枚举转化为相应的字符串     今天无意间就需要这样的一个功能,从枚举值得到对应的字符串表示,一个容易想到的方法就是再造个字符串数组,和ENUM对应起来,显然这个方法没有可扩展性;第二种方法在stackoverflow上看到的就是巧妙的利用 宏 来生成对应的字符串数组,感觉非常巧妙,易于扩展。下面是这两种方法的代码。#include#includeenum

随便推点

【Dubbo分布式服务框架】4.基于API配置的服务提供者和消费者_光仔December的博客-程序员秘密

我们之前讲解了基于配置以及基于注解的服务提供者和服务消费者的开发模式,这里为大家介绍一个不常用的开发模式,这种模式不是基于注解,而是基于API的模式。一般我们开发都是基于配置或注解的,而API的模式适用于OpenAPI, ESB, Test, Mock等系统集成,所以大家了解即可。首先我们在MyEclipse里创建一个名为Dubbo-Web-Provider-API的服务提供者:

django使用RestFramework的Token认证_weixin_30340775的博客-程序员秘密

今天实现的想法有点不正规:Django Rest framework的框架的认证,API都运行良好。现在是要自己写一个function来实现用户的功能。而不是用Rest 框架里的APIVIEW这些,不涉及序列化这事。那么,我们如何来实现这种情况下的token认证呢?参考文档:https://www.jianshu.com/p/078fb116236e一,先写一个用于认证...

Hive--!= 和 <> 和 is not null区别和使用_人生路且修且行的博客-程序员秘密_hive is not null

!= 和 <> 和 is not null//不会查出字段是null的数据SELECT * FROM table WHERE IsDeleted <> true AND name LIKE '%%' ;SELECT * FROM table WHERE IsDeleted != true AND Name LIKE '%%';//可以查出字段是null的数据SELECT * FROM table WHERE IsDeleted is not true AND name L

Unity ,怎么给Gameobject添加图标_虎冯河的博客-程序员秘密

PS:在Unity的Scene场景中,有时候会有很多个相同的Gameobject,为了方便观察,可以给Gameobject添加一个图标,这样就能很清晰的找到对应的Gameobject。1、选中一个Gameobject,在Inspector视图中,点击左上角的图标2、选择一个Icon图标样式3、选择Icon之后的效果。...

总结: 十分钟深入理解Java反射机制_正经程序员·的博客-程序员秘密

首先先看一下Java反射的概念JAVA反射机制是在运行状态中,对于任意一个类,都能够知道这个类的所有属性和方法;对于任意一个对象,都能够调用它的任意方法和属性;这种动态获取信息以及动态调用对象方法的功能称为java语言的反射机制。JAVA反射(放射)机制:“程序运行时,允许改变程序结构或变量类型,这种语言称为动态语言”。从这个观点看,Perl,Python,Ruby是动态语言,C++,Java,C...

edxp已激活模块_edxposed框架模块_人则水州的博客-程序员秘密

edxposed框架模块是一款体积十分小巧的手机系统框架工具。edxposed为大家准备了多款已经制作好的了框架,可以下载edxposed框架模块来体验一下不同框架的不同功能有什么样的不同体验!软件介绍edxposed框架模块是一款简洁好用的管理器工具,目前支持的功能还是不错的,拥有四种功能可以自由的进行切换,黑名单可以选中不加载框架,没选中的则全部会加载,白名单显然和黑名单是相反的,全局模式是启...

推荐文章

热门文章

相关标签