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
ÇëÎʸ÷룬ÊÇÄĸöÖµÉèÖÃСÁË£¬»¹ÊÇÄÄÀï³ö´íÁË¡£
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸö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: ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......