oracleÒì¹¹Á¬½Ómysql²éѯ³ö´í
ÏÖÔÚÏëÒªÓÃoracleÁ¬½ÓÒ»¸ömysqlÊý¾Ý¿â£¬ÏÖÔÚÒѾÅäÖóɹ¦£¬µ«ÊÇÔÚ²éѯmysqlÊý¾Ý¿âµÄÊý¾Ýʱ£¬ÓдíÎó£º
oracleÓëmysqlÔÚͬһ̨·þÎñÆ÷ÉÏhp 11.23 64λ
oracle:oracle 10.2.0.1 64λ
mysql:4.0 64λ
ÎÊÌ⣺
ÔÚ²éѯmysqlÊý¾Ý¿âÖеÄÊý¾Ýʱ£¬µ±²éѯһ¸öÊý¾ÝÁ¿±È½Ï´óµÄ±í£¨20ÒÚÌõ¼Ç¼ÒÔÉÏ£©£¬µÚÒ»´Î²éѯ²»»á³öÏÖ´íÎ󣬵«ÊÇÔÚ¼ä¸ôʱ¼ä±È½Ï¶Ì£¨10ÃëÒÔÄÚ£©£¬ÔÙÓÃͬһÌõSQLÓï¾äÈ¥²éѯmysqlʱ£¬¾Í»á³öÏÖÒÔÏ´íÎó£º
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][MySQL][ODBC 3.51
Driver][mysqld-4.0.24.4(+)-log]ÎÞ·¨´ò¿ªÎļþ: './test/test123.frm'
(´íÎóºÅ: 24) (SQL State: S0002; SQL Code: 1017)
ORA-02063: preceding 2 lines from DDD
ÇëÎʸ÷룬ÊÇÄĸöÖµÉèÖÃСÁË£¬»¹ÊÇÄÄÀï³ö´íÁË¡£
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......