oracleÊý¾Ý¿âÇý¶¯ÎÞ·¨¼ÓÔØ - Java / Eclipse
ÎÒÓõÄÊÇMyEclipse±àÒëÆ÷ ÓõÄÊÇwindows7ϵͳ ÒÔǰjavaºÍOracleÊý¾Ý¿âÁ¬½ÓûÓгöÏÖ¹ý´íÎó ½ñÌì²»Öª±¨ÔõôÁ˳öÏÖÁËÏÂÃæµÄ´íÎó£º
ÓÉÓÚϵͳ´íÎó 1114: ¶¯Ì¬Á´½Ó¿â(DLL)³õʼ»¯Àý³Ìʧ°Ü¡£ (Oracle in OraDb10g_home1, F:\programFile\oracle\product\10.2.0\db_1\BIN\SQORA32.DLL)£¬Ö¸¶¨Çý¶¯³ÌÐòÎÞ·¨¼ÓÔØ¡£
ËÄܰïÎÒһϠ¸Ð¼¤²»¾¡
ÒÔǰ°¡£¿²»ÖªµÀàÞ¡£¡£¡£¡£ÎÒÖ»ÓùúlinuxϵÄoracle10g¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......
È磺 @superwaring("unchecked");
Õâ¸öÀïÃæ¶¼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡
ûÓùý¡£¡£
¿´jeeµÄapi
javax.persistenceÀï
@superwaring("unchecked");Ö»ÊǺöÂÔ ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......