Çó½â MyEclipseÖÐÉèÖÃÁ¬½ÓOracle 10g³öÏÖµÄÎÊÌâ
ÈçÌâ¡£
¸ÕÔÚ×Ô¼ºµÄµçÄÔÀï°²×°ÀïOracle 10g
ÓÃMyEclipseÉèÖÃÁ¬½Ó£¬³öÏÖÈçÏ´íÎóÌáʾ£¬ÇëÎʸ÷λ¸ßÊÖÄÄÀï³öÁËÎÊÌ⣺¶àлָ½Ì£¡
Error while performing database login with the Oracle driver:
Io exception: The Network Adapter could not establish the connection
---------------------
ÔÚEclipseµÄDB BrowserÖÐ×öµÄÉèÖÃÈçÏ£º
Driver name £ºOracle
Connection URL : jdbc:oracle:thin:@localhost:1521:test
User name : scott
Password : tiger
Driver JARs: D:\lib\ojdbc14.jar
Driver classname: oracle.jdbc.driver.Oracle
¶àлָ½Ì£¡
lsnrctl start
ÕâÊÇʲô¶«¶«°¡£¬²»ºÃÒâ˼£¬°³Ð¡°×£¬ÇëÖ¸½Ì~
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æÈ¨ËùÓÐ 1985-2001 Microsoft Corp.
C:\Documents and Settings\user.HQ-TEXT>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-10ÔÂ-2009 17:4
3:58
Copyright (c) 1991, 2005, Oracle. All rights reserved.
TNS-01106: ʹÓÃÃû³ÆLISTENERµÄ¼àÌý³ÌÐòÒѾÆô¶¯
C:\Documents and Settings\user.HQ-TEXT>
Çý¶¯°ü²»ÊÇ*12.jarÂ𣿠ʲôʱºò±ä³É14ÁË...
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
Ôõô½«·ûºÅµ¥ÒýºÅ²åÈëORACLEÊý¾Ý¿âµÄ±íÖÐÈ¥°¡£¿
лл¸÷λ.
SQL code:
SQL> insert into test values('''');
ÒÑ´´½¨ 1 ÐС£
SQL> select * from test;
ID
----------
'
¿ÉÒÔÓÃÁ½¸öµ¥ÒýºÅÀ´±íʾ ......