Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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£¿


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ