mysql hibernate session.createSQLQuery(sql) bug
ÎÒÓÐÒ»ÌõsqlÓï¾ä·Åµ½Êý¾Ý¿âÀïÃæ
select a.ProcessId,a.FileId,a.ProcessType,a.ProcessFileName,b.FileId ,c.ProcessType ,b.LocalFilePath,c.ProcessId
from log_equity_raw_file_processing_status a join log_equity_ext_files_list b on a.FileId=b.SourceFileId
join log_equity_ext_file_processing_status c on b.FileId=c.FileId
where a.ProcessStatus=2 and a.UploadStatus=1 and a.DealStatus in(2,100) and a.LastUpdate <>a.UpdateDate and b.DownloadStatus=1 and a.ProcessType=1
¿ÉÒÔÔËÐÐÕý³££¬µ«ÊÇÓÃcreateSQLQuery(sql) Ö´ÐеÄʱºò³öÏÖһЩbug£¬
a.ProcessId a.FileId,a.ProcessType,a.ProcessFileName,b.FileId ,c.ProcessType ,b.LocalFilePath,c.ProcessId
2859 10387996 1 c:/1/xxx.zip 10387996 1 /asdfad/ 2859
Õâ¸öÊÇÓÃhibernate²éѯ³öÀ´£¬Ôõôa.ProcessId ºÍ c.ProcessId £¬a.FileIdºÍb.FileId£¬a.ProcessTypeºÍc.ProcessType ¶¼ÊǺÍaµÄÒ»Ñù£¬µ«ÊÇÔÚÊý¾Ý¿âÀïÃæ²éѯµÄʱºò£¬ËûÃǵÄÖµÊDz»Ò»ÑùµÄ£¬
Ôõô´¦ÀíÕâ¸öBUG£¿
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......