mysqlÊý¾Ý¿âµ¼ÈëºÍµ¼³öµÄÎÊÌâ
mysqlÊý¾Ý¿âµ¼ÈëºÍµ¼³öµÄÎÊÌ⣡ ´Ó±¾µØÏòÔ¶³Ì·þÎñÆ÷µ¼ÈëÊý¾Ý£¬µ¼ÈëÒ»ÇÐÕý³£ ÓÃmyeclipseµÄ¹¤¾ßDB Browser²é¿´£¬Êý¾ÝÒ²Õý³££¬ µ«ÊÇÍøÒ³·ÃÎÊʱ±¨org.apache.jasper.JasperException: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query ÔÚmyeclipseÖÐÓÃhibernateÐÂÉú³ÉÔ¶³ÌÊý¾Ý¿â±íʱ£¬È´ÄÜÕý³£·ÃÎÊ ´ó¼ÒÖªµÀÕâÊÇʲôÔÒòÂð£¿
MY SQL °ï¶¥ÏÂÒýÓà mysqlÊý¾Ý¿âµ¼ÈëºÍµ¼³öµÄÎÊÌ⣡ ´Ó±¾µØÏòÔ¶³Ì·þÎñÆ÷µ¼ÈëÊý¾Ý£¬µ¼ÈëÒ»ÇÐÕý³£ ÓÃmyeclipseµÄ¹¤¾ßDB Browser²é¿´£¬Êý¾ÝÒ²Õý³££¬ µ«ÊÇÍøÒ³·ÃÎÊʱ±¨org.apache.jasper.JasperException: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query ÔÚmyeclipseÖÐÓÃhibernateÐÂÉú³ÉÔ¶³ÌÊý¾Ý¿â±íʱ£¬È´ÄÜÕý³£·ÃÎÊ ´ó¼ÒÖªµÀÕâÊÇʲôÔÒòÂ𣿠MYSQL? ÕâÀïÊÇMSSQL. À´´íµØ·½ÁË,°ï¶¥.
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£ ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿ ÃÜÂëÐ޸ķ½·¨£º 1.ÒÔϵͳ¹ ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏ ֱ½ÓÓÃMYSQLDUMP±¸·Ý OR ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£ http://dev.mysql.com/doc/re ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml <Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......