Çë½Ì´ó¼Ò¸öOracleÊý¾Ý¿âµÄÎÊÌ⣬Oracle×Ô´øµÄJDKÊÇ1.4µÄ ÎÒÏÈÇ°°²×°ÁËÒ»¸ö1.6µÄ£¬ÎÒµÄeclipseÖ»Ö§³Ö1.5°æ±¾ÒÔÉϵģ¬ÏÖÔÚÎÒ¼ÈÒª°²×°Oracle£¬ÓÖҪʹÓÃʹÓÃeclipse£¬Ôõô½â¾öÕâ¸öÎÊÌ⣿лл£¡
ÔÚeclipse ÀïÖ¸¶¨ÏÂjdk Ŀ¼¾Í¿ÉÒÔÁË
ÄãÒªÓÃ1.5 µÄ£¬Äã¾ÍÖ¸Ïòjdk1.5µÄĿ¼
Èç¹û ÄãÓÃdos±àÒ룬ÔÚ»·¾³±äÁ¿ °Ñjdk 1.5  ......
¸÷λ´óϺºÃ£¬ËÓÐÍùÄêOracle ·½ÃæµÄ±ÊÊÔÃæÊÔÑùÌâ »òÕßÊDzμӹ¤×÷µÄ´ó¸ç´ó½ã£¬¸øСµÜЩ½¨Ò飬ÔÚOracle±ÊÊÔÃæÊÔ¹ý³ÌÖо³£±»Îʵ½µÄÎÊÌ⣬ÖصãÖ®ÀàµÄ֪ʶµã£¬Ð»Ð»ÁË£¬ÓÐÑùÌâµÄ·¢ÓÊÏäÖÁminjun0901@sina.com (google ÉÏËѵ½Ò»Ð©£¬Ò»ÊäÈëOracle±ÊÊÔÃæÊÔ¾ÍÄÜËѵ½µÄ¾ÍÃâÁ˹þ)лл´ó¼ÒÁË
¾«»ªÇøÓм¸¸öÌûÊÇÌâ¿âÊÕ¼¯µÄ
Ö§³ÖÏ ......
³õѧORACLE£¬Ö®Ç°¿´¹ýµÄ¶¼ÊÇЩ¹ÜÀí·½ÃæµÄÊ飬¹Ù·½Îĵµ¿´¹ýCONCEPTS,ADMINISTRATOR'S GUIDE£¨ÕýÔÚ¿´£©
¿ÉºÃÏñ¸Õ±ÏÒµ¾Í¸ã¹ÜÀí²»Ì«ÏÖʵ£¬²îµÄ֪ʶҲ»¹Í¦¶à£¬ËùÒÔÏë´Ó¿ª·¢ÏÈ×öÆð
×î½ü¿´µ½Óмҹ«Ë¾ÔÚÕÐORACLEÓ¦ÓÃÊý¾Ý¿â¿ª·¢µÄ£¬ÒªÇóÉÏдµÄÊÇ ¡°ÊìϤORACLE ,PL/SQL,LINUX,SHELL¡±
ÎÒÏÖÔÚ¿´Ò»±¾ÖÐÎÄÊé½Ð¡¶ORA ......
ÇëÎʸ÷λ´óÏÀÏÂÃæµÄÁ½¸öSQLÓï¾äÊÇ·ñ¿ÉÒÔÓÅ»¯£¬ÏÖÔÚ²éѯËٶȱȽÏÂý£¬´óÔ¼ÐèÒª10Ãë×óÓÒ
1¡¢
SELECT GD_WPARTKEY.K_ID, GD_WPARTKEY.K_NAME, GD_WPARTKEY.C_CARTYPE,
GD_WPARTKEY.K_REMARK, GD_WPARTKEY.U_ID, GD_WPARTKEY.F_ID,
GD_WPARTKEY.K_WM, GD_WPARTKEY.K_XH ......
×î½ü¸ãÁËÒ»¸ö³ÌÐò£¨VB£©¡£·þÎñÆ÷ÉÏ×°oracle10¡£³ÌÐòÔÚ·þÎñÆ÷ÉÏÔËÐÐÎÞÎ󣬿ÉÒ»µ½¿Í»§¶Ë£¬¾Í±¨´í£¬´íÎóÊÇ12154¡£¿Í»§¶ËÒÑÅäÖú㬲âÊԳɹ¦£¬¶øÇÒ½øSQL PLUSÄÜÁ¬½Ó¡£ÎÒÓöϵã²âÊÔ£¬´íÎó³öÏÖÔÚÁ¬½ÓoracleÄÇÀï¡£Á¬½Ó×Ö·û´®ÊÇÕâÑùдµÄ£ºProvider=OraOLEDB.Oracle.1;User ID=system;Password=1;Data Source=ultrasonic;Persist Sec ......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG colu ......