ÓÃpl/sqlÍùoracleÖвåÈësqlÊý¾ÝÔõôֹͣÁËÄÇ
½ñÌìÎÒÓÃpl/sqlÍùoracleÖвåÈëÊý¾ÝµÄÊÇʱºò£¬²»ÖªµÀΪʲôÊý¾Ý×ÜÊÇĪÃûµÄ»áÔÚij¸öµØ·½Í£Ö¹¡£
ÎÒµ¼ÈëµÄÊDZðÈ˵¼³öµÄsqlÓï¾ä¡£
Ëûµ¼³öµÄ¶¼ÊÇsql£¬ËùÒÔÎÒÖ±½Ó´ò¿ªµÄpl/sql£¬ÃüÁî´°¿Ú£¬Ö±½Ó°ÑËûµ¼³öµÄsqlÓï¾äÖ±½Ó¸´ÖÆÕ³Ìù¡£
ÎÒ¾õµÄÕâÖÖ·½·¨Ã»ÓÐ´í°¡£¬ÎªÊ²Ã´ÕâÑù˵ÄÇ£¬Ö÷ÒªÊÇ£¬ÉÏÖܵÄʱºòÒ²ÊÇÕâôµ¼ÈëµÄ¾ÍûÓÐÊÂÇé¡£
ÏÖÔÚµÄÊý¾Ý¿â±íºÍÔÀ´µÄÇø±ð¾ÍÔÚÓÚ£¬±í¾Í±äÁËÒ»¸ö×ֶΣ¬½É¿îÈÕÆÚ¸ÄΪÈÕÆÚÐ͵ÄÁË¡£ÆäËûµÄ¶¼Ã»Óб䣬¡£
ÓÉÓÚÊý¾ÝÁ¿ºÜ´ó¡£ÎÒ½ñÌì²åÈëÁË3±é¡£ÕâÊǵÚ3±é£¬»¹ÊÇ»áĪÃûÆäÃîµÄÔÚij¸öµØ·½¿¨Ö÷¡£
¿¨×¡ºó£¬ÔÙÇûسµ¾ÍûÓз´Ó¦ÁË¡£
ÕâÊÇÔõô»ØÊÂÄÇ£¬
PS:
ÔÚ²åÈë֮ǰ£¬ÎÒÒѾ°ÑÔÀ´µÄÊý¾ÝºÍ±í¿Õ¼ä»¹ÓÐÓû§¶¼É¾³ýÁË¡£²»´æÔÚÖØ¸´ÎÊÌâ¡£
´óÏÀÇó¾È£¬ÕâÊÇΪʲô°¡£¬ÎÒÔÚÏߵȡ£
Êý¾ÝÁ¿Ì«´óÁË°É Òª·ÖÅú²åÈë Ö´ÐÐcommit ÔÙ×öÏ´βÙ×÷
¸ø³öÏêϸµÄÇé¿ö¡£±ÈÈçSQL½Å±¾¼°Êý¾ÝÁ¿¡£
PL/SQLÀïSQL´°Ö´ÐÐʱ£¬Ã»·¨Çûسµ¡£
Èç¹ûÊÇÃüÁî´°£¬ÃèÊöÏêϸ֢״¡£
·ÖÅú´ÎÖ´ÐвåÈ룬ÿÅúÖ´ÐÐÍê±ÏÖ±½Ócommit£¬Ã¿Åú½¨ÒéÊý¾ÝÌõÊý²»³¬¹ý100Ìõ¡£Óöµ½ÈÕÆÚµÄÒªÓÃto_dateת»»³ÉÈÕÆÚÐÍ
½É¿îÈÕÆÚ¸ÄΪÈÕÆÚÐ͵Ä
ÊÇ·ñ²åÈëµÄÀàÐÍûÓÐ×ö±ä»»£¿»òÕ߱任µÄÀàÐͲ»Ò»Ö£¬Óï¾äºÍÊý¾Ý£¬±í½á¹¹
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......