MySQL check the manual that corresponds to your MySQL server version for the right syntax错误

最新推荐文章于 2024-09-29 00:24:31 发布

samile6899

最新推荐文章于 2024-09-29 00:24:31 发布

阅读量7.3k

点赞数 1

CC 4.0 BY-SA版权

分类专栏：框架整合文章标签： javaee j2ee SSH jsp

本文链接：https://blog.youkuaiyun.com/samile6899/article/details/52787435

在使用JavaEE进行开发时遇到MySQL报错，提示需查阅对应MySQL服务器版本的手册以获取正确语法。这通常意味着SQL查询中存在不兼容的语法。排查和解决这类问题通常涉及到检查数据库版本、更新SQL语句以及确保数据库驱动兼容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

     最近在做一个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(3