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 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......