oracle 11gÓëmysqlµÄÒì¹¹Á¬½Ó
ÎÒÏÖÔÚÓÐÁ½ÖÖÊý¾Ý¿â£¬Ò»¸öΪoracle 11g£¬°æ±¾Îª£º11.1.0.6.0 - 64bit£¬°²×°ÔÚHP-IA64µÄ·þÎñÆ÷ÉÏ£¬Ò»¸öΪmysql 5.1£¬°²×°ÔÚͬһ̨·þÎñÆ÷ÖС£
ÏÖÔÚҪʵÏÖoracleµÄÊý¾Ý¿âÄܹ»²éѯmysqlÊý¾Ý¿âµÄ±í£¬ÏëҪͨ¹ýoracleµÄÒì¹¹¹¦ÄÜÀ´ÊµÏÖ£¬µ«ÓÉÓÚСµÜ¶ÔÊý¾Ý¿âÁ˽ⲻÉ»¹Çë¸÷λ°ïæ¡£
ÒÔÏÂΪÎҵĸ÷¸öÅäÖÃÎļþ£¬²»ÖªµÀ´íÎó³öÔÚÄĶùÀïÁË£º
1¡¢ÓÉÓÚoracle 11gûÓÐÁËhsodbc£¬ÐèÒª²ÉÓÃdg4odbc£¬dg4odbcÔËÐÐÕý³££º
$ dg4odbc
Oracle Corporation --- TUESDAY NOV 17 2009 16:36:56.450
Heterogeneous Agent Release 11.1.0.6.0 - 64bit Production Built with
Oracle Database Gateway for ODBC
2¡¢odbc.iniÎļþ£º
[localdp]
Description = hsdp
Driver = /app/lib/libmyodbc3_r-3.51.25.so
Server = localhost
Database = dp
Port = 3306
UID = root
Password = 123456
Socket =
Option = 7340295
Stmt =
3¡¢isqlÔËÐÐÕý³££º
$ isql -v localdp
+---------------------------------------+
| Connected!
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......