Ãâ°²×°µÄOracle¿Í»§¶Ë
Oracle Instant ClientÊÇÃâ°²×°µÄOracle¿Í»§¶Ë£¬ÓÉÓÚËüûÓб»OracleµÄ°²×°³ÌÐòËù·â×°£¬Ê¹Óû§¸üÈÝÒ×Àí½âËüµÄ½á¹¹¡£
Instant Client¼ò½é
ÔÚÆä×îеÄVersion 11.1.0.7.0ÖУ¬°üÀ¨ÏÂÃæµÄ°ü£º
µÚÒ»¡¢»ù±¾°ü¡£
ÓÐÁ½ÖÖ£ºÈ«¹¦ÄܰüºÍ¼ò»¯°ü£¬¸ù¾ÝÐèÒªÏÂÔØ¡£
1) Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications£¬ÕâÊÇÈ«¹¦ÄÜ»ù±¾°ü¡£
instantclient-basic-win32-11.1.0.7.0.zip (46,734,555 bytes)
2) *Instant Client Package - Basic Lite: Smaller version of the
Basic, with only English error messages and Unicode, ASCII, and Western
European character set support (10.2 only)£¬ÕâÊǼò»¯°æ»ù±¾°ü¡£
instantclient-basiclite-win32-11.1.0.7.0.zip (17,667,999 bytes)
µÚ¶þ¡¢¸½¼Ó°ü¡£
1) *Instant Client Package - JDBC Supplement: Additional support for
XA, Internationalization, and RowSet operations under JDBC£¬ÕâÊÇJDBCµÄÖ§³Ö°ü¡£
instantclient-jdbc-win32-11.1.0.7.0.zip (1,562,261 bytes)
2) *Instant Client Package - SQL*Plus: Additional libraries and
executable for running SQL*Plus with Instant Client £¬ÕâÊÇSQL*PlusµÄÖ§³Ö°ü¡£
instantclient-sqlplus-win32-11.1.0.7.0.zip (789,617 bytes)
3) *Instant Client Package - SDK: Additional header files and an
example makefile for developing Oracle applications with Instant
Client £¬SDK°ü¡£
instantclient-sdk-win32-11.1.0.7.0.zip (1,068,348 bytes)
4) *Instant Client Package - ODBC: Additional libraries for enabling ODBC applications £¬ODBC°ü¡£
instantclient-odbc-win32-11.1.0.7.0.zip (728,899 bytes)
5) *Instant Client Package - WRC: Workload Replay Client used to replay workload for RAT's DB Replay Feature £¬WRC°ü¡£
instantclient-tools-win32-11.1.0.7.0.zip (6,009 bytes)
6) *Instant Client Package - Precompiler: Additional files for
"proc" binary and related files to precompile a Pro*C application and
demo £¬Ô¤±àÒë°ü£¬ÏÂÔØÊ±ÐèҪע²áÓû§¡£
°²×°ÓëÅäÖÃ
ÏÂÔØºóµÄѹËõ°üÄÚ¶¼º¬ÓÐÒ»¸öinstantclient_11_1Ŀ¼£¬½«Æä½âѹµ½Í¬Ò»¸öÎļþ¼Ð¼´¿É¡£
¼Ù¶¨Oracle inst
Ïà¹ØÎĵµ£º
BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String URL=dbmes.url;
Connection con = DriverManager.getConnection(URL,dbmes.usrname,dbmes.pwd);
try{
// ×¼±¸Óï¾äÖ´ÐжÔÏó
String bh=request.getParameter("dwmc");
Statement stmt = con.createStatement() ......
2009-04-22 22:00
À´Ô´£ºÖйú
IT
ʵÑé
ÊÒ ×÷ÕߣºØýÃû
Oracle
¿Í
»§
¶ËÓë·þ
Îñ
Æ÷¶ËµÄ
Á¬
½ÓÊÇͨ
¹ý
¿Í
»§
¶Ë
·¢
³ö
Á¬
½Ó
Çë
Çó£¬ÓÉ·þ
Îñ
Æ÷¶Ë
¼à
ÌýÆ÷
¶Ô
¿Í
»§
¶Ë
Á¬
½Ó
Çë
Çó
½ø
ÐкϷ¨
¼ì²é
£¬Èç¹û
Á¬
½Ó
Çë
ÇóÓÐЧ£¬
Ôò½ø
ÐÐ
Á¬
½Ó£¬·ñ
Ôò
¾Ü
¾ø¸ÃÁ¬
½Ó¡£ ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæÒ»Ð©£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿Í»§¶Ë£¬Ëü¿ÉÒ ......