Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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&


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

Çë½ÌDRIVER={Microsoft ODBC for Oracle} Á¬½ÓÎÊÌ⣡

ÊÇÕâÑùµÄÎÒ×°ÁËһ̨2003µÄÐéÄâ»ú£¡

ÐéÄâ»úIP£º192.168.1.108
±¾»úIP£º192.168.1.100

ÎÒÔÚÐéÄâ»úÉÏ×°ÁËoracle 10G ,ÏÖÔÚÏë±àд¸ö³ÌÐò¶ÁÈ¡oracleÊý¾Ý¿âÀïµÄ¼Ç¼£¬

ÎÒÔÚ±¾»ú×°Á˸öoracle XE Cl ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

Oracle ÈÕÆÚ²éѯÎÊÌâ

ÎÒÓÐÒ»ÕűíÓиö×Ö¶ÎÃû³ÆÊÇstarttime ÀàÐÍÊÇDATE ,ÆäÖÐÓÐÒ»ÐеÄÖµÊÇ"11:00:00",ÎÒÏë°ÑÕâÒ»ÁÐÑ¡³öÀ´,Óï¾äÈçÏÂ:
select * from routebanci where starttime='11:00:00' and routename='*** ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ