oracle BLOB´ó×ֶζÁд³öÏÖÎÊÌâ
ÏÂÃæÊÇÎÒÔÚÍøÉÏÕÒµÄBLOB¶Áд³ÌÐò£¬µ«ÊÇÒ»Ö±ÔËÐв»³öÀ´£¬ÓÐÒ»ÐÐ
blob = (BLOB)rst.getBlob(1);
Ò»Ö±±¨´í£¬Exception in thread "main" java.lang.UnsupportedOperationException
at sun.jdbc.odbc.JdbcOdbcResultSet.getBlob(JdbcOdbcResultSet.java:4386)
at blob.OracelBlobTest.writeBlob(OracelBlobTest.java:85)
at blob.OracelBlobTest.main(OracelBlobTest.java:149)
Çë¸ßÊÖÖ¸µãÒ»ÏÂ~~лл
package blob;
import oracle.sql.BLOB;
import java.sql.*;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.FileInputStream;
import java.io.FileOutputStream;
/**
* ×ܽ᣺
* 1.JDBCµÄAPI£ºjava.sql.Blob½Ó¿Ú£¬Ö»ÌṩÁËBLOBµÄ¶ÁÈ¡·½·¨£¬Ã»ÓÐÌṩдÈëµÄ·½·¨¡£
* 2.ORACELµÄAPI£ºoracle.sql.BLOBÊÇÒ»¸öÀ࣬ËüʵÏÖÁËjava.sql.Blob½Ó¿Ú£¬²¢ÇÒÌṩÁËÏòBLOBÖÐдÈëÊý¾ÝµÄ·½·¨
* 3.ÔÚÏòÊý¾Ý¿âÖвåÈëBLOBʱ£¬Ö»ÄÜÓÃORACELÌṩµÄAPI£ºoracel.sql.BLOB
* дÈëµÄ²½Ö裺1>²åÈëÒ»Ìõ¼Ç¼£¬ÆäÖÐBLOB×Ö¶ÎÓÃoracleµÄ¿Õº¯Êý£ºempty_blob()´úÌæ¡£
* 2>ÒÔ¼ÓËøµÄ·½Ê½¶ÁÈ¡¸Õ²åÈëµÄ¼Ç¼£¬
* 3>ÀûÓÃoracleµÄoracle.sql.BLOBµÄgetBinaryOutputStream()·½·¨»ñÈ¡BLOB×ֶεÄÊä³öÁ÷£¬ÏòÁ÷ÖÐдÈëÊý¾Ý
* 4>Óñ»Ð´ÈëµÄBLOBÊý¾Ý£¬¸üÐÂԼǼ
* 4.ÔÚ´ÓÊý¾Ý¿âÖжÁÈ¡BLOBʱ£¬¼È¿ÉÒÔʹÓÃjava.sql.Blob£¬Ò²¿ÉÒÔʹÓÃoracel.sql.BLOB
* ¶ÁÈ¡µÄ²½Ö裺1&
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
»·¾³£º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»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
CREATE OR REPLACE PROCEDURE proc_ct_11(
quhao in varchar
)
IS
CURSOR ct_filter
IS
SELECT br_number, br_company ......